Problem with security rights and public on BI (+)

[avvoronkov]

Hi all
I have some problem, maybe you can help me.
I have cube and dimension pic1. and pic.2



I give security rights only on 2 elements pic.3, and I see it on pic.4



But if I published this cube on BI portal (Analysis studio), I not see any elements.


thanks

[Neil Watson]

Hello there,

There are a number of things to check,

1. Have you set the TM1 cube properties - you need to specify a measures and a time diemsnion for some parts of BI (tm1->cubename->Right Click->Properties
2. Have you set the }HierarchyProperties cube - you need to give the the levels in a tm1 dimension hierarchy names.(Show Control Objects)
3. There is a known issue with BI and tm1 hierarchy security, if you give full access to all the elements in the dimension, Does it appear?
If so then you have to work around the security issue. this can be achieved by implementing a "mirror" cube which has the security dimension as flat. You can rule the data in quite easily so the overhead is not too bad and still apply the desired security to the flat dimension.

Hope this helps
Neil