Re: Where to start?March 24 2017 at 12:25 PM
No score for this post
|Mike Henderson |
from IP address 220.127.116.11
Response to Re: Where to start?
>Some dimensions don't need to be calculated for one reason or another.
In my experience, nobody ever cares to see the rollups of Years, Scenarios, or Versions. These are typically small, non-aggregating sparse dimensions.
It is also common to set Dense dimensions (typically Period and Account) to roll up dynamically at retrieve time because all of the necessary info is present in the data block your user has pulled ... computers do math quickly but fetch blocks from memory slowly. If the block has all the info, let it compute at retrieve time.
So ... use CALCDIM to roll up only the **aggregating** Sparse dimensions while setting Dense dims to do their stuff dynamically. It seriously improves calc performance with no loss of retrieve speed.
Another item is I believe CALC DIM allows us to specify the order in which dimensions are calculated. CALCALL does them in outline order only.
A last thought ... consider using AGG instead of CALC, especially if your dimension has no member formulas. AGG is often faster since it ignores member formulas and simply rolls up according to the outline consolidation operators.
- Re: Where to start? - sameer on Mar 26, 2017, 3:35 AM
- Re: Where to start? - Jeff McAhren on Mar 27, 2017, 10:01 AM
- Re: Where to start? - Pete on Mar 27, 2017, 5:41 PM
- Here you go... - Cameron Lackpour on Mar 28, 2017, 10:37 AM
- Actually! - Pete on Mar 27, 2017, 5:52 PM
- Which brings all of this back to RTM - Cameron Lackpour on Mar 28, 2017, 10:33 AM