SAP Knowledge Base Article - Preview

3532182 - Values inserted in the variable prompt are not being validated and the wrong information is being displayed in the workbook

Symptom

Even when inserting a dummy value for a dimension/variable in the variable prompt (i.e: Fiscal Year), Analysis for Office is displaying the wrong information in the workbook instead of "No applicable data found". Issue specific to reports using HANA data sources. Screen shot below shows the wrong behavior in the variable screen:

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Analysis for Microsoft Office
  • SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud

Product

SAP Analysis for Microsoft Office all versions ; SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud all versions

Keywords

AllowLiteralMemberSelectionsInVariablesHana, variable screen, validate, prompt, HANA, inserted values, wrong information, No applicable data found, dummy value, validation, All selections for characteristic, are invalid and have been discarded, Fiscal Year , KBA , BI-RA-AO-XLA , Excel Addin , Problem

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.