COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: bensah on 18 Sep 2013 06:47:42 PM

Title: Cognos 10.1.1 cube showing different Hierchy on different time of refreshment
Post by: bensah on 18 Sep 2013 06:47:42 PM
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.
Title: Re: Cognos 10.1.1 cube showing different Hierchy on different time of refreshment
Post by: bensah on 24 Sep 2013 06:28:30 PM
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.