SAP Knowledge Base Article - Public

3222134 - Regression: Previous Year variance not available any more

Symptom

Variance disappeared from chart and warning message is shown. (Based on BW Live Connection)

Story had a chart with the following setup:

  • Single measure
  • Dimension: Time hierarchy on month level
  • Time range filter: From current month-11; to current month
  • Time variance: Current Period to Previous Year

Each of the 12 displayed months would have the variance to the same month of previous year.

Now, chart with the exact same setup doesn't work, deviations is not shown and warning message is displayed:

"Variances on time do not include values outside of the data filter on the 0CALMONTH_CALMONTH dimension:- # Depletion Sales (Retailer sell-in) (∆ Previous Year)"

 

Environment

SAP Analytics Cloud - 2022.8.14

Reproducing the Issue

  1. Open Tenant URL.

  2. Open the Story. (Based on a BW Live Connection)

  3. Add a Char and add a Variance based on the Current Period and compare with the Previous Year.

  4. No values displayed on the Variance. (Was working on the past)

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Analytics Cloud, SAC, sapanalyticscloud, variance, current, previous, period, year, time, compare, compareto, compare to, chart, story, model, connection, live, BW, bwliveconnection, error, regression, tenant, data, issue, release, qrc , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0

Attachments

Pasted image.png