Forum Stats

  • 3,769,356 Users
  • 2,252,953 Discussions
  • 7,874,996 Comments

Discussions

Calculator Cache calculation

User_1PL8X
User_1PL8X Member Posts: 1 Green Ribbon

Hi,

I used the following formula in essbase d_bag to calculate the calculator cache  for my application which has the following dimensions;

   

DimensionsNo. of membersStored members
Account645472
Periods2314
Currency2321
Location270195
CostCenter867184
Product27562657
Years125
Scenario139
Version2622

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?

Tagged: