Hi Gurus,
My cube is failing with uniqueness violation during the cube build.Is there a way in Transformer where I can delete and recreate all the categories while the cube is being built everytime without using the move option.
Regards
Raj
I'm building the cube using the command line, I got rid of -s switch so that the cube model is not saved after the cube refresh, this one sort of fixed my problem.
Thanks everyone
Regards
Raj
The idea should not be just to build the cube somehow but also to make sure that the data is correct for every category. Assigning unique category values is important otherwise the data belonging to one category would get added to another one and fall of from the original one.
you need to make sure the lowest level of your dimensions is unique. for example in product dimension, if lowest level is model, you should have a unique model id.
Thanks CognosTechie & Khayman, they are unique and i dont want the categories to be saved in my mdl file which would result in slight lag while opening the file from Transformer.
try this:
clean house and save. by this time, no more category in your MDL.
everytime you open your MDL and generate a cube, after cube deploys, close MDL and do NOT save your cube