Skip to Content
author's profile photo Former Member
Former Member

Local member copy

Hi Experts,

we have used local member formulas for variances,However if i copied the local member formula cell and paste this value into another cell it seems okay.However after refresh the copied cell disappears. how should i copy local member formula cell.

I have tried with local member recognition on with position in axis,Keep formula on data but could not able to copy.

BPC10,Sp17 patch 2.

Before refresh:

A1 B1 C1

Actual Budget Variance(local member formula)

1000 2000 1000(budget-actual)

A2 B2 C2

1000 2000 1000(copy/paste C1)

After refresh:

A1 B1 C1

Actual Budget Variance(local member formula)

1000 2000 1000(budget-actual)

A2 B2 C2

1000 2000

Can any one help me on this.

Thanks,

Kiran

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 04, 2014 at 03:42 PM

    Hi kiran,

    Please use local member editor in Edit Report instead of recognition of local member (works only for very simple cases).

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2014 at 03:43 PM

    Check in EPM Editor, whether Local member is created on Local Member tab?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.