Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Multiple property values in a dimension

Dear All,

Please help me if BPC can identify multiple property values in a property field separated by comma.

Please see below example:

I have 3 plants and 6 customers and not all customers are supplied from all plants. In customer dimension, I have mapped the plants from where they are supplied as one of the property.

(Dimension)(Property)
CUSTOMERPLANT
Customer_APlant_A,Plant_B
Customer_BPlant_A,Plant_C
Customer_CPlant_B,Plant_C
Customer_DPlant_B,Plant_C
Customer_EPlant_A,Plant_B
Customer_FPlant_A,Plant_B,Plant_C

Now, In excel EPM add in, I want to write a dimension override formula for customer to display customer list applicable for a selected plant as: =EPMDimensionOverride("000","CUSTOMER","PLANT=PLANT_A"). From this formula I expect only customers A, B, E and F are displayed.

But this does not work.

I was able to achieve this by modifying my customer dimension as below and use EPMDimensionOverride("000","CUSTOMER","PLANT_A=Y") formula.

(Dimension)(Property)(Property)(Property)
CUSTOMERPLANT_APLANT_BPLANT_C
Customer_AYYN
Customer_BYNY
Customer_CNYY
Customer_DNYY
Customer_EYYN
Customer_FYYY

However, I would prefer initial option of having all the applicable plants defined in only one property field.

Is this possible and will BPC identify different property values separated by comma (",")

Regards,

Sandeep.

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question