SAP Knowledge Base Article - Public

3290864 - Table export to CSV with option ALL will generate additional characters in the exported file for hierarchy members in SAP Analytics Cloud (SAC)

Symptom

  • Table export to CSV with option ALL will generate additional characters in the exported file for hierarchy members in SAC.
  • For parent level => "[Dimension ID]!"
  • For child level => "!"

Environment

  • SAP Analytics Cloud (Enterprise) 2022.21.11
  • SAP Netweaver 7.5

Reproducing the Issue

  1. Login to SAC.
  2. Create a story based on direct live data conneciton to BW.
  3. Insert a Table and add a hierarchy to the table rows.
  4. Select the table and Export: File Type: CSV, Scope: All, CSV delimiter: , (comma)
  5. Check exported CSV file:
    • Additional characters will be added in the exported file for hierarchy members.
    • For parent level => "Dimension ID!"
    • For child level => "!"

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

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, https://hcs.cloud.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence, , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud 1.0