SAP Knowledge Base Article - Preview

2914688 - Time Hierarchy keeps aggregating with Live Connection to HANA in SAP Analytics Cloud (SAC)

Symptom

  • Time Hierarchy keeps aggregating with Live Connection to HANA in SAP Analytics Cloud (SAC) 
  • Chrome Developer tool shows the following exception: 

[Error] Server: (#42014) Caught exception : exception 52731: Hierarchy cache error for hierarchy timeHierarchy : Hierarchy create error for "_SYS_BIC"."Demo/xxxx/timeHierarchy/hier/timeHierarchy" error: SQL: invalid DATE, TIME or TIMESTAMP value: search table error: "_SYS_BIC"."xxxx": line 12 col 2 (at pos 616): [303] (range 3) invalid DATE, TIME or TIMESTAMP value exception: invalid DATE, TIME or TIMESTAMP value: internal error in AddYears('0001-01-01', -2) 

  • There is no issue with the aggregation based on the same HANA in Analysis for Office 


Read more...

Environment

  • SAP Analytics Cloud (Enterprise) 2020.2
  • Live Connection to HANA 

Product

SAP Analytics Cloud 1.0

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 , KBA , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.