Dimension Filter (Datablocks)
- Arielle Kaye Odeste
Analytics
Overview / Description
Dimension Filter datablock is used to filter the report with specific values of dimensions associated with it.
This can be used by linking with Cube Report, Status, and Drillthrough datablocks.
Common Use Case
Dimension filter allows you to analyze reports without having report editing rights, e.g. Dashboard Viewer.
Pre-requisites
Existing cube report to reside on the dashboard
Dimension filter must be of the same Index as the one on which the report is built
Add Dimension Filter to a Page
1. Select the page where you want to add a datablock. In this example, Training Demo page is selected.
2. From Edit Page menu, select Add Content.
The Add Content setting will display.
3. Input the number of datablocks you want to add to the page, then click Add.
The Select Datablock sub-setting will display.
4. Select Dimension Filter from the datablock options.
5. Update the Datablock Title and Datablock Style accordingly.
6. Click Add.
The added datablock will display on the page.
7. On the datablock header, click the Choose Datasource icon.
The Choose Data Source window will display.
8. Select Index and Dimension. You can select more than one dimension.
9. Click Ok.
The selected datasource will now display on the Dimension Filter datablock.
10. Under Edit Page menu, select Save Page to save the datablock in the page.
Once the changes have been saved, a success message will display on the top right corner of the screen.
Link Dimension Filter to Another Datablock
A Dimension Filter can be linked to a report datablock on your existing dashboard/page.
In this example, the dimension filter will be linked to the existing cube report in the page.
1. On the datablock header, click the Link icon.
The Link Targets window will display.
2. Select the datablock to where you want to link the date picker.
3. Click Link.
The selected datablock is now linked to the dimension filter.
To check if the link is working,
4. Select the dimensions you want to display on the linked cube report.
5. Click the Filter icon.
The displayed data on the linked cube report will update according to the selected dimensions.
The applied dimensions filter on the linked datablock is displayed on the datablock’s header.
Dimension Filter UI Controls
Change Type
Change Type allows you to change the display mode. The default display mode is Treeview.
To learn more about the other dimension filter UI controls, go to UI Controls.