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