Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Limitation on Drop-Down in cube pivot

Author  Topic 

Harmeet.Singh
Starting Member

2 Posts

Posted - 2009-06-25 : 11:26:40
Hi,

We are facing a limitation on the number of values that can be displayed in the drop-down of a cube dimension in the pivot table. A employee name dimension contains more than 35000 values and the drop-down is able to display around 31k values only. Can someone please help on a solution? We are using Excel 2003. But do let me know even if you have a Excel 2007 solution, the first one is preferred though.

IMPOSSIBLE SAYS I AM POSSIBLE

Harmeet.Singh
Starting Member

2 Posts

Posted - 2009-06-25 : 15:16:16
I am surprised there isnt a single response yet!! has nobody faced the issue earlier or nobody knows a workaround!

IMPOSSIBLE SAYS I AM POSSIBLE
Go to Top of Page
   

- Advertisement -