dbTalk Databases Forums  

Excell Add-in error when expending level exceeds 9?

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


Discuss Excell Add-in error when expending level exceeds 9? in the microsoft.public.sqlserver.olap forum.



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

Default Excell Add-in error when expending level exceeds 9? - 01-10-2005 , 04:11 PM






The account dimension in one of AS cube has over 15 levels (the dimension is
built using Parent-Child menthod). When I started drill down from the the top
level using the Excel Add-In tool, everything on the spreadsheet disappears
when drilldown reaches level 9 members. The same issue also happens when
using the original Excel pivot table.

The same problems happens even if I didn't expand the hiearchy from the top
level. I just dragged one level 9 member to the Excel spreadsheet and it
disappeared when I tried to expand the particular member.

I don't have any problems when dirlling down in Parnorama or ProClarity.
Looks like it's an Excel BUG!

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.