Macro For Publishing Cubes - HELP!!!

[ganabhat]

Hi All,
I want to know how to enable drill through to the IWR from Cube while publishing in my Macro.

eg.
To enable drillthrouh to COGNOS Query:

SET / .PWQ.DrillThru.CQ_enable=1
SET / .PWQ.DrillThru.CQ_url=http://hts-pc3a182/cognos/cgi-bin/cqcgi.exe


I am looking for command to set drillthrogh for IWR

Regards
Ganapati

 

[RVLF]

Look after the PPADMTOOL utility

You can do it with it !!!

 

[ganabhat]

Hi,
Thanks a lot. I am not getting where to look for PPADMTOOL utility. Another problem is that when i connect to my local machine from PPADMTOOL i get the following error

C:\>D:\AdvancedBI\Cognos\cer1\bin\ppadmtool.exe
> Connect hts-pc3a182
*E* Connect to PowerPlay Server failed.
*E* The request failed because the value is out of range.
>

How can i overcome this?
Regards
Gana

 

[RVLF]

I do :

CONNECT MyServerNAme USER Administrator PASSWORD MyPwd

 

[ganabhat]

Hi
Its working. Thanks a lot!
can u tell me
I want to know how to enable drill through to the IWR from Cube while publishing in my Macro.


Regards
Gana

 

[christenhusz]

IWR is NOT OLE2 compatible, impromptu, powerplay, access manager and Upfront are OLE2 compatible. So there is no macro command to do this (unfortunately...)

Greetz

Martijn