SAP Knowledge Base Article - Public

3518042 - If SAC supports to copy data from Dimension table to Excel file directly

Symptom

  • If SAC supports to copy data from Dimension table to Excel file directly

Environment

  • SAP Analytics Cloud 2024.15.6

Reproducing the Issue

  1. Logon SAC tenant
  2. Go to Modeler -> Public Dimension Tables
  3. Click one of the dimensions in the environment (Account as an example)
  4. In the Dimension Table workspace, copy the items from the grid into an Excel spreadsheet.
  5. Notice the Excel file would have hundreds of records less than the original Account Dimension table. 

Cause

  • This is a limitation that using the member grid to copy the cells will not work for a large number of members.

Resolution

  • Public Dimension Members can be exported using Data Export Service with the namespace sac_public_dimensions

Documentation on the API and these endpoints can be found here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/14cac91febef464dbb1efce20e3f1613/b0dae84ec21e4d7bb9cae582e88a6ca2.html?locale=en-US

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Very High, VH, justified, unjustified, priority, go live, go no go decision, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, 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 , KBA , sac very high toc kba terms sap , sac very high kba p1 , sac very high kba , sac verify business impact: , vh , vh vhs prior priority down , 2752144 , system which shouldn't qualify for vh. , raised a p1 on a test sys system , project for sac is currently a impedemen , a impedement for go live. , currently an impediment for go live. , dev test and prod , sac vh schedle priority , sac vh schedule priority data analyzer , LOD-ANA-ADM , SAC Administration , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , LOD-ANA-XUS , User assistance, performance statistics , LOD-ANA-DES , Story Design & Visualizations , Problem , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud all versions