I have a cube with a value pre-calculated in the etl, that shows how many days a account is past due in the fact table. I need a way to either create a calculated member in MDX or create a named calculation in the dsv that will break down the days overdue as follows, and let me filter it in a cube. If it is between 1 and 29 days, then it is 'current'. IF it is 2o- 59 days, it is 'overdue', and so on. I am not sure the best way to do this. Any suggestions? Thank you!
asked Jun 15, 2012 at 04:00 PM in Default
It depends on your overal design and how frequently you are updating the cube, but whenever possible, it is better to put the caluclation of attributes into the lower levels (DSV or even better into the ETL process itself).
Once the attribute value is calculated in the loverl levers, than it's values are stored in the SSAS multidimensional model and SSAS will benefit from this (you can have aggregations defined for that attributes and also SSAS can build internal indexes to speedup filtering etc).
If you calculate a value in MDX scrip and then would like to filter the data based on this calculated value, SSAS will not benefit from the above mentioned.
answered Jun 18, 2012 at 05:09 AM