Business Question 1: What are the top(n) products with highest sales growth  from previous year in each sales territory? Firstly, we need get the sales of previous year using ParallelPeriod method and then calculate the sales growth (%) by comparing the sales of current year aganist previous year. We will then combining GENERATE and TOPCOUNT … Continue reading MDX #5 – Product Sales Growth Analysis →

Business Question 1: How much sales percentage does each product sub-category take aganist the total sales of 'Components' cateogry in 2007 In the example above, the .parent is used to return the current product's parent category. Alternatively, ANCESTOR function can also be used which could specify the level of the category (e.g, we hope to get the percentage of current … Continue reading MDX #4 – Sales Ratio aganist Parent Levels →

Requirement: Users specify a date range by giving a Start Date and a End Date, and expect to make Year-Over-Year comparison of a measure (e.g. Sales Amount) in the given period. For example, a user input start date as "04/07/2007" and end date as "04/11/2007", and want to compare the sales between the period "04/07/2007 - 04/11/2007" … Continue reading MDX #3 – Year-Over-Year Comparison within Given Period →

To get top (n) products with highest sales in every sales territory, the GENERATE function is exactly what we need which applies a set to each member of another set.

1. Monthly or Quarterly Year-Over-Year Comparision PARALLELPERIOD is the function to get the same period in previous year. 2. YTD Year-Over-Year Comparison YTD function can be used to get the period from start of this year to current date. To get the same YTD period in last year, we could combine the YTD and PARALLELPERIOD … Continue reading MDX #1 – Year-Over-Year Comparison →