SAP Knowledge Base Article - Public

3785835 - Dimension shows hierarchy instead of flat presentation by default in SAC Add-in

Symptom

  • When connecting to a model (for example, Datasphere analytic model) in an SAC story, creating a new table shows the dimension in Flat Presentation by default.
  • However, creating a new table in the SAC Excel add-in for the same model shows a hierarchy by default instead of Flat Presentation.

Environment

SAP Analytics Cloud, add-in for Office

Reproducing the Issue

  1. Open the SAC Excel add-in and connect to a live Datasphere analytic model.
  2. Insert a new table.
  3. Add a dimension to the table.
  4. Observe that the dimension is displayed using a hierarchy by default, not Flat Presentation.

Cause

The behavior described is as expected and is not a product defect.

Unlike SAP Analytics Cloud Stories, where dimensions are initially displayed in a flat presentation, the SAC Excel Add-in is designed to automatically assign and display the first hierarchy returned by the backend when a dimension is added to the table. This is the intended behavior by design.

Resolution

  1. Enable Pause Refresh in the SAC Excel add-in.
  2. Add the required dimension to the Rows area.
  3. Change the hierarchy for the dimension to Flat Presentation.
  4. Disable Pause Refresh.
  5. The dimension will now display in Flat Presentation.

If a different default behavior is desired, consider submitting an enhancement request via the SAP Customer Influence Site for SAP Analytics Cloud: https://influence.sap.com/sap/ino/#/campaign/884.
After submission, please rate this KBA and add a comment to share the enhancement request created.
The KBA customer feedback is reviewed regularly and this KBA will be updated with the URL of the enhancement request created so others can vote on your request.

See Also

  • KBA 2424376 - How do you create an enhancement request and provide feedback for SAP Analytics Cloud? 
  • KBA 1850330 - How to rate and provide comments to SAP for an SAP Knowledge Base Article (KBA)

Keywords

sac excel add-in, flat presentation, flat view, hierarchy, default hierarchy, dimension display, datasphere analytic model, live connection, rows area, pause refresh, flat list, table setup, sac story difference, backend hierarchy selection, sac add-in behavior, hierarchy enabled dimensions , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Product Enhancement

Product

SAP Analytics Cloud, add-in for Microsoft Office 1.0