BusinessObjects Board

Single report for multiple user with column level restrictio

building reports desktopintelligence
#1

Hi,

Requirement is like i have to publish single report to multiple users and no. of columns on the report will be displayed as per there access.

For example, my report contains 5 columns as Cust no., Name, Birth date, city and Due amount.
As per business requirment Name and Birthdate are confidential to the sales department and they donā€™t want to show these to the sales department but the same column are non confidential to the finance department.

So, i want to create one report and publish to both department groups and they should see only the columns as per the there confidentiality level.

Please donā€™t hesitate to ask me if you need more information.

jagsurya :india: (BOB member since 2007-07-02)

#2

Jagsurya,

You should at row level restrictions to deal with this.
See here, to get you started:-

https://bobj-board.org/t/69149

Mak 1 :uk: (BOB member since 2005-01-06)

#3

Hi Mak,

Thanks for the interest in the problem.

Just more clarifaction about the my quetion. I need the column level sequirity not the row level.

I donā€™t want to show the Name and Birthdate columns to Sales group.

Please let me know if more information is needed.

jagsurya :india: (BOB member since 2007-07-02)

#4

Apologies, You should look at object level security in the universeā€¦

Mak 1 :uk: (BOB member since 2005-01-06)

#5

Hi Mak,

Its ok,

I already tried for the Object level sequirity in universe.

But when person from sales refreshes the report then hes is getting error meaage as ā€œYou donā€™t have access to the Name objectā€

jagsurya :india: (BOB member since 2007-07-02)

#6

Hello All,

I am waiting for the experts comments.

Please help me .

jagsurya :india: (BOB member since 2007-07-02)

#7

Looking at this, again, I donā€™t think what you want to do is possibleā€¦

https://bobj-board.org/t/138810

Mak 1 :uk: (BOB member since 2005-01-06)

#8

Thanks Mak,

jagsurya :india: (BOB member since 2007-07-02)

#9

Jagdish,

Just a thought, I have never done thisā€¦ :slight_smile: .
But, how about maybe using an @prompt in the Select statement, in conjunction with a Case statement that returns the secure column or some other column, this could even be anything, maybe a null.

You could then use alerters to white out the column or display the secure column. Maybe you can conditionally hide this, its been a while since I used Deski.

You could hide this object once you have built the report.

This prompt could then be populated as part of the scheduled report scenario, where you provide the prompt values.
You could use one report and generate two instances, which you could allow access to accordinglyā€¦

Cheers,

Mark.

Mak 1 :uk: (BOB member since 2005-01-06)

#10

Hi Mak,

Many thanks.

I got the logic from your solution. In my case, the CASE statement will be enough.

I will create object like CASE @bouser=ā€˜saleā€™ then ā€œxxxā€ else Name.

where ā€˜salesā€™ is user who loged in.

Thank you very much for the your quick reply and solutions.
I really appreciate your help.

jagsurya :india: (BOB member since 2007-07-02)

#11

Excellent, Jag, no problem :).

Mak 1 :uk: (BOB member since 2005-01-06)