sensitive data for top level people only in Webi report

building reports webintelligence
1

My environment is BOXI R3.0
I want to make a webi report which include a sensitive data, e.g. salary. I want to let top management able to read this sensitive data, other s read it as “BLANK” (or not displayed) in the report.
I used “Security Access level” (Public, Confidential, Controlled, Restricted, Private), and Objects Restriction (Menu -> Tools -> Manage Security -> Manage Access Restriction), but i found that Webi report still show the sensitive data (salary) when i open the report.
It will display error when i refresh it. It only take effect when creating a new webi report (because the object hidden).
Any feature in Webi level to achieve my task?
Or it is a bug and fixed in BOXI R3.1 ?

Thanks

plkkw (BOB member since 2009-02-13)

2

for a similar business case we use a prompt and filter approach. Create a prompt on a handy dimension (one which as static value like 1) – Default value could be set to “password here”

Handy = Prompt(“Enter the password to display salary”)
OR
Handy=1

In the report tab create a variable that checks user response with a pre defined value i.e. If(userResponse(Enter password for salary)= “Passwd$$”; [Salary dimension];””)

Use this variable in the report body instead of the salary field…

Distribute password Passwd$$ to all top level employees and ask them to enter value when running report.

DhavalR :us: (BOB member since 2008-03-17)

3

you need to set the report on ‘refresh on open’.

The displayed data in the one from the last refresh ; if the refresh was done with an authorized account then sensible data will be visible.

ese-aSH :fr: (BOB member since 2007-05-22)