Drill Process & Drill Assignment Rules

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Drill Process & Drill Assignment Rules

Post by appleglaze28 »

I was lookin into the Drill process of TM1. What's the difference with both since I see drill process as like TI while Drill Assignment are like creating rules.

Are drill process dynamic base on the cell you drill through from the orginating cell?

What guide give a better detail of the drill through process cause I think there is a little detail on the developer's guide but not much detail on the flexibility of its function.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: Drill Process & Drill Assignment Rules

Post by David Usherwood »

Drill Process(es) are the TIs which return the data you have drilled to (cube or relational).
Drill Assignment controls which drill processes are available where in the cube.
As an example, if you have budget and actual data in your cube and want to drill back to the ledger for the actuals, the drill assignment would look a bit like:

['Actual'] = s:'ToLedger';
Post Reply