Skip to Content
Aug 29, 2018 at 07:35 AM

How to use time hierarchy in a cloud story based on a ABAP CDS View datamodel?


Hello Everyone,

I want to use a time hierarchy in my SAP Analytics Cloud story with a ABAP CDS View based datamodel.

At first I want to provide my system information:

  • SAP Netweaver 752 Version 0003
  • DB: SAP HANA 2.0 SPS03 Rev 031.00
  • SAP Analytics Cloud Test Tenant Versions 2018.15.2 (Client) + 2018.15.1 (Server)

I'm accessing my ABAP CDS Query View via a S/4 Hana Live Connection (no data upload to the cloud). Below my ABAP CDS Query View there is a Cube-View where I defined an association to the SAP standard calendar view "I_CalendarDate". I've added all the fields coming with this I_CalendarDate view to my Cube and Query view.

I'm able to see the hierarchy (Year, Month, Date - see screenshot) in SAP transaction RSRT. But not in the cloud. Does anyone of you know, how to activate the time hierarchy to use it in a cloud story?

And this is how my ABAP CDS Views are implemented:

...and the Query-View on top of the Cube-View:

When using this query view in a cloud story, there is no drilldown functionality available.

Thank you very much,

best regards,

Thorsten Wülpern


cube-view.png (53.0 kB)
cube-view-2.png (30.3 kB)
query-view.png (57.4 kB)
query-view2.png (50.8 kB)
no-drill-cloud.png (11.9 kB)