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

 

Propagate Security Defined for Essbase Cube into Cognos for Data Level Security

Started by anggereaniam, 15 Aug 2016 01:25:20 AM

Previous topic - Next topic

anggereaniam

Hi All,

I'm having problem about setting security for data level in Essbase Cube

In here We make a active report. We use Cognos 10.2.2 and Essbase cube as a data source. As we know, In cube there are members.
I have user A and user B. For example I have a month dimension which is have January, February as a members. And what I ask is  how make user A can access all of the members in month dimension? but user B only can access January? Do you know how to make security in members of Cube?

Please let me know if you have an idea

Thank you so much :)

MFGF

Quote from: anggereaniam on 15 Aug 2016 01:25:20 AM
Hi All,

I'm having problem about setting security for data level in Essbase Cube

In here We make a active report. We use Cognos 10.2.2 and Essbase cube as a data source. As we know, In cube there are members.
I have user A and user B. For example I have a month dimension which is have January, February as a members. And what I ask is  how make user A can access all of the members in month dimension? but user B only can access January? Do you know how to make security in members of Cube?

Please let me know if you have an idea

Thank you so much :)

Hi,

Unfortunately this is a challenge in Essbase rather than Cognos. Security within a cube is defined and stored within that cube - whatever the technology of the cube. We could advise you on how to define security within Cognos cubes - (PowerCubes, Dynamic Cubes, TM1 etc) but unless you happen to stumble across a Cognoise forum member with Essbase knowledge you're unlikely to find an answer here. Have you tried any of the Oracle forums to see if other Essbase users have done this before?

Good luck!

MF.
Meep!