|
I have a Summary Cube which reads data from Cube A, Cube B and Cube C via rules.
Each of this cube has 4 scenario( Summary, A, B, C).
All the 4 scenario is for "Current Version" on Summary Cube. On going i am doing archive on the current version to become Version 1, Version 2, Version 3. The archive includes all the 4 version.
The default view of Summary cube is Scenario A of the Current Version.
As the Summary Cube is taking more then 2 minutes to load the current version, i thought it may be because there are too much data in the cube due to the archive process. So I have remove the 3 scenario which may not be necessary and only left one scenario.
After removing the 3 scenario in the archive version, I try loading Scenario A of the Current Version again and the loading time doesnt seems to have improve much.
1) I would like someone to verify my conclusion that in regardless how much data there is on the Summary cube, the processing time to read data from Cube A, B and C will still be the same ?
2) If the default view loaded in Summary Cube is Scenario A, of year 2012, and I only write rules to read scenario A of year 2012, will this reduce the loading time ?
( i would say yes for question 2, but question 1 i tested it and it seems to be yes)
Let me know your feedback. |
|