Hi,
I used the following formula in essbase d_bag to calculate the calculator cache for my application which has the following dimensions;
| Dimensions | No. of members | Stored members |
| Account | 645 | 472 |
| Periods | 23 | 14 |
| Currency | 23 | 21 |
| Location | 270 | 195 |
| CostCenter | 867 | 184 |
| Product | 2756 | 2657 |
| Years | 12 | 5 |
| Scenario | 13 | 9 |
| Version | 26 | 22 |
my cache setting in the config file are
CALCCACHEDEFAULT 10000000
CALCCACHEHIGH 200000000
CALCCACHELOW 200000
I'm trying to find the bitmap and anchor dimension for each setting while running CALC ALL;
For this particular ordering of dimensions, I get Product as the anchor for all three settings;
Calculator Cache With Single Bitmap For: [Product]
But when I calculate the calculator cache size;
I get Calculator Cache = 673008.75 * 1 = 673008.75 bytes which is 0.64183116 MB
This value is more than 0.2 MB which I have set for CALCCACHELOW, shouldn't CostCenter have been the anchor when the cache size is low?
Can someone please explain to me how its calculated, I assume you multiply the no. of members or is it the stored members?