Symptom
The hierarchy is activating again after re-executing the variable screen in AO.
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)
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.
Resolution
Check and if applicable, implement the SAP Notes 3529416, 3149629, 3107066, 3009842, 3545338, 3551444, 3535974 and 2944239 in the BW system.
Keywords
node variable, hierarchy inactive, flat, activating, lost, reset, submit, no applicable data found, no master data, flat presentation , KBA , BI-RA-AO-XLA , Excel Addin , Problem