Consolidation - disadvantages?

hiba010203

Hi,
I've a requirement to club a few stores in the location/geography dimension and to find the sum of the sales figure. Though we've defined an flag attribute (Y/N), i presume we can only use the attribute to create a subset of stores which have the attribute as 'Y' or 'N' - and not create a consolidation of such stores. So I'm into creating a new consolidation by altering my dimension manually. Here I would like to know the following:

Think of a location dimension, and we have the following consolidations:
C1
---S1
---S2

C2
---S2
---S3

C3
---S1
---S2
---S3
a) By adding a new consolidation, does the cube re-calculate individiual stores' data (S1,S2,S3) again and again for each of the consolidations(C1,C2,C3) ?
b) By adding a new consolidations, do I increase the volume of data that the cube is holding?

Regards,
Deepu.

sunnypure

a) By adding a new consolidation, does the cube re-calculate individiual stores' data (S1,S2,S3) again and again for each of the consolidations(C1,C2,C3) ?
b) By adding a new consolidations, do I increase the volume of data that the cube is holding?

a) No.
b) No.

The reason both of these answers are no is the way TM1 stores and retrieves information. It only holds the values stored on N-elements and consolidated numbers are calculated on demand (as opposed to pre-calculated) when someone tries to retrieve them.

赏狗网

deepu_sree wrote:a) By adding a new consolidation, does the cube re-calculate individiual stores' data (S1,S2,S3) again and again for each of the consolidations(C1,C2,C3) ?
b) By adding a new consolidations, do I increase the volume of data that the cube is holding?

The previous answers are correct - no and no - but with the proviso on (b) that when you may end up using slightly more memory if someone calculates all of the consolidations. Obviously more calculated values means more memory used, though for most consolidations the effect would be negligible. (And as was stated above, the consolidation values aren't stored as part of the cube file.)

ole2002ole

Thanks a lot Alan and qml for your replies...that solves my problem..!!!