3745824 - A dimension used in a table in SAC Add‑in reports cannot be removed after enabling the Use Associated Dimension option or modifying the previous Association in the Datasphere Analytic Model

• In existing SAC add-in workbooks, after switching an analytic model (based on a fact view) to use associated dimension for an attribute, the previously used dimension remains and cannot be removed.
• The updated associated dimension can be added, resulting in both the old (unremovable) and the new dimension being present in the reports.
• The behavior can also occur when simply toggling the “use associated dimension” option on/off, without changing the underlying association/attribute.
• The issue requires reports to be recreated, which is time-consuming and involves manual effort.

• SAP Analytics Cloud
• SAP Analytics Cloud, add-in for Microsoft Excel

1. In datasphere, prepare an analytic model on a fact view where a dimension attribute has an association; keep “use associated dimension” set to off.
2. In SAC add-in, create a workbook based on this model and add the relevant dimensions; save and close the workbook.
3. In datasphere, enable “use associated dimension” for the attribute (or change the association/attributes as needed) and deploy the model.
4. Reopen the workbook in SAC add-in.
5. Observe that the old dimension persists and cannot be removed, while adding the same dimension inserts the updated associated dimension alongside it.

• When an association is enabled for a dimension in Datasphere, the dimension's technical name changes (for example, "CustomerNumber" becomes "_CustomerNumber"). 
• Although it appears to be the same dimension to end users, these are technically two distinct objects. This mismatch causes the behavior issue in the Add-In.

• This is currently by design in SAC Add-in. 
• When an association is enabled for a dimension in Datasphere, the dimension's technical name changes, therefore SAC Add-in treats it as a different object. 
• Workaround: before changing associations/attributes or enabling “use associated dimension” in the datasphere model, open each affected SAC add-in workbook.

1. 1. Remove the impacted dimension from all tables in the workbook.
   2. Save the workbook and close excel.
   3. Apply and deploy the changes in datasphere (association/attribute updates or toggling “use associated dimension”).
   4. Reopen the workbook in sac excel add-in and add the dimension back to the tables as needed.
   5. If the workbook still shows the old dimension and it cannot be removed, recreate the table in the workbook.

KBA 3512668 - sac excel add-in: "a measure does not exist anymore" after measure deletion in datasphere 

sac excel add-in, datasphere, analytic model, fact view, use associated dimension, ghost dimension, dimension cannot be removed, replace dimension, association, attribute, excel desktop, windows, table rebuild, re-create report, dimension persistence, model change not recognized , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , DS-DI-CON , Connections , Product Enhancement

SAP Analytics Cloud all versions ; SAP Analytics Cloud, add-in for Microsoft Office all versions