Link to another report

An ability to create links to other reports is important for transforming static data views into a dynamic, intuitive, and efficient analytical experience. This feature, often called "drill-through" or "report linking", addresses several key business intelligence needs:

• Links allow users to start with a high-level summary report (e.g., total sales by region) and then click on a data point (like a specific region) to instantly jump to a detailed report filtered by that context (e.g., sales by product within that specific region). Users can explore the data and answer their questions simply by navigating links, which makes the experience better and more productive.
  Note that SeekTable has built-in drill-down function for pivot tables which moves to more detailed data.
• Use links to automatically pass relevant parameters (like the selected date range, region, or product category) to the target report. Users don't have to manually re-apply filters, which saves them time and helps avoid mistakes.

How to link dimension values

You can create a HTML formatted dimension to link values in flat tables (where dimensions are used as columns) or linked headers in pivot tables:

1. Go to cube's configuration form.
2. Add a new dimension:
   1. Type=Expression
   2. Name=linked_dim (specify any meaningful name)
   3. In Parameters click + Value and set an expression:

      Html.Link( "/report/ANOTHER_REPORT_ID?cfg="+Html.UrlEncode( Json.Serialize(
      {"Parameters": {"PARAM1": Dimension["ARG_DIM1"], "PARAM2": Dimension["ARG_DIM2"] } } ) ), "Details", true)

      Then add one or more dimension names that you need to use in your link:

      ARG_DIM1

      ARG_DIM2

   where
   • ANOTHER_REPORT_ID is an ID of the target report (this value is present in the report's URL).
   • PARAM1 and PARAM2 are names of the parameters to set in the target report.
   • ARG_DIM1 and ARG_DIM2 are names of the dimensions which value should be used as arguments.
   • "Details" is a linked text. This can be a dynamic value, for instance Dimension["ARG_DIM1"].
   • true opens the link in a new tab.

Note: when you use this dimension in a pivot table, the underlying data is grouped by all the dimensions you include as arguments.