Feeders in Drill through Rules

[Jodha]

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

[TrevorGoss]

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.

[declanr]

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.

[TrevorGoss]

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.

[Jodha]

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 .

[lotsaram]

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.

[Jodha]

Thanks Lotsaram