June 12, 2006 at 12:08 am
I want to add security to an AS-cube on the Organisation dimension. One of our Source-systems already as the information in it. In this source-system, each user is granted access to the data of one or more parts of the organisation. This information is stored in a couple of relational tables.
For example:
John has been granted permission to see data from Germany and Austria
Jane has been granted permission to see data from UK and Irland
etc...
Now I want to apply the same access permissions to the AS-cube. Since the relations between user and organisation are already defined in the source-system, I would like to automatically apply them, so that the administrator only has to maintain them in one place.
What's the best way to do this?
June 15, 2006 at 8:00 am
This was removed by the editor as SPAM
June 16, 2006 at 7:01 am
i dont think there is any easy way to do this. the security roles are stored in the olap repository (access db by default or you can migrate to a SQL Server database which is better), however i don't think there is any way to automatically insert role. i could see the possibility to update roles, but new roles have to be assigned an internal id and parent (i.e. 7A6F720A-6C3B-11D4-BD2C-009027E4107F). AFAIK, this is only done thru the Analysis Manager interface.
June 28, 2006 at 9:00 am
You should be able to do this via DSO (Decision Support Objects) whih is a COM interface (ie a bit easier with VB6 than .net unforunately). You would want to either have Windows groups already set up in your domain or alternatively if you have the windows username you couls just assign them to the (newly created) roles individually (not a great management strategy). To get started, take a look at Books OnLine at the topic named 'Decision Support Objects Architecture'.
Cheers,
Steve.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply