SAP Analytics Cloud - Issue Time Variance Analysis

In SAP Analytics Cloud we’re trying to add a time variance analysis based on a live data connection to BW 7.5 SP 16.

The individual steps are described in the documentation.

In the first step, we create a bar chart based on the data source ZCO_C019_S001.

Select the following measure DB 3 (% v. Fakturumsatz) and dimension Calendar day and set the hierarchy to FyearFperDayZ4:

For the hierarchy FyearFperDayZ4, it is not possible to add a version here:

When selecting the hierarchy OYEA_MON_DAY, it is possible to add the time variance on calendar day (the navigation attributes for OCalDay are activated, consider Note https://launchpad.support.sap.com/#/notes/2948031).

The drill-down to month level provides the following view:

Add Variance and Add Version Calendar day:

Get the error message “Unable to retrieve data from the datasource”.

Then we select another measure Verwaltungs-GK, dimension calendar day and we get the same error message, but without a run-time error in the BW.

For the data source ZFC_X003_Q001 we do a time variance analysis based on a measure and dimension calendar day. Here it works and we got with the following result: