SAP Knowledge Base Article - Public

3678802 - Values for CDS query are missing in the result set, appeared by expanding and collapsing hierarchy nodes in Analysis for Microsoft Office(AO)

Symptom

In AO, values for CDS query are missing in the result set, but by expanding and collapsing hierarchy nodes, values suddenly appear. The values in node level show as expected in RSRT.

Environment

SAP Analysis for Microsoft Office 2.8

Reproducing the Issue

  1. Open a CDS query in AO.
  2. No values displayed for result set at hierarchy nodes level.
  3. Expend the hierarchy nodes, the values suddenly appear.
  4. Confirmed values are shown without expanding or and collapsing hierarchy nodes in RSRT.

Cause

Program error.

Resolution

Implement SAP Note 3673446 - Universal Hierarchy not expanded as expected in AO for a CDS Query with Characteristic Structure.

Keywords

total values, AO query, measure, empty, line item, lowest measure level , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8