PivotTable limitation?

[annegattor]

Hello!

I have a problem accessing one cube in my Analisys Services Server...
The cube had many dimensions (about 9), and I want to display one of them as a row element... This is a multi-dimension with 4 levels.

I detect that when PivotTable returns the data, some fact data is missed (#N/A), although the totals are correct. I also see that some rows don't appear at all (I confirm this executing an MDX script in the Analisys Services Server).

I also see that the rows with the "#N/A" have the most large descriptions in the dimension fields, appearing to be a relation or dependency in any manner with the size of the dimension field strings...

Any idea??

Thanks in advance and excuse me for my poor english...

 

[SydneyGeek]

I haven't used pivot tables with cubes but this comment caught my attention.

I also see that the rows with the "#N/A" have the most large descriptions in the dimension fields

Pivot tables have a 255-character limit per cell. If you exceed that, you will get an error. Could that be your problem in this case?

Denis