Enabling custom drill through using the reporting and data entry template

To enable drill through using the reporting and data entry template:

  1. Open the Navigation Administration page.
  2. Click the Design Navigation tab.
  3. Right-click a folder or an existing page and select Add Page. You can add the page as a child or as a sibling.
  4. Specify the name for the page in the Default Name box.
  5. Specify the URL for the page.
  6. Browse to the image to use for the thumbnail view.
  7. Browse to the image to use in the preview window.
  8. Select the groups that should have access to the page. Select the Inherited check box if you want the page to inherit permissions from its parent so you do not need to set individual permission on the page.
  9. Click Create.

Example

You must specify the g option. Optionally, you can specify the SQLDrillDataSource parameter to set a data source for drilling outside the CPM model.

path/page name?Form=title displayed above grid&View=view name&Options=desired options, include g&QueryName=NAME column of the SQLDrill_Query_Template table &SQLDrillDataSource=OutsideDataSourceName

For example:

/CPM/Workstation/TPLDisplayView.aspx?View=CT MR Game Machine Sales&Options=reg&QueryName=OrdersByUnit

In this example, the connection information defined in the SQLDrillDataSource parameter, SalesDataSource , is used to execute the SalesQuery.

/CPM/Workstation/TPLDisplayView.aspx?View=Sales Rpt&Options=reg&QueryName=SalesQuery&SQLDrillDataSource=SalesDataSource