Introducing SAP Analytics Cloud

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
  • Filter with story components

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

Task 1: Optional: Use Cascaded Filtering

Steps

  1. Add a new canvas page to a story.

    1. In the story, on the upper right choose Edit.

    2. Hover in the page area and choose +Add New PageCanvasChoose Table..

    Result

    A new table is added to the page and the data source on the upper right is PACIFICA_ORDER_FINANCE.
  2. Configure the table as follows:

    Table SettingsSelection
    RowsChoose +Add Measures/DimensionsSelect Store
    ColumnsMeasures (default)
    Filters:Measures = Price (default)
    1. Configure the table as shown above.

    Result

    The table displays stores in the rows with price in the column.
  3. Save the story from the ribbon or press Ctrl+S.

  4. Add an input control for Region and restrict it to All Members.

    1. From the ribbon, choose Input Control(or use the More menu).

    2. If needed switch the data source to PACIFICA_ORDER_FINANCE.

    3. Choose DimensionsRegion. Select All Membersand choose OK.

    4. If needed, drag the input control to the right of the table.

    5. Enlarge the input control and expand the selection so that you can see all of the regions.

  5. Add an input control for Location and restrict it to All Members.

    1. From the ribbon, choose Input Control(or use the More menu).

    2. If needed switch the data source to PACIFICA_ORDER_FINANCE.

    3. Choose DimensionsLocation. Select All Membersand choose OK.

    4. If needed, drag the input control to the right of the Region input control.

    5. Enlarge the input control and expand the selection so that you can see all of the locations.

  6. For the Location input control, use ...More Actions to confirm that Cascading Effect is enabled.

  7. Format the table and input controls with a background of your choice and with all borders turned on.

  8. In the Region input control, select only NA.

    Result

    The location input control only displays Canada and USA. The table only displays data for Canada and USA.
  9. In the Region input control, select only APJ.

    Result

    The location input control only displays India and Japan (and a hyperlink option to Show Inactive Values. Here an example for group 10:
  10. Press Ctrl+S to save the story. Return to the home page.

    Result

    You have completed this exercise.

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

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