Member count limit

Hi Guys,

Is there a limit in the number of members in a dimension?

I'm having a problem in showing the other members of my dimension in the pivot table.

I've queried the dimension table and found out that the records displayed are from 1 - 32000 only. The rest were not shown in the pivot table.

Please enlighten me...

What version of Analysis Services you are using: 2000 or 2005?

But anyhow. It looks like you are running into the limitations of pivot table. Try running your query in some other client tool.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Larry is using Analysis Services 2005 along with the new Pivot Table Services.

It seems that the limitation is only present in the page field. It doesnt display all the members of a particular parent. It stops listing somewhere around 35k of members.

Any insights on this one anyone?

|||

I would guess that is being limitation of the Pivot Tables. You can try and contact Excel product support and try and post on the Excel public newsgroup. (microsoft.public.excel or microsoft.public.excel.misc)

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

sql