EPM Formula as a local member

[Former Member]

Hi Expert,

I would like to use an EPM formula as a local member.

This formula should look for the workstatus for each member of dimension Profit Center which it's placed in the rows. The first row it's in cell C25. The other compulsory dimensions are hardcoded as the values in cells D16 and D3.

This formula works fine if I use it directly in Excel.

=EPMWorkStatus(;0;"[D_PCENTER].[PARENTH1].["&C25&"]";$D$16;$D$3)

However, when I tried to use it as a local member I will see:

#Error - Impossible to apply local member formula.

I guess I could make this work using a COPYRANGE function but, Does anyone know how should the above formula be written as a local member?

Any help, greatly appreciated.

Regards,

Alberto Sabate

[former_member186338 · Accepted solution]

Hi Alberto,

Please read help about local member creation - examples. You will find a sample with EPMMemberProperty - the same....

Vadim

[Former Member · Accepted solution]

Hi Alberto,

The formula can be like below :

=EPMWorkStatus(,0,EPMLocalMember("LocalMemberID")) but Is workstatus enabled for Local members also? otherwise it will not return anything.

You will get the below error when formula is not right like syntax, I think in your formula it should be , before and after 0 instead of ;.

#Error - Impossible to apply local member formula.

[former_member186338 · Accepted solution]

Hi Sivacharan,

Please never post something just to post, without understanding the question and without testing the solution...

Sorry,

Vadim

[Former Member · Accepted solution]

Vadim,

Sorry Vadim, Can you please delete my reply.

[former_member186338 · Accepted solution]

The correct local member formula in you case will be:

=EPMWorkStatus(,0,EPMMemberID(EPMDIM_CURRENT_MEMBER(D_PCENTER)),EPMMemberID($D$16),EPMMemberID($D$3))

Use US Excel separator "," for local member formulas - required!

Use EPMMemberID to get member ID from the cells containing EPMOlapMemberO formula

Vadim

[former_member186338 · Accepted solution]

Unfortunately - no...

[Former Member · Accepted solution]

Excellent!

Thanks a lot Vadim.