Entire Site
Free Trial
Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- DownloadDownload
- PrintPrint
Drill process > Creating a drill process
Creating a drill process
A drill process can be created by performing the following steps:
- Select the source or originating cube (the cube you will be drilling from) and right-click on it (in TM1 Server Explorer).
- Select Create Drill Process... from the menu.
- At this point, a dialog opens displaying a list of parameter values for the origination (source) cube and all of the cube's dimensions.
- TM1 uses these values as parameters to the drill process when executing (drilling) from a source cube to a destination cube.
- Click on Next, and the second dialog is displayed. Then, you can select the Datasource Type for your drill-to data.
- At this point you need to define the data source that you selected in step 5.
- For example, if you decide to use an ODBC data source, you will need to supply the following things:
- Datasource Name: This is the official name given to the ODBC data source (DSN) that you want to access when drilling from your source cube. Remember that this DSN must be accessible to the machine where the TM1 Server is running.
- User Name: This is the valid user name which TM1 will use to log into the ODBC data source that you are using.
- Password: This is the password that the user name you set is to use.
- Query: This is the query that defines the data or information to return from the ODBC data source. These results will be displayed in your drill-to window.
