SAP Knowledge Base Article - Public

3698644 - Only description of unlinked dimension would be exported in Excel or CSV file when exporting the blended table in optimized story in SAP Analytics Cloud (SAC)

Symptom

  • Create blended table in optimized story in SAC and add one linked dimension as well as another unlinked dimension into this table
  • Make sure the Display Option for this unlinked dimension has been selected as "ID" or "ID and Description" and export this blended table with scope selected as "All"
  • Only description of unlinked dimension would be exported in Excel or CSV file

Environment

  • SAP Analytics Cloud 2025.14.21 & 2025.21.9

Reproducing the Issue

  1. Log onto SAC
  2. Create a story as below steps
  3. Add two models into this story
  4. Create linked dimension for these two models in this story
  5. Insert a table with New Table Builder Experience enabled in this story
  6. Add the linked model in this table
  7. Add the linked dimension and measure into this table
  8. Add the unlinked dimension into this model
  9. Change the Display option for both the linked dimension and the unlinked dimension as "ID" or "ID and Description"
  10. Navigate back to the blended table
  11. Click on the three dot graph button beside the table and choose Export
  12. On the following "Export Table" panel, select the File Type as CSV or Excel, select Scope as "All" and export the table
  13. Check the exported file
    => Observe that, for the linked dimension, the display option for this dimension would be consistent in table and in exported file
    => Observe that, for unlinked dimension, only the Description of the Company dimension member would be exported, which is not consistent with the display option selected in table

Cause

The issue is caused by a defect in the product.

Resolution

This issue has been addressed in version 2025.21.13.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, optimized, variable, ID, description , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0