Description on EPMOlapMemberO with cell reference

[former_member302911]

Hi,

is there a way to show the real description of members when use reference on EPMOlapMemberO ?

Example 1(Without Reference):

EPMOlapMemberO("[TIME].[PARENTH1].[2015.TOTAL]";"";"2015.TOTAL - Total 2015";"";"000")

Show: Total 2015

Example 2(With Reference):

A1 = 2015.TOTAL

EPMOlapMemberO(A1;"[TIME].[PARENTH1].[2015.TOTAL]";"2015.TOTAL - Total 2015";"";"000")

Show: 2015.TOTAL

How i can show "Total 2015" in the Example 2 instead of ID 2015.TOTAL ?

Thanks,

Angelo.

[former_member302911 · Accepted solution]

Thanks for the answers,

this is the scenario of two examples:

1. Reference

2. No reference

The EPM manual (see Page 18)  explain the use of EPMOlabMemberC, that would work like i want, but is only for local purpose!

@Vadim I had already thought the use of Local Member EPMMemberDesc at Row Axis after TIME Members or Formula Before TIME Member ... what do you mean with the use of EPMMemberProperty ? I can use it with EPMOlapMemberO ?

Thanks for the support.

Angelo.

[gajendra_moond · Accepted solution]

Hi Angelo

You can put a formula EPMMEMBERDESC(Cells in Row3) in cells of Row2 and then hide Row3? I am not sure if I am missing something in understanding your requirement.

[former_member186338 · Accepted solution]

Sorry - I mean EPMMemberDesc instead of EPMMemberProperty

By the way EPMMemberProperty can be also used: "DESCRIPTION" - is a property!

In general if you use reference inside EPMOlapMemberO - then you use static report (in this sample with static column axis)

For static report you don't need local member - just row with formulas EPMMemberDesc(...)

Vadim

P.S. Read my document:

P.P.S. "Static" - in your sample means fixed number of columns with member id's delivered by reference!

[Ankur_Jain1m8 · Accepted solution]

Hi Angelo,

You can achieve your requirement as described below:

In the attached screenshot, H4 is refrencing H1.

And H3 is having formula

=EPMMemberDesc(H4)

Now, you can hide row 4 and user will see row 3 which is having description of the refrenced cell H1.

Regards,

Ankur Jain

[former_member302911]

Thank you all for the support!

[gajendra_moond]

Your desired cell = EPMMEMBERDESC(A1)

[former_member186338]

Hi Angelo,

Use separate cell with EPMMemberProperty. And hide ID cell!

Vadim

P.S. If you are talking about row/column axis - use local member for the same (with EPMMemberProperty)