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
- Run HANA data source in Analysis Office;
- Click to filter a hierarchy;
- Confirm it is not possible to change the Access Mode:
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