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: