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.

[former_member186338 · Accepted solution]

First try to uncheck in User Options:

Also you can try to play with EPMReadOnlyData, but it's useful for static input forms. For dynamic you can try to use VBA to generate EPMReadOnlyData range list.

P.S. The issue is the result of "Calculate Parents in Hierarchies". But this option is required in dynamic input forms to immediately see total result before saving data to the model. That's why in many companies static input forms are used.

[former_member186338 · Accepted solution]

To use user option "Send Parent Data to the Server on "Save Data" you have to ensure that this option is unchecked for all users. Can be done using VBA.

[former_member518018]

Hi Vadim,

Not sure if I fully understand your last comment but I have clicked on accept for your answer.

Thanks.

[former_member186338]

Please, stop using "answers" instead of comments. It's against the rules of the Community.

If you need to clarify something - also use comment.

[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!