Filtering Data in Stories

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Filter data in stories

Page Filters

Story and Page Filters

Use story and page filters to narrow the scope of your analysis.

Story filters allow you to apply filters for all charts in a story that are based on the same model. They are used for specific dimensions or measures and can apply to all components of a story.

Page filters are the same as story filters, but apply to only one page in a story.

You can also use linked filters, with advanced filter options.

Note

Page and story filters are enabled only after you have added at least one data source to your story.

Prompts

A data source for a chart or table may prompt you to select members before data can be displayed. If the data source you select to create a chart or table requires variables to be set, a prompt will appear when you create the first chart or table that uses the datasource. After the variables are set, the information you provide will be used by all tables and charts that use the same datasource.

Input Controls

As you create your story, you may want certain information to be readily accessible, but not always displayed. Input controls allow you to do just this. They allow users to filter data, compare figures, and explore relationships directly from a story page.

You can use the following input controls:

  • Dimension Input Controls: Use the dimension input control to change the dimension that is represented on a chart or table at view time.
  • Measure Input Controls: Use the measure input control to change the measure that is represented on a chart or table at view time.

Watch this video to learn how to create Input Controls.

Chart to Chart Filtering

In chart-to-chart filtering, you have the option to add new tabs and set filters to jump from one page to another. For example, as shown in the figure Chart Component Hyperlink Filter, you can set a filter to jump to a detailed report for West US from a summary report.

If you select "Apply Selected dimension as filter", you will also have an option to enable the cascading filter. Selecting this option will pass your selected cell as a filter value to the detailed report.

Filter Controls

As shown in the figure below, the Controls button hides or displays a summary of any filters that are in effect in the story, page, or a specific widget. The Filter button in the Main toolbar exposes the page filter bar, displaying any filters for that specific page. Finally, when a widget has a filter applied, "Filter" is indicated in the widget title.

Canvas Sections

Sections are like containers for your story. They are useful for reporting, but also for dashboarding thanks to the carousel, if you are working with a canvas page.

Essentially, they allow you to split report information into smaller, more comprehensible and manageable parts.

You can use sections to improve the layout of your stories and break down your analysis per dimension member. Once you have chosen a dimension as section filter, the members are displayed in the section heading. The widgets in the section based on the same model are filtered on that member.

Watch this video to learn how to create and use a section.

Advanced Filters

Advanced filtering allows you to create story and page filters based on multiple dimensions by defining a set of logical conditions.

The dimensions used in advanced filtering can be filtered by using AND or OR conditions. These conditions can be set to include or exclude the data that satisfies the filter conditions.

The figure below illustrates an example where advanced filters have been used to return United States data for all years and overseas data only for 2018.

You can apply advanced filters by creating dimension tuples. A dimension tuple consists of a condition which contains a number of dimension filters. If the dimension members are different, the result will create an asymmetrical filter.

Currently, advanced filtering can be used with Story and Page filters.

Cascading Filters

Changes you make to a story or page filter affect related filters in the same story or page. For example, if you have both Country and Region filters on a page, and you change the Country filter value from All to Sweden, the Region filter updates to show only regions within Sweden. All other region names are hidden.

This cascading filter effect is applied by default. You can turn it off in the More options for a specific filter or input control.

Filtering

Task Flow

In this exercise, you will perform the following activities:

  • Create a new story
  • Use an input control
  • Use a dimension input control
  • Add a text widget to display filters
  • Set up chart-to-chart filtering
  • Use filter controls
  • Use canvas sections
  • Use advanced filtering
  • Use cascaded filtering

Story Component Filters

In SAP Analytics Cloud, you can also filter with story components. The figure below explains the different options.

Use Measure and Time Input Controls for a Time Series and Scatterplot

You want to enhance your understanding of the company’s performance over time. To do this, you create several visualizations that compare key KPIs from one period to another.

Task Flow

In this exercise, you will perform the following tasks:

  • Work with a scatterplot chart
  • Add a calculation for gross margin % and format it
  • Work with a time series chart
  • Use a measure input control to switch the KPI to be analyzed
  • Add an input control for a time range

Task 1: Copy a Story

Steps

  1. From the Navigation Bar choose Files → Public → SACMS1_32 → Content.

  2. Select P00S_PacificaFinance and copy the story as follows:

    FieldValue
    NameU##S_PacificaFinance
    DescriptionU## Pacifica Finance Story
    1. Select P00S_PacificaFinance.

    1. Choose Copy.

    1. Enter the data provided.

    2. Choose OK.

  3. Go to the My Files folder and open the U##S_PacificaFinance story.

Save progress to your learning plan by logging in or creating an account