GLOBAL CUBE slicing and security challenge

Hi Guys,

Context
I'm working with SSAS 2005 SP2. I'm quite new at it and I'm struggling with an interesting challenge.

I have to create cube files so that Sales Representatives can browse their data offline. A Sales Representative can see his own sales data but also the sales data of the other sales representative with whom he is sharing customers.

For this purpose, I want to use the CREATE GLOBAL CUBE-statement.

I don't know how to implement the last requirement. In T-SQL, it will look as follows for the Sales Reps named "J. Do".

WITH Sales_Reps_Cust(CUSTOMER_ID) AS
(
SELECT F_S.CUSTOMER_ID
FROM FACT.SALES F_S
INNER JOIN DIM.CUSTOMER D_C
ON F_S.CUSTOMER_ID = D_C.CUSTOMER_ID
INNER JOIN DIM.SALES_REPRESENTATIVE D_SR
ON F_S.SALES_REPRESENTATIVE_ID = D_SR.SALES_REPRESENTATIVE_ID
WHERE SALES_REPRESENTATIVE_NAME = 'J. Do'
GROUP BY F_S.CUSTOMER_ID
)
SELECT FS.*
FROM FACT.SALES FS

INNER JOIN Sales_Reps_Cust D_C
ON F_S.CUSTOMER_ID = D_C.CUSTOMER_ID

Questions
In fact, I create a set of all customers of 'J. Do' and then I want to use this set to slice my cube. How can I use this way of thinking in order to make my cube file with CREATE GLOBAL CUBE?

Please advice...

Kind regards,
Lohic Beneyzet-Jouy

Hi everybody,

This issue is solved in my other threads "PLEASE HELP!!!! MDX-EXPERTS!!! LOCAL CUBE SECURITY".

Kind regards,

Lohic Beneyzet-Jouy