Topic
  • 4 replies
  • Latest Post - ‏2013-11-13T17:54:03Z by OpherB
brunoro
brunoro
29 Posts

Pinned topic Building an Cube and get error that cannot exceed 65,536 categories.

‏2013-10-25T11:40:54Z |
 
I am building an cube that one dimensions there are more than 65,536 categories.
I read that is necessary to divide it on levels? What I can do to resolve it?
Anyone have ideia?
 
 
TR1901 The number of children (or parents) of a category cannot exceed 65,536
 

 

Thanks

  • OpherB
    OpherB
    664 Posts

    Re: Building an Cube and get error that cannot exceed 65,536 categories.

    ‏2013-10-25T15:55:38Z  

    You have mis-read the error. Transformer will support over 2 million categories. The error is that ONE category has more than 65,536 children.

    You should look at the Transformer User Guide on how to create a hierarchy within a Dimension.

    Good luck,
    Opher

     

  • brunoro
    brunoro
    29 Posts

    Re: Building an Cube and get error that cannot exceed 65,536 categories.

    ‏2013-10-25T18:05:15Z  
    • OpherB
    • ‏2013-10-25T15:55:38Z

    You have mis-read the error. Transformer will support over 2 million categories. The error is that ONE category has more than 65,536 children.

    You should look at the Transformer User Guide on how to create a hierarchy within a Dimension.

    Good luck,
    Opher

     

    Oh yeah..this is correct sorry.

    I'll try create a hierarchy then!

     

    Thanks.

  • brunoro
    brunoro
    29 Posts

    Re: Building an Cube and get error that cannot exceed 65,536 categories.

    ‏2013-11-12T21:13:22Z  
    • brunoro
    • ‏2013-10-25T18:05:15Z

    Oh yeah..this is correct sorry.

    I'll try create a hierarchy then!

     

    Thanks.

    Hello Opher,

     

    I am not ok how I can build a hierarchy in levels?

    I found this solution by IBM, but I dont know where exaclty I need create the levels.

    http://www-01.ibm.com/support/docview.wss?uid=swg21341611

    Thanks,

    Brunoro

  • OpherB
    OpherB
    664 Posts

    Re: Building an Cube and get error that cannot exceed 65,536 categories.

    ‏2013-11-13T17:54:03Z  
    • brunoro
    • ‏2013-11-12T21:13:22Z

    Hello Opher,

     

    I am not ok how I can build a hierarchy in levels?

    I found this solution by IBM, but I dont know where exaclty I need create the levels.

    http://www-01.ibm.com/support/docview.wss?uid=swg21341611

    Thanks,

    Brunoro

    In one of the Dimensions of the model there are many more categories than in the others. Open the Dimension Map and turn on the Category Count - it should be obvious where the new level(s) need to be added.

    Good luck,
    Opher