Extract UDA and Attribute from CURRMEMBER
Hello experts, I have a requeriment to do.
I have 3 dimensions for this process:
1- Account :
Account1 (UDA: Red)
Account2 (UDA: Yellow)
Account3 (UDA: Black)
2- Product :
Product1 (Attribute: Car)
Product2 (Attribute: Motorbike)
Product3 (Attribute: Plane)
3- Analytical :
Red_Car
Red_Plane
Red_Motorbike
Black_Motorbike
Black_Car
Black_Plane
Yellow_Plane
Yellow_Car
Yellow_Motorbike
Analytical_NA
I have data in Account and Product dimension and analytical dimension member Analytical_NA, like this:
Account1 - Product1 - Analytical_NA : 100
Account3 - Product1 - Analytical_NA : 50
Account2 - Product3 - Analytical_NA : 20
Account2 - Product2 - Analytical_NA : 150
Account3 - Product3 - Analytical_NA : 10
Tagged:
0