Drill Thru help

Post Reply
vish
Posts: 10
Joined: Wed Feb 18, 2009 4:54 pm
Version: 9.5
Excel Version: 2003

Drill Thru help

Post by vish »

Hi ,
Just trying to work on the Drill thru using the Developer's guide. Some how my process and Rul are good but still when I right click then "Drill" option is grayed out.

Any ideas ??

Thanks for the help.

-V
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: Drill Thru help

Post by George Regateiro »

I would start by

1) Double check the spelling of the drill process name in the rules.
2) Try a very generic assignment rule to make sure that the drill at least shows up
3) Create a testing drill so you can test the logic of your rules. Use the testing drill to catch the false case of your if statements.

If this does not work post out the drill rules that you have, it could spark someone seeing something that you dont see.
vish
Posts: 10
Joined: Wed Feb 18, 2009 4:54 pm
Version: 9.5
Excel Version: 2003

Re: Drill Thru help

Post by vish »

I am using very generic stuff. Just want to make it work, then building blocks.


Process Name : }Drill_DT_TEST

SQL :

select * from dbo.dmn_vendor_pnt_chd
where vendor_child = '?TEST_Vendor?'


RUL :

[]=S:IF( ISLEAF= 1, 'Drill_DT_TEST','');


Thanks for your help.

-V
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: Drill Thru help

Post by George Regateiro »

it has been a while since I worked with drills but I am pretty sure the Drill_ was added by TM1. Just try using DT_TEST when you reference the drill in the rules.
vish
Posts: 10
Joined: Wed Feb 18, 2009 4:54 pm
Version: 9.5
Excel Version: 2003

Re: Drill Thru help

Post by vish »

u da MAN :8-)


Damn me....that was simple..

-V
Post Reply