RE: Create right dimension for different viewing purposes

#1

create dimension security role for each persion

"khoo" wrote:

Quote:

I create a cube which consist of 13 tables.
This is what I would like to create as a dimension.

catogary 1
----------
Ho-cust
cust_code
cust_rept_code
rep
sales_manager

Catogary 2
----------
branch
plus dimension 1

Catogary 3
----------
prod_grp
product_manager

However, all the above dimension(fields) are from the 13 tables which I have link.
so I have created this as a dimension under that cube.
But how if each of this catogery are view by 3 different person. Eg: person 1 view catogary 1, person 2 view catogary 2, person 3 vuew catogary 3.
when person 2 view catogary 2, he/she cannot view catogary 1 and 3.
How to do that?
I am using Ms Olap manager to create cube.
Please assist. Urgent.

Best regards.

#2

How to create role? Can you give me an example. However, after I put the role, what will be the result?

Please advise.
Thanks

"yongli" wrote:

Quote:

create dimension security role for each persion

"khoo" wrote:

I create a cube which consist of 13 tables.
This is what I would like to create as a dimension.

catogary 1
----------
Ho-cust
cust_code
cust_rept_code
rep
sales_manager

Catogary 2
----------
branch
plus dimension 1

Catogary 3
----------
prod_grp
product_manager

However, all the above dimension(fields) are from the 13 tables which I have link.
so I have created this as a dimension under that cube.
But how if each of this catogery are view by 3 different person. Eg: person 1 view catogary 1, person 2 view catogary 2, person 3 vuew catogary 3.
when person 2 view catogary 2, he/she cannot view catogary 1 and 3.
How to do that?
I am using Ms Olap manager to create cube.
Please assist. Urgent.

Best regards.

#3

Can we create dimension security role???
I thoguht we can only create cube security role....Please advise...

"yongli" wrote:

Quote:

create dimension security role for each persion

"khoo" wrote:

I create a cube which consist of 13 tables.
This is what I would like to create as a dimension.

catogary 1
----------
Ho-cust
cust_code
cust_rept_code
rep
sales_manager

Catogary 2
----------
branch
plus dimension 1

Catogary 3
----------
prod_grp
product_manager

However, all the above dimension(fields) are from the 13 tables which I have link.
so I have created this as a dimension under that cube.
But how if each of this catogery are view by 3 different person. Eg: person 1 view catogary 1, person 2 view catogary 2, person 3 vuew catogary 3.
when person 2 view catogary 2, he/she cannot view catogary 1 and 3.
How to do that?
I am using Ms Olap manager to create cube.
Please assist. Urgent.

Best regards.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

RE: Create right dimension for different viewing purposes

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

RE: Create right dimension for different viewing purposes - 07-12-2004 , 10:00 PM

RE: Create right dimension for different viewing purposes - 07-13-2004 , 09:42 PM

RE: Create right dimension for different viewing purposes - 07-13-2004 , 10:12 PM