Skip to Content
avatar image
Former Member

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) 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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 06, 2015 at 02:13 PM

    Hi Sandeep,

    I would suggest to try create a formula in another cell to determine if PLANT_A exists in a property, then return Y or N, then use Y or N inside you override formula.

    if you use PLANT=PLANT_A then it try to match text that =PLANT_A which will return false as you have PLANT_A,PLANT_B

    Andy

    Add comment
    10|10000 characters needed characters exceeded