3575775 - SAC Excel Add-in displays both ID and Description in the same cell

When a given dimension in a SAC Excel add-in table has both ID and Description display option set, both are displayed in the same cell:

It is different from other SAP Excel Add-ins like BEx Analyzer and Analysis for Microsoft Office tools that display both ID (Technical Name) and Description in separated cells.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

SAP Analytics Cloud, add-in for Microsoft Office

1. Open SAC Excel Add-in and connect to a SAC tenant.
2. Insert a data source from any target and add a dimension in rows or columns.
3. Adjust the Display Option of this dimension to "ID and Description"
4. Notice that both ID and Description are displayed in the same cell

This display form is by design.

The main idea behind this decision is to keep the behavior of the SAC Excel Add-in similar to the one in a SAC Story in SAP Analytics Cloud tool.

KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , How To

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