October 14, 2003 at 1:34 pm
My scenario is that I am attempting to build a single cube from a database that contains sets of data for different companies. I wish to provide each company with a distinct view of their data. I cannot use the user role security for this purpose as all the access to the DB is via a single user (web based app). I don't particularly wish to create a separate cube for each company as the number of companies can change, so I am trying to see if I could include a dimension (company) which would ultimately be hidden but usable as a filter in MDX. Based on the selection of a value in this dimension, filter the contents of other dimensions to those specific to the company selected.
Any and all suggestions gratefully received.
October 17, 2003 at 8:00 am
This was removed by the editor as SPAM
October 22, 2003 at 8:34 am
Just include the dimension "Company".
You have no security measures at all to prevent them from viewing all companies.
Only tell the users that this is a cube BEFORE consolidation i.e. you have double-counts with interco transactions when you select all companies.
Go for authentication.
You'll get into serious trouble when publishing critical information on intranet without security.
October 22, 2003 at 10:20 pm
Doug,
Using true authentication is the best method, but if in a bind, you might want to try out some of Mosha's (http://www.mosha.com )suggestions regarding data-driven security etc (http://www.mosha.com/msolap/articles/datadrivencellsecurity.htm ).
If Mosha's site isn't in your favourites list, put it in.
HTH,
Steve.
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply