SAP Knowledge Base Article - Public

2488954 - "Error during precalculation; user input required" occurs when scheduling Analysis workbook

Symptom

The scheduling of Analysis workbook is failing.

In Instance Manager, the error is "An error occurred; could not precalulcate instance <XXX> : Error during precalculation; user input required".

The entries below can be found in the traces:

>> Query cannot be executed without prompt dialog. Set the 'Store Prompts with Workbook' flag or check for mandatory space variables.
>> Finished. Return code: 360

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

Try to schedule an Analysis workbook in BI Launchpad.

Resolution

Make sure the correct information is being entered in tab "Prompts" when scheduling the workbook in BI Launchpad.

See Wiki page https://wiki.scn.sap.com/wiki/x/owxBGQ for more information about how to enter the variable values.

See Also

2134836 - Checklist for Scheduling of Analysis for Office Workbooks

Wiki page related to scheduling in Analysis Office

User Guide of Analysis Office

Keywords

code 360, variables, input, mandatory, values, technical name, scheduling, schedule, fails, failing, failed, precalculate, delivered, error , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions