Parameterized drillback to a dashboard

You can parameterize a drillback action. That is, you can specify that the target dashboard displays specific information when it is accessed.

The link of a parameterized drillback action can be constructed from any application which supports federated authentication and which can create the link in a specified format.

Parameterized drillback

?LogicalId=lid://infor.bestpractices-bi.1
&BIProject=BIBestPr
&DashboardName=Novrdicpanel80
&DashboardLinkParams=&connections=Scaling*1000'Unit*[UNIT].[G0000]'ThisMonth*[TIME].[All Years].[2016].[Q1_2016].[01_2016]'ThisYear*[TIME].[All Years].[2016]'CurrencyType*[CURRTYPE].[LC]'InterCompany*[INTERCO].[TotalPartner]

This table describes the elements of this example:

Parameter Description
LogicalId Logical ID of the target Infor EPM application.
BIProject Unique name of the application.
DashboardName Unique name of the dashboard.
DashboardLinkParams Collection of parameters accepted by the dashboard.
Connections Contains all parameters that are used for the configuration of the dashboard.
  • Scaling
  • ThisMonth
  • ThisYear
  • CurrencyType
  • InterCompany
 Widget communication connections, which are set in the widget communication configuration in the dashboards.

Parameterized drillbacks have these characteristics:

  • All the parameters that are used for configuring the dashboard are inside the connections parameter.
  • The apostrophe and asterisk characters differentiate between connection data.
  • The apostrophe is the delimiter for each network record.

    The ID of a connection record is distinguished from the record's value by an asterisk. If an apostrophe or asterisk forms part of the data, escape it by repeating it.

    Both ID and value must be encoded for URL in a standard way (encodeURIComponent). Before encoding the ID and value, the DashboardLinkParams must be escaped (Uri.EscapeDataString).

    An example of the encoded value for DashboardLinkParams:
    %26connections%3DScaling%252A1000%2527Unit%252A%255BUNIT%255D.%255BG0000%255D%2527ThisMonth%252A%255BTIME%255D.%255BAll%2520Years%255D.%255B2016%255D.%255BQ1_2016%255D.%255B01_2016%255D%2527ThisYear%252A%255BTIME%255D.%255BAll%2520Years%255D.%255B2016%255D%2527CurrencyType%252A%255BCURRTYPE%255D.%255BLC%255D%2527InterCompany%252A%255BINTERCO%255D.%255BTotalPartner%255D
  • The value can be prepared by a dashboard application when the dashboard is opened in the required state and a Full Context link from a Create Dashboard link dialog box is used.