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
  • PrintPrint
Share this Page URL
Help

Drill rules > Creating a drill assignment rule

Creating a drill assignment rule

Creating a drill assignment rule Although a drill rule is really just another TM1 rule, it is not visible when you open the TM1 Rules Editor in the usual way (discussed in an earlier chapter of this book). To create a TM1 drill rule you need to perform the following steps: Right-click on the source cube (the cube you will be drilling from) from within TM1 Server Explorer.Select Drill.Then select Create Drill Assignment Rule. This will open the TM1 Rules Editor, but any non-drill rules that are currently associated with this cube will not be displayed: Once the Rules Editor is open, you can continue to create your drill rule. First, as with any TM1 rule, you need to define the area within your cube that you want to associate with the drill-through. The simplest area definition might be to associate all cells in the cube with the drill-through. To do this you can use the Area button in the Rules Editor, or simply type in the empty brackets []. To narrow the area definition (to reduce the number of cells in the cube that are associated with the drill-through), you should select the element or elements that define the cells you want to specifically associate with the detailed data. Again, you can do this manually or use the Rules Editor by performing the following steps: Click the Area button. When you do this the Reference to Cube dialog box opens.Then, click on the Dimension button and select the elements that define the cells that you want to associate with the drill-through data.Finally, click on OK:

  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint