EPM input schedule - appending data

[former_member435663]

Hi,

Is it possible in EPM input schedule to add another record with the same dimensions and append data instead of overwrite

e.g.

Line material Company Revenue

1 mat01 1001 100

2 mat02 1001 200

now if we insert a new line

3 mat01 1001 300

I would like the result to be

material company revenue

mat01 1001 400

instead of revenue being 300 (is this possible in input schedules)?

[Amy_Zhou]

By standard EPM functions, you cannot realize this feature. The data input in EPM Add-in is the destination value rather than the incremental value.

Also, when refreshing the report, the cell will read the total value in the backend cube and show it. So there is inconsistency with your requirement.

You can refer to Vadim's advice if you still want this feature.

[former_member186338]

You can have:

1. Report to read existing values.

2. Some place to enter the values to add outside of reports.

3. Input form to save data using Excel formulas in the data cells that will sum value from 1st report and value to add.

To my mind it's a dangerous approach - each time after pressing save - data will be added.

[lucas_costa3]

Do you have anything in default logic or write back badi?

[former_member435663]

Hi Lucas, no I do not, please explain.

Regards

Avinesh

[former_member186338]

Default logic will not help (it's executed after saving data to the model). Write back badi can do the job, but it's too complicated compared to simple report/input form combination.