Symptom
The hierarchy is activating again after re-executing the variable screen in AO or reopening a local workbook.
In RSRT transaction, the hierarchy remains deactivated as expected.
Because of this issue, the following errors/warnings might be displayed:
No applicable data found
Characteristic <X> has no master data for <Y> or you do not have authorizations (com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.selection.SingleMember-NoMasterdata)
or
Characteristic <X> does not support exclusion of selections (com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.selection.Range-NoExcluding)
All selections for characteristic Material are invalid and have been discarded (com.sap.ip.bi.bics.dataaccess.consumer.impl.selector.selection.ComponentList-AllRejected)
Environment
SAP Analysis for Microsoft Office
Reproducing the Issue
1. Run query in AO or refresh an existing workbook;
2. Confirm hierarchy is activated;
3. Change hierarchy to flat presentation;
4. Open variable screen and re-execute (even with same values);
5. Confirm the hierarchy will activate again.
or
1. Run query in AO or refresh an existing workbook;
2. Confirm hierarchy is activated;
3. Change hierarchy to flat presentation;
4. Save as local workbook.
5. Reopen this local workbook.
6. Confirm the hierarchy will activate again.
Resolution
Ensure that the SAP Notes below are implemented in the BW target system:
3551444 - Hierarchy deactivations are lost
3545338 - Problems when loading a bookmark/AO: Hierarchy unexpectedly active
3535974 - Hierarchy settings are lost
3529416 - Dynamic selections or hierarchy settings are lost
3149629 - Cancelling variable screen activates hierarchy
3107066 - Hierarchy activated unintendedly In Analysis for Office
3009842 - ABAP BICS: Hierarchy drill level lost after variable submit
2944239 - ABAP BICS: Hierarchy state lost after variable submit
Keywords
node variable, hierarchy inactive, flat, activating, lost, reset, submit, no applicable data found, no master data, flat presentation, does not support, exclusion of selections , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-OLAP-VAR , Using Variables , Problem
SAP Knowledge Base Article - Public