Date hierarchy YQM not available in live-connection

[ThomasK]

Hi,

I´ve currently an issue that I can´t use a drill-down from year to quarter to days when using a BW live connection.

My BW query contains the field 0DATE as free characteristic.

I´ve created live a model based on this query.

Then I wanted to use the model in a simple bar chart.

I added the field “Datum” which is technical field “0DATE”.

The result is one bar per day.

The intended visualization should show year by default as dimension.

Then the user should be able to drill down to quarter, then to month and finally to days level.

Unfortunately I have no option (as you can see in the screenshot above) to select any hierarchy in the dimension "Datum".

The field is recognized as date field because the option “Filter by Range …” is available, but I can´t select the desired hierarchy.

Please consider, that this is only the case when I´m using live-connection (no issue with models based on import).

Has anybody a hint why the time hierarchy (YQM) is not appearing?

Thank you in advance!

Regards,

Thomas

[IngoH · Accepted solution]

Hello Thomas,

please take a look at the roadmap for SAP Analytics Cloud with BW. The support for Date as "date dimension" is not full there yet.

Regards

Ingo Hilgefort, SAP

[ThomasK · Accepted solution]

Hello Ingo,

thanks for your quick reply.

I´ve checked the SAC roadmap but couldn´t find anything about "date" or "hierarchy".

I´ve also checked the slides of your last webinar from Nov 14th and couldn´t find any restriction either.

However, many thanks for your information!

Regards,

Thomas

PS: Alternative seems to create a hierarchy manually as Kjell suggested below.

[keinhoff]

Hi Thomas,

as I can see in your Screenshot the hierarchy for 0DATE ist not activated.

Then the selected time hierarchie is available in SAC:

Which BW version are you using with which service pack? Actually we also have some trouble with our own hierarchies but these should be solved with an upgrade to SP12.

regards

Kjell

[ThomasK]

Hi Kjell,

thanks for your post. We are using 7.50 SP11. The hierarchy was not activated there is no hierarchy defined. By default it´s not necessary to create a hierarchy manually for date fields as I know. But your idea to build such a hierarchy is an option I´ll consider. Thanks.

Regards,

Thomas

[keinhoff]

Hi Thomas,

we are also using 7.50 SP11. I did not create a hierarchy manually. We just activated the virtual time hierarchies in the backend.

Regards

Kjell

[ashutosh_rastogi]

If you are using CDS views from S4HANA, this is how you should configure time hierarchies there

https://launchpad.support.sap.com/#/notes/2289865

Regards,

Ashutosh

[ThomasK]

Hi,

thanks for your answer. I´ll recognized the new feature 1 hour ago and will test, whether it solves my issue or not. Keep you updated.

Regards,

Thomas

[ThomasK]

Solved now

[Henry_Banks]

Hi,

the BW Live limitations section from the SAC help guide seems to have moved to a Note : https://launchpad.support.sap.com/#/notes/2715030

Happily, as Ingo suggests, these gaps are being closed asap. for example, Wave 22 just brought Time Series charts for BW Live: https://www.sapanalytics.cloud/product_updates/release-2018-21-2/

other stuff will be delivered in subsequent interactions.

cheers, H