SAP Knowledge Base Article - Public

3021846 - Cannot use Previous date filter with Date member selection filter at once in SAP Analytics Cloud (SAC)

Symptom

  • Cannot use the filters "previous date" and the "select date members" in one chart at once.
  • Customer expects, that story/chart filters should work like in the Dashboard report:
    • when opening the report, the "previous date" data should be loaded into the chart,
    • however, users should be able to filter on data with different date, too.
  • e.g. you want the chart to show the data from previous date (e.g. if today is Feb 5, then previous date is Feb 4), and you would like to have that date shown in the chart. The date "Feb 5" should be changed dynamically by the story viewer easily, so if the viewer wants to look at the data on Jan 20, then there is a way to set the previous date to "Jan 20".

Environment

  • SAP Analytics Cloud (Enterprise) 2020.21.14

Reproducing the Issue

Scenario 1

  1. Log on to SAC tenant.
  2. Create a story with a chart e.g. Comparison - Bar/Column on a sample model [BestRunCorp_Retail].
  3. Select Measures e.g. [Sales Revenue]  and Dimensions e.g. [City].
  4. Add a Story filter e.g. in the story main panel Tools - Add Story Filter/Prompt - Add Time Filters e.g. "Previous" - "Day" => data will be loaded for previous date.
  5. Try to add a story filter e.g. Tools - Add Story Filter/Prompt - Dimensions - [Date] dimension is grayed out.

Scenario2

  1. Log on to SAC tenant.
  2. Create a story with a chart e.g. Comparison - Bar/Column on a sample model [BestRunCorp_Retail].
  3. Select Measures e.g. [Sales Revenue]  and Dimensions e.g. [City].
  4. Create Chart filter "Previous Date" e.g. [Date (Range)]:
    1. Range Type [Offset], Granularity [Day], Look Back [0], Look Ahead [0]
    2. Offset Direction [Look Back], Offset Granularity [Day], Offset Amount [1]
    3. Set the Settings for User: "Allow viewers to modify selections", "Unrestricted Drilling", "Single Selection".
  5. Create Chart filter for free date selection e.g. [Date (Member)]:
    1. Select members e.g. years [2019, 2020, 2021]
    2. Set the Settings for User: "Allow viewers to modify selections".
  6. Notice, that only one date filter will be available, the "Previous Date" filter will disappear.
  7. If you add a Story filter instead of the chart filter e.g. in the story main panel Tools - Add Story Filter/Prompt - Dimensions - [Date] - Filter by Member:
    1. Select members e.g. years [2019, 2020, 2021]
    2. Set the Settings for User: "Allow viewers to modify selections".
  8. Only data for "Previous Date" filter will be loaded.

Cause

  • You can only have 1 current date input control defined for the entire story.  However you can link multiple range filters to it.
  • You can only create 1 filter on a specific dimension for each chart or table.  For example, you cannot create multiple filters (e.g. one range filter and another member selection filter) on the same "shipping date" dimension.  This is the same for story filters as well. 
  • You can find more information about Current Date input control .

Resolution

  1. Create the previous date filter as usual in the chart, either by using the "Previous" -> Day shortcut or build your own manually.
  2. Edit the previous day filter.  In the filter dialog, you should be able to see the a drop down box under the header "Current Date". By default, the drop down box shows the entry "System Date / Period". 
  3. Click this drop down box.  You should see the option "Create Current Date Input Control...".  Click it and another pop up should be shown.
  4. In this new current date input control pop up you can specify the name of the input control and the granularity (e.g. you can change it to day).
  5. Click OK on both dialogs and you should be back to the story page.
  • Effectively you have set up your previous date filter to be driven by the current date input control.
  • You should be able to see the current date input control show up in the story filter bar.
  • Now depending on what date you select in the current date input control the previous date filter should be automatically updated to reflect that.

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, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0