MS SQL Data Warehousing - Horizontal Security in OLAP Cubes

Author

Horizontal Security in OLAP Cubes

Erdal Akbulut

2005-12-02, 9:23 am

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

Jéjé

2005-12-19, 9:23 am

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.

"Erdal Akbulut" <erdalim21@yahoo.com> wrote in message
news:usDWU609FHA.3308@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Sponsored Links