SAP Knowledge Base Article - Public

2789371 - How to show/hide Dynamic Reference Line automatically according to applied filters in SAP Analytics Cloud (SAC)

Symptom

How to show/hide Dynamic Reference Line automatically according to applied filters in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story with Bar/Column chart on sample model [BestRunJuice_SampleModel].
  3. Select [Grass Margin] into Measures and [Product] into Dimensions.
  4. From action menu, select Add Reference Line.
  5. Choose Dynamic and then select [Gross Margin] as Measure.
    => One reference line will be added into the chart.
  6. Apply one filter (story filter or page filter or chart filter or filter by linked analysis) on another dimension like [Sales Manager] to the chart.
    => Check or uncheck values from the filter, but the reference line still appears in the chart.
    => How to show/hide Dynamic Reference Line automatically according to applied filters?
         for example, only showing the reference line when filtering with [Janet Bury] for [Sales Manager].

Resolution

Edit the reference line to add one Reference Line Filters on same dimension (i.e., [Sales Manager] = [Janet Bury]).

In this case, once the same filter (same dimension & same value including larger range or list) is applied to the chart, the reference will be shown. Otherwise, it will be hided.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, reference line, dynamic, show, hide, appear, display, filter , KBA , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , How To

Product

SAP Analytics Cloud 1.0