Infoview-How publish report where user views his data only

Hi BOB,
My requirement is like this there are team members -1000
Project leads-50 and PMs-10.
In Info view how do i publish the same report say time spent activitywise but user should be able to view only a part of the data relevant to him/her.
A TM can view his/her data alone.
PL his/her all his TMs’ and his/her
PM all his PLs’ and TMs’ and his/her data.
what is the efficient way since there are like 1000 users.
User can have their own userid
Thanks in advance,
saj suresh


sajsuresh (BOB member since 2004-07-18)

The only real way to do this is to implement row-level security.

The report should be published using the refresh on open process.

Then when each user opens the report it is refreshed with only their data.

V6.5 may have some other options, but for now, this is really your only choice outside of using BCA Publisher.


Steve Krandel :us: (BOB member since 2002-06-25)

Thanks steve,
I am presently working with version 5.1.5.

How is row-level security implemented that.I am not familiar with that? Can you please reply in detail

Thank you very much
sajsuresh


sajsuresh (BOB member since 2004-07-18)

sajsuresh, if you do a search on “row level security” here on BOB you will probably find out more than you ever wanted to know. Also, try and find Steve’s presentation on this subject it is referenced in several threads and available for download through the BO tech support website. - good luck


jswoboda :us: (BOB member since 2002-06-20)

here’s one of the threads that reference Steve’s presentation and how to find on the BO Web Site - Using Designer to Implement Row Level Security

  • hope it helps

jswoboda :us: (BOB member since 2002-06-20)