Cube - Maximum number of children for a category

[Arunhamsan]

Hi,
I am trying to build a cube from a considerably huge table ( with 240,000 records) through an IQD. After running for an hour, the following message was displayed and the process got aborted.
"(TR1901) The number of children ( or parents) of a category cannot exceed 65,536."

Can we not build a cube which has more than 65,536 categories in a level ? Is this is a restriction ? If not, could you please let me know the work around ?

I thought of introducing manual levels and manual categories and split the categories across these manual levels. But, it does involve the overhead of
finding the appropriate values among the more-than-65536-values and assign them to the manual levels. Also, this needs to be done everytime manually when the cube is rebuilt. Is this correct ?

Can someone help me with this. ?

Thanks in Advance,
Arun.

 

[BruceReed]

I am fairly certain that you hit a wall with the number of children per parent.

I suggest that you split out the items into differnt parents using the source data & Impromptu. Is there any characteristic you can use for this? For example user class, item type, ABC code are all good ways to split out items.

Even if you have to use a seperate IQD, this would be better than what you have. I suggest that you do NOT do this manually as there are too many items & it will be a pain in the a** to keep updated. However if you still want to do it manually, Transformer WILL remember your manual catagories.

Good luck
Bruce