dbTalk Databases Forums  

OLAP limitations of Excel Pivot Table

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


Discuss OLAP limitations of Excel Pivot Table in the microsoft.public.sqlserver.olap forum.



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

Default OLAP limitations of Excel Pivot Table - 07-07-2003 , 06:41 AM






Hari,
you might want to check with Microsoft under:

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;291061

Of course, these are only the limitations Microsoft
states itself. (And there are many more)

But the number of rows limit is something one usually
notices far too late.

HTH Lutz

Reply With Quote
  #2  
Old   
Kris
 
Posts: n/a

Default Re: OLAP limitations of Excel Pivot Table - 07-12-2003 , 04:15 PM






Hello,

Here is additional limitation for Excel.

1) Query takes very very long time when we have Complex cube like
40 dimesion with 4 mil rows. If we used Office XP web component then
performance is batter.

2) We can not connect from Excel using VPN netwrok( let me more specfic
I have problem like when i login from home using VPN to server,
I am not able to open CUBE using Excel. However i can browse cube using
Analysis manager

3) The very very important features like "Drill Through" is not Properly working
when we have more then 7 dimensions combination.

Thanks
Kris


"Lutz Morrien" <lutz.morrien (AT) ocb (DOT) com> wrote

Quote:
Hari,
you might want to check with Microsoft under:

http://support.microsoft.com/default.aspx?scid=kb;EN-
US;291061

Of course, these are only the limitations Microsoft
states itself. (And there are many more)

But the number of rows limit is something one usually
notices far too late.

HTH Lutz

Reply With Quote
  #3  
Old   
Tom Chester
 
Posts: n/a

Default Re: OLAP limitations of Excel Pivot Table - 07-13-2003 , 11:35 AM



Important? I find the drill-through feature to be borderline useless.

tom @ the domain below
www.tomchester.net


"Kris" <salotk (AT) hotmail (DOT) com> wrote

Quote:
3) The very very important features like "Drill Through" is not Properly
working
when we have more then 7 dimensions combination.



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.