SAP Knowledge Base Article - Public

3154692 - Hierarchy is activating again after re-executing the variable screen in AO

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 314962931070663009842 and 2944239 in the BW system.

Keywords

node variable, hierarchy inactive, flat, activating, lost, reset, submit, no applicable data found, no master data , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions