Skip to Content
0
Former Member
May 20, 2014 at 12:52 PM

Dimension value based on cell referece

42 Views

Hi,

I've a requirement with GLAccount and Trading partner in rows. I need to derive the trading partner based on the property of GLAccount.

Note: This inputschedule is dynamic (ACCOUNTS may change depending upon the selection).

Example: GLAccount is in Cell A and Trading Partner is in Cell B. Following is the formula applied on Trading Partner to derive based on the property of GLAccount.

Issue: Cell reference A1 is static in the formula. It is always refering to the GLAccount of cell A1. Ex: If Account1 Property value is I_NONE and others are T100

Result:

Account1 I_NONE

Account2 I_NONE

Account3 I_NONE

Expected result:

Account1 I_NONE

Account2 T100

Account3 T100

Formula on Trading Partner : Following formula cell reference is not dynamic to refer the corresponding GLAccount cell.

=EPMOlapMemberO(IF(EPMMemberProperty(,A1,"DIMLIST")="","I_NONE","T100"),"[TRADINGPARTNER].[PARENTH1].[I_NONE]","NONE","","000")

I appreciate your help.

Regards,

Saila