SAP Knowledge Base Article - Public

2651014 - Common errors with charts / tables in SAP Analytics Cloud *** Troubleshooting KBA ***

Symptom

You experience issues using charts / tables within a story in SAP Analytics Cloud (SAC). This guide will help you identify possible root causes.

Do you have a question❔ Ask it here❕ on our amazing SAP Community for SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud

Resolution

First steps to troubleshoot

Simplifying the chart (or table)  is the best way to identify the root cause. Below are some steps/actions to try:

  • Create a Table widget alongside the Chart using the exact same model, linked dimensions and structure as the Chart and verify if the values are refreshed.
  • Explore the measures directly using the Data View to avoid interference of filters and other specific chart features.
    Quick Win: Use the Controls tab to identify which story, page or widget filters are active.
  • Copy the chart to a new canvas page (tab) and try to remove as much as you can the measures, dimensions and active filters.
  • Use the examine feature to see the underlying data of a chart or table. See Examining a Chart or Table for more information.
  • Review Common Chart Errors.

Error Message: Unable to retrieve data from the datasource

Cause: This message is likely due to a problem with the underlying model(s) used in the story.

Troubleshooting:

  • If you have multiple models, test one by one using the Data View option.
  • If you are using Live models, verify that the connection to the data source works as expected.

Error Message: Unable to render chart. Please contact your Administrator

Cause: This message is displayed when the chart encounters an unexpected exception during rendering.

Troubleshooting:

It is likely that you need to open an case with Product Support.
To speed up troubleshooting, capture the following information using Chrome Developer tools (F12 or CTRL+Shift+I using your keyboard):
  1. With Chrome Developer tools open, attempt to refresh the specific chart that fails.
  2. Expand the error being thrown and capture the entire stack trace.
  3. Attach these traces to the Product Support case along with any data on the structure/formatting settings of the chart.

Problem: Chart data is different than before

Cause: This behavior could be due to a multitude of reasons, but it's highly likely a component at a lower level (InA provider) has changed and now returns different data:

  • Start with the first steps to troubleshoot.
  • Identify if the artifact consumed has changed: Calculation View, CDS view, etc.
  • Compare the data retrieved using other tools if possible: HANA Design studio, Lumira, etc.

Problem: Chart shows an error message until I refresh it

Cause: The story was likely saved when the chart was in an error state.

Troubleshooting:

  • Refresh the story.
  • Verify that all widgets are no longer in an error state.
  • Re-save the story.

Collecting information if you need to open an case with Product Support

Cause: You have examined all the previous options but could not identify a cause. You need to open an case with Product Support as indicated in KBA 2487011.

Steps to collect all the information:

  1. Open Chrome Developer tools and go to network tab and check the boxes: disable cache and preserve logs.
  2. Reproduce the behavior opening the problematic chart.
  3. Stop the capture pressing the red button on the top left of Chrome Developer tools.
  4. Right click any of the network calls and select: save HAR with content.
  5. Attach that file with the description of the problem.
  • For complete description with screenshots, see KBA 2280022.

See Also

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

Keywords

chart, widget, bars, 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.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://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 , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-TAB , Table , How To

Product

SAP Analytics Cloud 1.0