BusinessObjects Board

Row level security- without refresh on each access-

building semantic layer
#1

Hi BOB,

Can anybody help me out on implementing ROw level security.

If user want to open the report then that time we dont want report to be refreshed.Cozz our report takes long time to refresh which makes users frustrated if it gets refreshed everytime. Oncly once it should be refreshed when the administrator refresh.

Thanks,
Lilly

lilly (BOB member since 2006-02-09)

#2

Why the report refreshes when a user opens it ?

Check the following:
– If option “Refresh on Open” is selected. If yes, then uncheck it.
or
– Check if there is any VBA routine which is automatically refreshing this report ?

BO_Chief :us: (BOB member since 2004-06-06)

#3

We want to get all the list of all brancehs.

If any branch manger is refering the report . it should be restricted for particular branch.
We have given condition in DP like
User name = @variable(‘BOUSER’).

It is making to refresh every time.

lilly (BOB member since 2006-02-09)

#4

hi,

if we unchek the option of “refresh on open” then the report does’t refresh every time when a user open it.

vijay06 :india: (BOB member since 2008-03-18)

#5

Can you tell us how Row to implement Row level security .

lilly (BOB member since 2006-02-09)

#6

This presentation … Using Designer to Implement Row-Level Security … will give you an excellent place to start. That said, the techniques described are applied at RUN time, so the reports will have to be refreshed so that row-level security is applied. If you are hoping that the report can be refreshed in advance (like scheduled), and that each user’s security will be applied at VIEW time (without refreshing), then you are out of luck. Crystal Reports using Business Views does have view time security, but not any universe-based reports.

Dwayne Hoffpauir :us: (BOB member since 2002-09-19)