on 04-18-2008 12:11 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
We are running 5.1 SP2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.