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

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
>
>