Load Permissions for Dimension Members

729747

Hi all bi,

my question is about permissions in oracle bi ee.

There are reports made in oracle bi answers for an essbase ASO cube.
There is an Entity Dimension. In Answers Each Entity shoud see only itself and own data. Entity dimension consists
40000 members.

Is there any possibility to load permissions for each Entity (40000 members) in Oracle BI EE from a text file and how to do it?

Any help is appreciated in this regard.
Thanks in advance.

Christian Berg-0racle

You can reuse your Essbase permissions: [http://oraclebizint.wordpress.com/2009/04/27/oracle-bi-ee-101341-hyperion-essbase-security-integration-resolved/]

729747

Ok. But after reading this article is not clear how to put user permissions in connection pool automatically. For one user it can be made manually, but i need to do it for thousends users. It is possible only automatic.
This artcile isnt answer for my question.

Thanks for help. Maybe any other solutions, suggestions?

Christian Berg-0racle

':USER' and ':PASSWORD' must be used in the connection pool in order to hand over the credentials received from the OBIEE login to Essbase. Standard connection pool configuration and hence not mentioned in the post.

Edit: read [this one|http://www.rittmanmead.com/2009/06/01/fun-and-games-with-obiee-connection-pools-and-essbase-logins/] as well.

Edited by: Christian Berg on Dec 7, 2009 9:33 AM

729747

Thanks a lot. I am trying this))

729747

Thanks a lot. Will try this)