Multi-dimension issue -
05-21-2004
, 05:51 AM
Hi,
I am creating a cube with 3 dimension which is Unit (3
members), Area (30 members), Customer (9075 members). I
try to define my own drill down level in data viewing tab
at Analysis Manager, 1st level is Unit, 2nd level is Area
and 3rd level is Customer. When there is only 2 levels
added, the the speed on loading the data is still okie,
but when I added in the 3rd level which is Customer, my
pc will hangs.
I tried to connect this cube by using MS Excel and
view/defined my own levelling (as mentioned above) in
Pivot table, and I found that eventhough it take some
time but the data still able to be populated out without
hanged my pc.
For information, I am using Pentium 4, 2GHz and 256 MB
of RAM on populating the data.
Is there something I should be doing different or is
that my pc spec problem or is that problem on Analysis
Manager?
If you would point me at a detailed, it would be greatly
appreciated.
Thanks
Sufo |