Multiple property values in a dimension

133 Views

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) CUSTOMER PLANT Customer_A Plant_A,Plant_B Customer_B Plant_A,Plant_C Customer_C Plant_B,Plant_C Customer_D Plant_B,Plant_C Customer_E Plant_A,Plant_B Customer_F Plant_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) CUSTOMER PLANT_A PLANT_B PLANT_C Customer_A Y Y N Customer_B Y N Y Customer_C N Y Y Customer_D N Y Y Customer_E Y Y N Customer_F Y Y Y

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.