local member (Member Combination) uses

[Former Member]

HI,

Can anybody provide the detail of the local member Member combination option in epm 10 report editor.

Please provide me the complete explanation with examples.

What is the use of Use Excel cell references  and related to context.

Regards.

Surya

[Shrikant_Jadhav]

Hi Surya,

The local member Member combination option used for if you want to add local member before or after certain combination of different dimension members.

Please go through the screenshot. In column axis - CATEGORY and COMPANY CODE, I have added one locale member after the combination of ACTUAL and R7003 respective members of dimension.

Shrikant

[Former Member]

Hi,

Thxs for your  input.

What about the Use Excel Cell References  and Related to Context.

Please show me some example.

Regards.

Surya

[bhagyesh_ravange]

Hello Surya,

In EPM, you can create local member whose formula can be derived from other cell by selecting Use Excel Cell Reference and in Formula box giving the reference of same.

With respect to Related to Context, you can give local member formula based on combination of context.

For example: In below local member formula I have added the value of 2013.11 & 2013.12 context (i.e Both the context are of year 2013). If don't select the Related to Context then after changing the context to 2014, local member formula will disappear. If I select the Related to context then after changing the context to 2014, it will add up the value of 2014.11 & 2014.12.

Hope this helps..

Regards

Bhagyesh Ravange

[Former Member]

Hi Sir,

As u said i am doing the same way but  the formula not applicable to the when i am changing the context i.e time please look below

Please suggest.

Regards.

Surya

[bhagyesh_ravange]

Hello Surya,

Why you have given =SUM(  before EPMTUPLE. It should be =EPMTUPPLE(.

Also could you elaborate your requirement.

Regards

Bhagyesh Ravange

[Former Member]

Hi sir,

If the user used the sum function , is it will not work?

Can you please explain the excel cell reference?

[bhagyesh_ravange]

Hello Surya,

Simply use the excel formula, then local member will not disappear.

Regards

Bhagyesh Ravange

[Former Member]

Sir,

Can you please explain in detail,

i didn't understand the use of the "use of excel cell reference".

It behaving same as without check box.

can you please explain in detail.

Regards.

Surya

[Former Member]

Hi bhagyesh,

Please explain the use Excel Cell References.

waiting for your replay

Regards.

Surya

[bhagyesh_ravange]

Through selecting Excel cell reference, you can refer cell and not EPM keywords in formula field of local member.

For example: In above screen shot EPM keyword used is EPMTUPPLE, so instead of giving EPM keyword in formula field you can directly refer the cell.

kindly refer below link for better understanding Local member and other EPM formula.

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

[Former Member]

Hi Surya,

For local members go through below PDF link(Page no 147-156)

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

You will get more information on the help link on the EPM tab of excel.

Also refer BPC 430  for the local members.

Regards,

Sushant

[Former Member]

Hi Sushant,

Thx for you prompt reply.

I read the book and pdf but i didn't understand.

Can you please  explain me in detail with example....

Regards.

Surya