Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table using Cube object - data overflow error
Hi,
We are using SQL Server 2005. In SSAS, we created a dimension with 10 columns from a view and it returns 3000 rows in it. We created a cube using this dimension, it has no factual data and count of that view is the only measure in this. We make use of this cube object in Microsoft Excel 2003 Pivot Table. Now, in the hierarchical report, I am able to add very limited number of columns in the output. In this report, when I try to add the fourth column, it gives the following message, "Excel cannot display this PivotTable report. The row area has more than 65,536 items, or the column area has more than 16,384 items." It varies from report to report, it happens based on the volume of data. In another report, we get this message while adding the sixth column. In the similar scenario, I get another message and it stops the Analysis Service itself, we need to restart the services, clear the pivot table and recreate it again. The following is the error message, "Internal error:An unexpected exception occured in pivot tables" When we use SQL Select statement in pivot table instead of cube object, it works pretty well as intended. Please throw some light on this and help us to overcome this problem, thank you. Regards, Deva |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table accessing data from OLAP cube | Excel Worksheet Functions | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
Pivot table causing buffer overflow | Excel Programming | |||
Pivot Table - OLAP Cube | Excel Discussion (Misc queries) | |||
connecting a pivot table to a data cube in VBA | Excel Programming |