Symptom
- When reopening and refreshing a saved workbook, one data source fails with error: [5a73-4c85-1b] Object reference not set to an instance of an object.
- The affected crosstab is not rendered and its range collapses from several rows/columns to a single cell.
- Other data sources in the same workbook refresh successfully and Refresh All reports success.
- Observed in different workbooks by different users.
- The failure occurs only on the data source that has saved expanded hierarchy nodes (persisted drill state).
- SU53 shows "Authorization check not successful" for RFC function module BICS_PROV_GET_HIERARCHIES, however authorizations seem to be as expected
Read more...
Environment
- Analysis for Office 2.8
Product
SAP S/4HANA 2022
Keywords
Analysis for Office, AO, Refresh All, crosstab collapses, Object reference not set to an instance of an object, [5a73-4c85-1b], persisted drill state, hierarchy drill operations, Hierarchy Valid On, key date, P_KEYDATE, NullReferenceException, QvDrillOperation.verifyAgainstCharacteristicsSettings, data source fails, hierarchy parameter , KBA , BI-RA-AO-XLA , Excel Addin , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview