Symptom
When opening a workbook in Analysis Office, the following warning messages are displayed:
----------------------------------------------------------
Planning object variables could not be submitted. Check empty mandatory variables (ID-109001)
Characteristic <XYZ> has no master data for "-2146826246" or you do not have authorizations (com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.selection.SingleMember-NoMasterdata)
----------------------------------------------------------
The workbook is saved/stored with option "Remove Data Before Saving" selected.
The variable of a planning function included in the report is being set via cell reference that contains a formula (e.g. SAPGetVariable).
In Analysis Office trace, the following entries are found:
----------------------------------------------------------
Cell reference ... with value '-2146826246'
Setting variable '<VAR ID>' with value '-2146826246' failed
invalid value for Variable: <VAR ID>
----------------------------------------------------------
Read more...
Environment
Analysis for Microsoft Office
Product
Keywords
warning, planning, sequence, function, refresh, opening, open, formulas, cell reference, variable, parameters , KBA , BI-RA-AO-XLA , Excel Addin , Known Error
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.