cancel
Showing results for 
Search instead for 
Did you mean: 

Report in BPC where users can see their access rights

Former Member
0 Kudos

Is there a way to build a report in BPC where a user can see what entities he has access to and what kind of access?

br

/Peter

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

You may request a security report In 5.1sp2 following the steps below:

- start administration

- select the security task

- you can now select a security report in the action pane (reporting services must be running and configured correctly)

- if the reports are not available in the action pane, please check the taskprofile 'viewsystemreport' if you have access to the secutity reports itself.

Hope this helps,

Alwin

Former Member
0 Kudos

Alwin is correct on SP2. So, in SP2 you would have to have access to the administration client to run the reports which you would definately not what to give to end users. In SP3, they have moved the reports out into the BPC Web interface which is outside the administration client so you could give users access to the reports without them having administrative access.

Former Member
0 Kudos

We are running 5.1 SP2

Former Member
0 Kudos

I'm checking further. In a 5.1 SP3 environment, I see the reports as listed above. However, in a 5.1 SP2 environment I don't see the reports listed BUT they are in the task profile options under ViewSystemReports.

Former Member
0 Kudos

Thanks. But when I get to System Reports I can't see the Security Reports link (although I'm logged in with the installation account with all rights). Is there any setting that I miss?

Former Member
0 Kudos

What version and service pack are you on? I thought the primary admin role had system reports as part of the default profile but you could try explicitly adding them to the profile to be sure.

Former Member
0 Kudos

From version 5.1 (perhaps you need sp1, don't know this for sure), you can run security reports from Admin. These reports provide the information that you requested.

Alwin Berkhout

Former Member
0 Kudos

Good point. Yes, you can see all the security information by user, profile, team, etc from the system report. You would access them by BPC Web > Launch System Reports > Security Reports. You would have to grant permissions to run the report in their task profile from the system report group. The only thing to remember is they would have access to see anyones security not just thier own. Probably not a big deal but just keep that in mind.

Former Member
0 Kudos

You could do and EVDRE report as an expand only and put the secured dimension on the rows and use the EVMEMBERS option for the member set. That would list all members of the dimension. The user would only get members they have access to. As far as rights unless the dimension is read/write secured, then by default there is only one permission and that is read/write. There wouldn't be any to list the read-only, read/write, deny property for a R/W secured dimension in an end user report.

If I was building the report, I'd put a drop-down (data validation rule in XLS) that had the names of the secured dimensions. Reference that dimension in my row expansion in the EVDRE control panel. Choose the SupressColumn option to hide all columns. Then the user could choose a dimension in the drop-down then expand the report to see the members they have access to.