Authorize document's objects and rows with SuperVisor?

[Gijs]

Is it possible with BO-Supervisor to set a restriction on document's objects and rows in a document for a specific user.
For example, if you force a specific user to see only rows from a document where Country="US"?

You would help me very much if you know the anser

Gijs Coenen
Infozorg BV
The Netherlands

 

[sagars]

Hi Gijs,

this is definitely possible if you have a user created in the universe do the following:
1. Select the User
2. Click the Universe tab in the adjoining pane.
3. Double click the Universe on which the report is created.
4. In the window that pops up, select the ROW tab.
5. Then in Table textbox select the table (like if u have a country table in which you have country_name as field, then select country).
6. in the where clause type in country.country_name = 'Netherland'. Remember to give the name in single qoutes.

***Another way is to use the BOUSER variable in your reports.

Hope this helps.
Best Luck!!
Sagars