Number of features of dimension

[jarkol]

Hello Alex.
I have a problem with the size of the OLAP cube. When the number of features for one dimension exceeds 65 000 get erroneous results. Comes to reproduce the value of this dimension.
Do you have any idea on what could be the problem and how to deal with this?
Thanks in advance for your reply.

[AlexZencovich]

Hello Alex.
I have a problem with the size of the OLAP cube. When the number of features for one dimension exceeds 65 000 get erroneous results. Comes to reproduce the value of this dimension.
Do you have any idea on what could be the problem and how to deal with this?
Thanks in advance for your reply.

That is PivotCube limitation. To save RAM we use type "word" to keep dimension items indexes. So it cannot be more than 65530 items in single dimension

[jarkol]

Thanks for the reply.
However, it does not seems too good. Do you have any idea how to deal with it without sharing the cube?

[jarkol]

Hi again.
I have a question about whether I can change the word type to the four-byte type. I have bought the source code of the PivotCube.
If possible please say where to do it.

[AlexZencovich]

By our expirience, use dimensions with a lot of items uncomfortable for user very often - it is a bit slow to open dimension editor or grid became a huge in rows etc. Usually it used with some filters only or within some "predefined" drills like dim1->dim2

You may try to change Measure_SRC.ZDType to LongWord but I cannot promise a stable work, sorry.

[jarkol]

Thank you very much for reply, I'll try.