spicysudhi
Programmer
Hello,
The model has TWO IQDs. There are TWO measures and each from one IQD.
Case I:
The cube built from this is about 800MB.
Case II:
If I change the IQD2 (which has measure M2) so that it results in NO DATA, then the cube size is around 400MB.
Case III:
If I change the Cube properties and remove the measure of the second IQD (ie., M2) and built the cube then the size is 600MB
Question:
With Case II and Case III, the data in the cube is same. It has only one measure. But why the difference in the size? Is it that when there is no data there are no categories generated and when there is data (though measure removed), the categories are created?
thanks.
regards,
Sudhi
The model has TWO IQDs. There are TWO measures and each from one IQD.
Case I:
The cube built from this is about 800MB.
Case II:
If I change the IQD2 (which has measure M2) so that it results in NO DATA, then the cube size is around 400MB.
Case III:
If I change the Cube properties and remove the measure of the second IQD (ie., M2) and built the cube then the size is 600MB
Question:
With Case II and Case III, the data in the cube is same. It has only one measure. But why the difference in the size? Is it that when there is no data there are no categories generated and when there is data (though measure removed), the categories are created?
thanks.
regards,
Sudhi