We are somewhat new to Analysis services but have designed several cubes and used this aggregated data to create reports using SQL reporting. Our next step is to use this aggregated data to identify product trends. For example we would like to identify products whose sales have declined the past two months (or whatever time period we define). I assume this type of comparison would be done using a MDX query, however I'm not quite sure where to start. Any tips are greatly appreciated

----- paulh wrote: ----

We are somewhat new to Analysis services but have designed several cubes and used this aggregated data to create reports using SQL reporting. Our next step is to use this aggregated data to identify product trends. For example we would like to identify products whose sales have declined the past two months (or whatever time period we define). I assume this type of comparison would be done using a MDX query, however I'm not quite sure where to start. Any tips are greatly appreciated