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
Drill Thru help
- 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
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.
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.
Re: Drill Thru help
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
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
- 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
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.
Re: Drill Thru help
u da MAN :8-)
Damn me....that was simple..
-V
Damn me....that was simple..
-V