TM1 Forum

Is it required to write feeders for drill through rule ? My assumption it is not required please advise .

I am on 10.2.2 FP2

Hello,

Is it required to write feeders for drill through rule ? My assumption it is not required please advise .

What, excatly, do you mean by a "drill through rule"? It is my understanding that a feeder needs to be considered when you have SKIPCHECK declared. If the Rule is at N level and it is not returning a 0 then a Feeder rule is required.

I am on 10.2.2 FP2

While I am here, do you use the advanced rules editor in 10.2.2 FP2? As it's maintainence and possibly its existence as a whole is moribund.

Thanks.

Trevor.

TrevorGoss wrote:Hello,
What, excatly, do you mean by a "drill through rule"? It is my understanding that a feeder needs to be considered when you have SKIPCHECK declared. If the Rule is at N level and it is not returning a 0 then a Feeder rule is required.

I presume the OP is referring to Drill Assignment rules; which are assigned to a cube in order to specify which cells can initiate which drill process/processes. It would be entirely string (no N cells).

The concept of a drill process is that you would want to be able to drill from any cell; even if that cell has a zero in it - it's possible that the user would want to drill to the source system or cube to see that zero or what makes up that zero.
As such I have never put skipcheck or feeders on a drill assignment rule and (other users may disagree) have never noticed any performance issues etc.

I presume the OP is referring to Drill Assignment rules; which are assigned to a cube in order to specify which cells can initiate which drill process/processes. It would be entirely string (no N cells).

The concept of a drill process is that you would want to be able to drill from any cell; even if that cell has a zero in it - it's possible that the user would want to drill to the source system or cube to see that zero or what makes up that zero.
As such I have never put skipcheck or feeders on a drill assignment rule and (other users may disagree) have never noticed any performance issues etc.

Hello Declan, thanks for this information, never used these before.

Thanks.

Trevor.

Thanks Declanr for confirming.

I am using drill through process to get detail level from cube1 after adding extra drill through for cube 2 my server started crashing if i drill to cube 2 . I was bit skeptic about feeders ,I will check TI code then, I am assuming it is creating very large view which is consuming complete server resources .

Whatever you are doing about copying data or building a view would be a separate issue.

In relation to the actual question of the post a resounding "no". Drill assignment rules do not require feedstrings or feeders. The cells for Drill rules are all strings and are only evaluated on demand when a user right clicks a cell in the context of that single cell hence there could never possibly be a need to feed.

Thanks Lotsaram