If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cube Full Refesh

Started by raj_aries81, 05 Jun 2016 10:16:39 PM

Previous topic - Next topic

raj_aries81

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

raj_aries81

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

cognostechie

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.

Francis aka khayman

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.

raj_aries81

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.

Francis aka khayman

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