Creating a drill path to an ODBC source

In this recipe, we will be extending drill-through concepts explained in the previous recipe and will create a drill-through path to an ODBC data source.

Getting started

Ensure that the TM1 Admin Server service is started and demodata TM1 Server is running. Open the TM1 Architect tool from the start menu.

How to do it...

  1. Right-click on the Sales_Plan cube and from the Drill menu click on Create Drill Process.
  2. Click on the Next button in the Drill Process Setup Wizard.
  3. For Datasource Type select ODBC and click on Browse.
  4. In the ODBC data source list select Sales_Plan and click on OK.
  5. We have already created the Sales_Plan ODBC in a previous chapter which points to Sales_Plan.xls, having a range defined by name of ...

Get IBM Cognos TM1 Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.