SAP Analytics Cloud - Issue Time Variance Analysis

guenay — Mon, 17 Aug 2020 19:28:14 GMT

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:

Re: SAP Analytics Cloud - Issue Time Variance Analysis

JensBraun — Tue, 18 Aug 2020 07:31:17 GMT

Hello Ismail,

I suggest that you create an incident in the SAP support portal for this. This error needs to be analyzed in the system.

Regards,
Jens

Re: SAP Analytics Cloud - Issue Time Variance Analysis

guenay — Tue, 18 Aug 2020 08:33:25 GMT

jensbraun Thanks for your quick answer.

Re: SAP Analytics Cloud - Issue Time Variance Analysis

former_member245931 — Tue, 10 Aug 2021 16:06:25 GMT

Hi guenay,

Even we are getting the same issue, were you able to solve this?

Question Re: SAP Analytics Cloud - Issue Time Variance Analysis in Technology Q&A

SAP Analytics Cloud - Issue Time Variance Analysis

Re: SAP Analytics Cloud - Issue Time Variance Analysis

Re: SAP Analytics Cloud - Issue Time Variance Analysis

Re: SAP Analytics Cloud - Issue Time Variance Analysis