x

SSAS - Row level limitation in pivot table

Hi,

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 '10 at 02:48 PM in Default

PETER I gravatar image

PETER I
11 1 1 1

(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 '10 at 07:29 PM

Rob Farley gravatar image

Rob Farley
5.7k 15 18 20

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1936
x166
x109

asked: Jan 19 '10 at 02:48 PM

Seen: 2488 times

Last Updated: Jan 20 '10 at 11:33 PM