Adding Auto-Drilldown to a Logical Model
The following examples illustrate how to pass parameters to a target report or web page by adding an auto-drilldown to a logical model. There are two basic kinds of parameter values that you can pass in an auto-drilldown:
• You can pass actual column data values, i.e., the hyperlinked values that are clicked by the end user.
• You can pass values derived from a query based on the column data.
Example 1: Passing column values in a drilldown. In this example you will add an auto-drilldown to the “Order Model” to provide drilldown hyperlinks from the ‘Customer’ > ‘Company’ attribute to the ‘OrderList’ report (in classes/ inetsoft/demos). The ‘OrderList’ report is designed to accept five parameters, one of those being ‘customer,’ which represents the company name of the customer.
When the user views this report in the Report Portal, they will see hyperlinks on all the names in the ‘Company’ column. These are the links added by the auto-drilldown.
This example illustrated how to pass column values in an auto-drilldown lto a report. It is also possible to pass query-based parameters to a report. The procedure is the same as passing query-basedparameters to a web page, which is described in the Example 2: Passing query-based values in drilldown.
Example 2: Passing query-based values in drill. The example above illustrated how to add an auto-drill to pass actual column values as parameters to a report. Sometimes, you do not want to transmit the column values themselves, but rather some information that is related to the column values. To do this, you can add a query-based auto-drilldown to the logical model.
|
View a 2-minute demonstration of InetSoft's easy, agile, and robust BI software. |