How to apply page filters on different dimensions in a Cross-Tab

Page dimension filters can be used as a pivot filter in the cross-tab providing filtering on any dimension available in the cube. You can have multiple dimensions in page dimension filter. 

 

Example 1 :

The below Sales cross-tab shows Product Category wise Gross sales over different years.

Lets filter the data based on Product Category and Year.

image001.png

SALES CROSS-TAB BEFORE APPLYING THE FILTER

Step 1

In the Cross-tab Toolbar, click Outliner. The system displays the Outliner dialog box.

Step 2

Drag and drop Product Category and Year dimensions from the Cube columns to the Page section. Click OK.


image002.png

OUTLINER WITH PAGE DIMENSION FILTERS



Step 3

The sales cross-tab will be displayed with Page dimension filters on the top.

To apply page filters, you can simply enter / select values in the text field of page filter and click OK. Here, select Bakery, Ice Cream, Snacks and Tea as Categories.

image003.png

SELECTED VALUES 

Step 4

Similarly, select Year as ' 2014' and '2013' and click OK.

The sales cross-tab will be displayed with selected categories for the selected years as below.


image004.png

SALES CROSS-TAB AFTER APPLYING FILTER

 

Example 2:

The below example shows how to filter the cross-tab with Category names that contains 'Drinks'.

Step 1

Follow the procedure of Page Dimension Filter

Step 2

Beside the Product Category text box, click the Setting icon.

The system displays two icons: Delete (to remove the page filter values) and Advanced.

 

Step 3

 

Click the Advanced icon.

The system displays the Advanced filter dialog box based on column data type. In this case, it will show filter dialog box for string data type.

 

Note : You can provide one or multiple filter conditions using Advanced filter. 

Step 3

Select the radio button Include and from the operator’s drop-down list, select the CONTAINS operator.

Step 4

In the value drop-down list, enter the value as 'Drinks' and click ADD.

image005.png

PAGE DIMENSION FILTER - ADVANCED

You can include multiple conditions by clicking ADD.

Click OK to apply the filter.

image006.png

SALES CROSS-TAB SHOWS CATEGORIES THAT CONTAINS 'DRINKS'


Example 3:

Let’s see how to filter the cross-tab data based on the Sales Date column. To show the data of April 2014, follow the below steps.

Step 1

Follow the procedure of Page Dimension Filter

The system displays the Time Series dialog box if the data type of page filter column is date.

Step 2

Select time series elements from Absolute, Relative, and Range time series tabs.

Step 3

In the Absolute tab, select Year as '2014' and Month as 'Apr'.

image007.png

PAGE DIMENSION FILTER – TIMESERIES WINDOW


Click OK to apply the filter.


image008.png

CROSS-TAB AFTER APPLYING THE FILTER

Example 4:

Options for page dimension filtering allow you to add filters on dimensions which are not present in the Cross-Tab. For example, to display the category sales of 'Washington' state for the years 2013 and 2014, follow the below steps.

Step 1

Follow the Procedure of Page Dimension Filter. Drag and drop 'State' and 'Year' to the Page section in the Outliner while creating the cross-tab and click OK.

Step 2

Select the filter values as below.

For the dimension - State = 'Washington'

For the dimension - Year = 2013 and 2014

The result will be displayed as below.

image009.png

SALES CROSS-TAB AFTER APPLYING THE FILTER


Note: This article is based on ElegantJ BI Version 4.1. This may or may not be relevant to the ElegantJ BI version you may be using.