on 2020 Aug 17 8:28 PM
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:


Request clarification before answering.
Hi guenay,
Even we are getting the same issue, were you able to solve this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.