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

 

Cognos 10.1.1 cube showing different Hierchy on different time of refreshment

Started by bensah, 18 Sep 2013 06:47:42 PM

Previous topic - Next topic

bensah

Hi,

I have one cube where security is implemented on Territory level. ( Region->District--> territory). Custom view is defined and each custom view is mapped to one group and territory.

Example:-

Data in database:-
Region District Territory ( 01  ,  400, 441)
Cube output:- some times ( 01,600,441) and sometimes it is correct (01,400,441)

I have unchecked  the unique-->move option and removed all the saved category and recreated once again.

Still some time it is showing wrong category.

Appreciate your help.

bensah

Greetings!!!

The IBM technical person checked the transformer server and marked the unique to every possible dimensions.
We have checked the database and the values are unique.
Removed all the saved category and still issue present.

Now we have shared the system log file for our Citrix server ( Where it is working fine) and Development server.
I will update once I get any workaround / Fix from IBM.