SSAS - Row level limitation in pivot table


I have created pivot cube using Sqlserver 2005 (SSAS). The cube successfully refreshed with 5 dimensions in Excel 2007. Since the same is not working in Excel 2000. Find the below error message while accessing the cube in Excel 2000.

"Excel cannot display this one, bec rows has more than 65536 or columns has more than 16336 columns...."

but the cube does not exceeds the mentioned limits [ have identified thru excel 2007].

Am waiting for valuable reply..

more ▼

asked Jan 19, 2010 at 02:48 PM in Default

avatar image

11 1 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You'd be surprised... If you have attributes without relationships, you may find that the system is trying to cater for every possible (and more significantly impossible) combination. If you're pulling back the Empty cells as well, then even though there's nothing there, Excel may be trying to handle those rows.

more ▼

answered Jan 19, 2010 at 07:29 PM

avatar image

Rob Farley
5.8k 16 22 28

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 19, 2010 at 02:48 PM

Seen: 2855 times

Last Updated: Jan 20, 2010 at 11:33 PM

Copyright 2018 Redgate Software. Privacy Policy