access restriction

[system]

I have several departments (ex. sales, marketing, general mgnt. etc…)
So, I want to make one copy of report and use it in common.

But they don’t have to find each other’s contents.
Each of the departments have to use their own department “only”.

How can I execute this action?

More detail, in the report, one column have several division…
like this,

sale
marketing
general mgnt.
… and so on

And the report have a drill filter(as a combo box) of this division column.

And if I have a sale parts license, then I can only see “sale” in the
drill filter box and the report.

Would you let me know the execute method concretely?

---

tkohw (BOB member since 2007-11-21)

[system]

Hi

Try using the Row and Column Level Restriction in Designer. This will help you to protect the data.

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)

[system]

Correct. Search here on BOB for more details.
Here is a post to get you started …

FAQ: Designer

How can I implement row level security? How to Implement Row-Level Security First – what is Row-Level Security? When you want to specify which rows of data each userid is permitted to retrieve from the database, based on some column of data, or combination of columns of data – that is row-level security. Row-level security can be implemented in BusinessObjects in several possible ways. If you have a tech support login, you can look at some of the techniques and the pros and cons …

---

zack (BOB member since 2007-08-02)

[system]

Thank you.
I did it following your tips.

---

tkohw (BOB member since 2007-11-21)