BPC 10.1 - Input schedule error message

[former_member518018]

Hello,

I am getting an error which have happened on and off but not sure why.

I have a standard input schedule (dynamic) which has combination of base and calculated accounts.The option to "calculate parent in hierarchies" is ticked but it makes no difference to the error if it is turned off.

On the input schedule, if I update 1 cell, it actually tries to update all of the cells (combination of rows and columns) including the calculated accounts. Then it gives the error that unable to submit for calculated accounts.

Any help would be appreciated.

Regards,

[former_member186338]

Sorry, but do you really think that it's possible to answer your question without input form screenshot and very detailed explanation of the report on this input form?

[former_member186338]

It's a bad idea not to accept the correct answer. Other users will not answer your future questions.

[wf]

Hi,

To restrict sending data to all cells of an EPM report, you can use the read-only option to exclude non input intersections. It is the 6th tab of the report editor.

Kr,

Wim

[former_member186338]

The issue of this approach is that for dynamic input form it's impossible to list all possible combinations...

[wf]

Dear Vadim,

Without extra information I think it is best to stick to your guns.

vadim.kalinin 22 hours ago

Sorry, but do you really think that it's possible to answer your question without input form screenshot and very detailed explanation of the report on this input form?

[former_member186338]

wf_-_

At least it was stated that input form is dynamic...

And for dynamic input form both option "Read-Only Data" and function EPMReadOnlyData are bad...

But for EPMReadOnlyData you can try to use VBA to calculate ranges...

"Send Parent Data to the Server on "Save Data" is a solution, but has to be unchecked by VBA on input form open!