Introduction
Linking of datablocks is very important and frequently used for:
Connecting - Linking any Image datablock with other dashboard serving as icon or shortcut
Filtering - Filtering of data from one datablock to other
Prerequisite
One or more datablocks
Using Link
Connecting
1. Add an Image datablock.
2. Link to a dashboard or datablock.
3. Select Home dashboard.
4. Click on Image datablock. It will open the Home dashboard.
Filtering
1. Create a Cube Report whose data is to be filtered.
2. Create another Cube Report or Drillthrough to display the filtered data.
In the Cube Report, the Measure and X axis selections can be same or different depending on the need. While the linking dimension needs to be same.
3. Link the first Cube Report to the second Cube Report.
4. Click on any of the sector from the first Cube Report, and the respective data will get filtered and displayed in the second Cube Report.
Using One Level Link
The One Level Link feature allows only to send filter from the clicked datablock, excluding the ancestor filters. See example below.
The cube report Purpose is linked to Direction, and Direction is linked to Segment Type. Here, the One Level Link is not used in any linking, so Segment Type datablock is receiving data which is filtered from Direction (Inbound).
Now Direction datablock is linked with Segment Type, with One Level Link enabled. Here, Segment Type is not considering the filtered data present in Direction datablock.
Datablock Link Relationships
x means supported
DB Type | Metric Grid | Status | Advanced Chart | Cube Report | Drillthrough | Gauge | Map | Text Editor | WebFrame | Generic Grid | Score Card | Score List | Heat Map |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tree | x | x | x | x | x | x | x | x | |||||
Report Tree | x | ||||||||||||
Metric Grid | x | x | x | x | x | x | x | x | |||||
Status | x | x | x | ||||||||||
Advanced Chart | |||||||||||||
Cube Report | x | x | |||||||||||
Drill Through | |||||||||||||
Gauge | x | x | x | ||||||||||
Map | x | x | |||||||||||
Date Picker | x | x | x | x | x | x | |||||||
Web Frame | |||||||||||||
Generic Grid | x | x | x | x | |||||||||
Text Editor | |||||||||||||
Cube Filter | x | x | x | x | |||||||||
Dimension Filter | x | x | x | x | |||||||||
Image | x | ||||||||||||
Score Card | x | x | |||||||||||
Score List | x | x | |||||||||||
Heat Map | x | x | |||||||||||
KPI Admin |