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:
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,