SAP Knowledge Base Article - Public

2896807 - Changing Access Mode is not possible for HANA hierarchies

Symptom

When filtering a hierarchy of a HANA data source in Analysis Office, it is not possible to change the Access Mode. The option is disabled.

Environment

Analysis for Microsoft Office

Reproducing the Issue

  1. Run HANA data source in Analysis Office;
  2. Click to filter a hierarchy;
  3. Confirm it is not possible to change the Access Mode:

    Disabled.png

Cause

Member Access mode is not supported for hierarchies of HANA data sources.

Resolution

This is not a bug in the tool. The access mode/read mode must be set in HANA side when modelling the data source.

Keywords

read mode, disabled, greyed out, access mode, booked, masterdata, master data, f4 help, value help, filter , KBA , BI-RA-AO-XLA , Excel Addin , Known Error

Product

SAP Analysis for Microsoft Office all versions