cancel
Showing results for 
Search instead for 
Did you mean: 

Local member copy

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member222556
Contributor
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Hi kiran,

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

Vadim

Former Member
0 Kudos

Hi Vadim,

Local member is created on local member tab only.

Thanks,

Kiran

former_member186338
Active Contributor
0 Kudos

You can't copy the cell with local member formula, you have to create a new local member.

Vadim