EPMSaveDataOnly not sending data to model

[momotara90]

Hello,

We have an input form in which we are calculating the value for an Account via an excel formula in a cell based on other values inputed by the user.

This cell is then sent to the model via the EPMSaveDataOnly formula (we specified all parameters).

When we choose to save data, the value introduced by the user is sent to the model correctly.

Data sent via the EPM formula is updated when using our 'developer' accounts, which have admin rights. However, with user accounts it is not always sent to the model.

Do you have any thoughts?

Regards,

Ana-Maria

[bishwajit_das · Accepted solution]

Please refer to this note:-

1944884 - BPC: Reference Cell of EPMSaveDataOnly is erased

2101114 - BPC,BWINA: Clicking on sheet just after saving data stops the data gathering step

Regards,

Bishwajit

[former_member186338]

Hi Ana-Maria,

What about user rights to write data?

What do you mean by "not always"?

What about screenshots?

...

Vadim

[momotara90]

Thanks Vadim,

The user has rights to write data.

Not always means that sometimes the EPM Formula works correctly and data calculated is sent to the model along with the data introduced, but sometimes it just doesn't...with no error message.

What screenshots do you think could be useful?

Regards,

Ana-Maria

[Shrikant_Jadhav]

HI Ana-Maria,

Kindly provide screen shot of EPMSaveDataOnly formula, cells which you are referencing , row,column axis

Shrikant 

[momotara90]

Hi Shrikant,

My EPM Formula is in cell AH34:

=EPMSaveDataOnly(P34; $A$2; $L$19; $L$20; "S_BU_DUMMY"; $N$13; "ALLOCATION_MM"; "EUR"; $N$15; "DOM"; "PP_DUMMY"; EPMMemberID(P27); "PERIODIC"; "P_BU_DUMMY"; "OPENING_STOCK")

Cell P34 retrieves value from another cell: =O106

Thanks,

Ana-Maria

[former_member186338]

First of all you have to perform some tests to analyze "but sometimes it just doesn't...with no error message." What is different "sometimes"?

When user press save what is the message (in both cases)?

Vadim

[Shrikant_Jadhav]

Is there any EPM formula in O106 ?

Shrikant

[momotara90]

no, there is an Excel Formula.

[momotara90]

Hi Vadim,

The behavior appears to be random.

We are still doing tests, but are not able to reproduce the error for the moment.

Ana-Maria