Unique Category problem 1

[spicysudhi]

hi

the cube generation is failing bcoz of the unique category issue.

Actually dimension contains two levels say DEPTNO and EMPNO, I have EMPNO as unique.

First time when i generate cube, its working fine (bcoz EMPNO in database is unique.

After this, I update the database table and changed the DEPTNO for an EMPNO (say from 10 to 20). Now the cube generation is failing bcos it says there exists already a category under dept no 10 and cannot add the same empno under 20 now.

How to overcome this problem, actually my table got unique empnos, but bcoz the earlier generated categories still exists in the model, its resulting error during cube genration.

thanks in advance.

regards,
sudhi

 

[drlex]

Sudhi,
In the Source tab of the properties window of the level, with the unique button ticked, click on the move button to add a tick. This will allow the level to move in relation to the upper level (does that sound ok?).
Otherwise, clear the diagram by selecting all items in the level and delete, to force a rebuild of the level diagram.
lex

"Time flies like an arrow, but fruit flies like a banana."

 

[spicysudhi]

lex, many thanks for the immediate reply and for the first line from ur solution perfectly suits. i am building cubes using macro and hence, everytime i cannot delete the categories generated. the MOVE option fitted well with my requirement.

thanks and a star for you

sudhi

sudhi@sudhi.com

 

[drlex]

Sudhi,
thank you; you're too kind!
If you get into further problems with Uniqueness, remember the trick of combining data items eg DEPTNO + EMPNO to make another data field which should be unique and can be labelled as EMPNO.
lex

"Time flies like an arrow, but fruit flies like a banana."