Skip to content

Searching and selecting dimension and/or data field values

General Concept

When generating a report, it is often necessary to display data for particular dimension (and/or data column) values only.

u-Slicer allows you to search and select the required dimension (and/or data column) values quickly and easily for any dimensions (and/or data columns) and combinations thereof. You can use the simple filter for selecting directly the desired dimension values, the advanced filter for selecting the desired combinations of dimension values and their mappings, as well as data filters for selecting desired combinations of data column values.

When you apply various search criteria subsequently to different dimensions, the corresponding Split Chain is created to facilitate your navigation through the Slicer data.

The Split Chain is located in the upper left corner and displays the current sequence of selected dimension values.

When you apply various filters to data columns, currently selected filtering criteria are displayed under the each data column name correspondingly.

When you open a Slicer for the first time, UI looks like as follows depending on your project:

Selecting date ranges

To select the desired date range:

  • Open the Calendar control.

  • Select the desired date range using one of the following options:

    • Click the corresponding shortcut: 90 days, 60 days, 30 days, 14 days, 7 days or 3 days.
    • Enter the start and end dates into the corresponding boxes. Supported formats:
      • Absolute dates: YYYY-MM-DD.
      • Relative dates:
        • today, yesterday,
        • - N d and - N days for the number of days since the current date, where N - any positive integer or zero.
        • - N m and - N months for the number of months since the current date, where N - any positive integer or zero.
        • - N m_first, - N months_first, - N m_last and - N month_last for the first and the last day of the specified monthcorrespondingly, where N - any positive integer or zero.

  • Select the start and end dates by clicking the corresponding days in the Calendar.

  • Click the Apply button.

Selecting Dimensions

To select the desired dimension:

  • Open the dimension selection dialog box.
  • Click the desired dimension.

OR

  • Enter a search string into the Please select a dimension box.

  • Only dimensions matching the specified search string are displayed.

  • Click the desired dimension.

Selecting Data Columns

You can display only really required data columns at any time.

To show/hide particular data columns:

  • Click the  ( Manage Columns) button in the upper right corner of the Data Table and select/deselect columns in the appeared Column management dialog box.

  • Click the Apply button to return to the main window. Data columns and corresponding Chart parameters are shown/hidden correspondingly.