This post contains how we can create an useful security matrix in SAP BO BI using the SBOPRepositoryExplorer connector.
Shortly I want to show you next content for this example of security matrix:
1. How to extract ACLs
Using the universe provided in SBOPRepositoryExplorer and WebIntelligence:
We could use next dimensions to extract the ACLs from our CMS repository:
Next step is create some required variables for our example:
=If ([Specific Right]=0 And [Right Group Name]<>"General")
Then "Overwrite General"
Else
If ([Specific Right]=1 And [Right Group Name]<>"General")
Then "Specific Right"
=If (Count([CRole Right ID]) Where([CRole Right Granted]=1))>0
Then 1
Else
If (Count([CRole Right ID]) Where([CRole Right Granted]=0))>0
Then 0
Else Count([CRole Right ID])
Now we can create a cross-table like:
And for the values ( ) we can use conditional formatting rules:
And the final result is (example):
2. Groups and Users Relation
For this kind of content we can use different perspectives/views in function of our requirements, but anyway, we can use next basic dimensions:
Here we have an example with:
"Group Name"
"User Name"
and for the value we can define next formula:
=If Count([Group Name])>=1
Then "X"
Else ""
Other example using full path:
3. Application Rights
For applications we can use next dimensions:
A possible example:
4. Folder Rights
For folder rights we can use the same logic than application rights:
5. Universe Rights
In next example we are showing rights for universe folders:
6. Connection Rights
Like the previous one we can use next dimensions:
This is a simple way to create online our security matrix for SAP BO BI.
Thanks and enjoy!
Jorge Sousa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
10 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
2 |