SAP Knowledge Base Article - Public

2654827 - SAP Analytics Cloud Time Series chart using HANA Live connection is not rendering data

Symptom

  • Getting an error message Unable to render chart. Please contact your administrator
  • Time Series is connected to HANA Live Connection

Environment

  • SAP Analytics Cloud 2018.8.1
  • SAP HANA

Reproducing the Issue

  1. Having a HANA Live connection with a level Hierarchy with Year,Quarter,Month,Day
  2. Build a story with two charts a bar char and another a Time Series
  3. Using the bar char you can see the level 4 is selected which is Month level of hierarchy and it is working
  4. Then you select the time series chart at the month level same as the previous step
  5. Notice an error Unable to render chart. Please contact your Administrator

Bar Char using Level Hierarchy based on HANA Live Connection.png

 

 Time Serie Error with HANA Live Connection.png

Cause

Resolution

  • Generate the time hierarchy in the HANA back end and ensure the data format for each of the appropiate level falls under the following (YYYY, H1/H2, YYYQ. YYYYWW, YYYY-MM-DD)
  • You can notice that if you have if any format works correctly is because it falls under the right format. 
  • If you any format like QQ,MM, DD instead of YYYQ , YYYYM,  YYYY-MM-DD it will not work. 
  • Also check the correct official documentation and version for your HANA

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

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, No data is available for the chart to render , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0