October 13, 2008 at 8:57 am
Hi ,
i just want to know when we create calculated members( Say MTD or YTD) at cube level, the cube calculates that value and stores in cube (after Processing) or it calculates when we fire a query from report ?
if it caluclates every time we fire a query from report , thn is thr any way to store that value in cube at Cube processing time??
October 14, 2008 at 9:14 pm
The calculated measures are not stored in the cube.
Only fact measures are - depending on the storage settings leaf data and aggregations, only aggregations or neither could be stored in the cube (MOLAP, HOLAP, ROLAP).
If you have a very expensive calculation you may want to consider pre-calculating and storing it in the fact table. This could degrade performance, because the cube will get larger with each of these.
October 16, 2008 at 1:20 pm
unless you have a pretty large cube i'm not sure why you're bothered too much, at the end of the day there are calcs that can be performed easily in MDX that are very hard in SQL. The language has benefits so unless you have a problem why not use it.
HTH
Martin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply