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
