I work for a large healthcare company which just started using Business Objects for creating management reports on several databases. We've gotten a large amount of reports and universes from one of our suppliers which we want to use for our main databases.
The problem is that we have about 60 different users who all need to be able to view information of several different departments (about 350 in our company).
From what I gather there are 2 options I can use:
-Putting restrictions on tables in the supervisor module: because a lot of reports have their SQL query edited these restrictions don't do much (they won't be put into the code) so it's not an option except if we edit about 40 complex reports.
-Building an authorization table into the universes: because it's a many to many relationship this table will have loads of records (to connect each user to their departments).
My question is: isn't there an easier way to restrict users from viewing data from departments on which he isn't authorized?
Thanks in advance!
Ronald Slender
The problem is that we have about 60 different users who all need to be able to view information of several different departments (about 350 in our company).
From what I gather there are 2 options I can use:
-Putting restrictions on tables in the supervisor module: because a lot of reports have their SQL query edited these restrictions don't do much (they won't be put into the code) so it's not an option except if we edit about 40 complex reports.
-Building an authorization table into the universes: because it's a many to many relationship this table will have loads of records (to connect each user to their departments).
My question is: isn't there an easier way to restrict users from viewing data from departments on which he isn't authorized?
Thanks in advance!
Ronald Slender