dbTalk Databases Forums  

Multi-dimension issue

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Multi-dimension issue in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sufo
 
Posts: n/a

Default 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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.