Horizontal Security in OLAP Cubes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Erdal Akbulut - 02 Dec 2005 14:42 GMT

Hello,

I have designed a simple Sales cube which has the data of 7 different
companies. The Cube has both sales and cost data.
I want to manage security using Active Directory. I can manage securtiy by
columns for AD accounts, I can hide or show cost data for based on AD
Accounts. Is it possible to use AD security for rows? I mean, can I show
only related companies' data to related people ?

Fact Table:
Company
Item
Sales
Cost

Dimension Company
Company
............

AD Groups.

Company1Marketing
Company1Sales
.........
Company7Marketing
Company7Sales

Thanks in advance.

erdal

Reply to this Message

Jéjé - 19 Dec 2005 13:38 GMT

yes, you have to secure your dimension members.

if you have only 7 companies, I recommand to create 7 roles manually in AS.
Each role has access to a particular company only (secure the dimension by
authorizing targeted company only). then add the right AD security group to
each role.
the setup takes 10minutes.

everything is in the "manage roles" page.

> Hello,
>
[quoted text clipped - 26 lines]
>
> erdal

Reply to this Message