WEBI level restriction

[former_member586953]

Hi Techies,

I have came across an issue and don't know hot to get the solution from Google. So here is my scenario.

Scenario: I have got 3 users as A, B and C respectively who have access to a WEBI report. In the WEBI report we got data along with cross tab and pie chart.

Requirement: I want that user (A) can only refresh and view the full report. User (B) can only view the pie chart in the report only and not the data and cross tab and User (C) should view only the cross tab and not the other.

So, how to achieve this in the WEBI level. (not in the universe level). It would be better if any one could provide me the steps for this.

Thank You!

Regards.

[former_member185603 · Accepted solution]

there is nothing like that in Business objects to control restriction with in the webi report by user.

[amitrathi239]

I am not sure what is the purpose of this but this you can achieve through managing BO security and put show/hide condition in cross tab and chart.

First create three users group in BO CMC.

User A: grant view/refresh access.

User B:Grant view access.After that right click on the chart->format cross tab->General tab->check the check box "hide when formula is true" and place below formula.

=CurrentUser()="B"

Similar for user C right click on chart->format chart->General tab->check the check box "hide when formula is true" and place below formula.

=CurrentUser()="C"

[former_member586953]

Hi Amit,

Thank your for your quick response and i have tried the way you mentioned me and further i worked on it and my client is satisfied for what the requirement he desired from me.

Regards