Symptom
The scheduling of an Analysis workbook is failing.
The error in Instance Manager in CMC is the following: "An error occurred and can not precalulcate instance <INSTANCE_NUMBER>:360"
The scheduling trace shows the following entry: "Query cannot be executed without prompt dialog. Set the 'Store Prompts with Workbook' flag or check for mandatory space variables."
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
- Schedule in BI platform an Analysis workbook which contains mandatory variables;
Cause
The issue occurs because the workbook contains mandatory variables which are empty or there are wrong values entered for these variables.
Resolution
Double check the existing mandatory variables on the workbook and make sure they are not empty or with wrong values.
Refer to SCN post: http://scn.sap.com/docs/DOC-64437
There is also a known issue related to unusual characters in prompt. Refer to SAP note below:
2260878 - Analysis Office - Unusual characters in prompt values cause problems when scheduling
See Also
2260878 - Analysis Office - Unusual characters in prompt values cause problems when scheduling
Keywords
scheduling, schedule, 360, prompt, mandatory, variables, job, fail, failing, failure, platform, addon, precalculation, precalculate , KBA , BI-RA-AO-BIP , AO Precalculation, Scheduling and AO InfoOb... , BI-RA-AO-XLA , Excel Addin , Problem