The final forecast query that's loaded to the data model for analysis and visualization will contain 120 rows in this example. This represents 12 months for the 6 regions in North America, 3 regions in Europe, and 1 Pacific region. If an additional variable were to be added to the forecast logic, such as product category allocation, the row count of the forecast query would be multiplied by the count of distinct values of this dimension.
- Create integration queries for each member of the highest level of the hierarchy (Europe, Pacific, and North America).
- Apply the forecast allocation variables at each level in the M queries to construct a common report data structure (which ...
