(TR1901) PDS-PPE-0130

[marinak]

Hello,
I get the error (TR1901) PDS-PPE-0130 Anzahl der übergeordneten oder untergeordneten Elemente einer Kategorie darf nicht größer als 65.536 sein when I build the power cube.

How can I see in the log file, what category causes it?
What can I do to fix this problem?

Thank you

[Michael75]

Hi Marinak,

This message means that, at one of the levels (presumably the lowest) in one of the dimensions of your cube, you have exceeded the allowed limit of 65,536 categories.

I guess your first question is, which dimension and which level are concerned? I've got two ideas you can try.

1. When you have the model open in Transformer, right click on any dimension, and check the option Show Counts. This should give you an idea of where you are hitting the limit.

2. (Assuming that your cube has multiple data sources) in the Data Sources pane, right click on a "suspect" dimension query, choose Data Source Viewer, then the Native SQL tab. Copy this SQL, paste it into Toad, MS SQL Server Studio or whatever you use, and see how many rows it returns.

Post back with your results.

Viel Spaß
Michael