Symptom
Data in unexpected cells after disaggregation. Input data to dimension member with children; Expected data to disaggregate to children, but some Data was present in Parent only.
Reproducing the Issue
Input data to dimension member with children for disaggregation.
Cause
cache needs update
Resolution
Clear the add-in cache in Excel, as explained in point #6 of online help section "Tenant Configuration". #6 Clear the add-in cache. https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE/2b73edbc8f8f4189a36bc7a2e038185c/db2f874261824d63adb3ca198f65ce55.html
Keywords
KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem
Product
SAP Analytics Cloud all versions