dbTalk Databases Forums  

viewing an hierarchical dimension with Excel

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


Discuss viewing an hierarchical dimension with Excel in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
bruyndoe@hotmail.com
 
Posts: n/a

Default viewing an hierarchical dimension with Excel - 07-15-2003 , 08:02 AM






HI,

with Microsoft Analysis Services I have created a cube containing an
hierarchical dimension.

the creation of the cube went fine

when I want to view the cube with Excel and I start drilling down the
dimension I get first the right data, although from a certain level
(level 9) I get wrong data (#N/A values) and the tree-structure also
goes wrong

when I view the cube with another tool (Cognos PowerPlay), I always
get the right data. So, according to me it has something to do with
Excel

Can somebody help me ?

Erik

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.