SAP Knowledge Base Article - Public

2860204 - Function Dynamically Set Min/Max on a Chart Axis doesn't work when a fixed-value reference line is added above all points shown in the chart in SAP Analytics Cloud (SAC)

Symptom

  • Function Dynamically Set Min/Max on a Chart Axis doesn't work when a fixed-value reference line is added above all points shown in the chart in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2019.15.15

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a new story based on sample model [BestRunJuice_SampleModel].
  3. Change Chart Structure to Line.
  4. Select [Gross Margin] into Measures and [Sales manager] into Dimensions.
  5. Add filter on [Sales manager] to Exclude [James Frank].
  6. Click Edit Axis from action menu, and then enable Dynamically Set Min/Max.
    => The lower value of Y axis will be adjusted to 5 (M), since the lowest value of [Gross Margin] shown in the chart is 8.40 (M).
  7. Add a Reference Line with Fixed value as 50M, which is bigger than the highest value of [Gross Margin] shown in the chart (47.47 M).
    => The lower value of Y axis will be reverted back to 0.
    => The function Dynamically Set Min/Max on a Chart Axis doesn't work anymore.
    => The issue doesn't happen when the fixed value is set between the lowest value and the highest value shown in chart.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

Workaround: apply dynamic-value reference line to max value of the measure shown in the chart.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, Dynamically, Dynamical, Set, Max, Min, Axis, Reference, line, fix, fixed, above, over , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0