how to have a property reference a dimension BPC input form

[Former Member]

I have a  (Product) dimension members for which I have a property called PROFITCENTER , I want to display the members PROFITCENTER property in the input form as reference per each product member and I want it to save into the PROFITCENTER dimension read through the property for the individual product not the PROFIT_CENTER dimension set in the context pane. Please advise on how to reach this result even if through different methods. Right now I am using the EPMMEMBERPROPERTY to display the property  PROFITCENTER.

Just for Clarification. PROFIT_CENTER is the dimension and PROFITCENTER is the product member property.

[Shrikant_Jadhav · Accepted solution]

Hi ,

If product to profit center relation is 1:1 ,add both dimensions in row axis(PRODUCT, PROFIT_CENTER), go to PROFIT_CENTER dimension, "Selection relationship" -  select dimension property, select dimension - PRODUCT, select property - PROFITCENTER.

Shrikant 

[former_member186338 · Accepted solution]

Hi Shrikant,

Practically correct , but you don't require 1:1 relation. 1 PROFIT_CENTER - Many Products is OK! Single profit center can contain many products, but each product corresponds to the single profit center.

Vadim

[Shrikant_Jadhav · Accepted solution]

Fully Agree

Shrikant