[Solved] CRN to PowerPlay Drill Through

[davidsoc]

Hello,

I would like to set up a report in ReportNet that gives the user the opportunity to drill through into a PowerPlay cube. Is this possible in CRN 1.1 and PPES 7.3?

If so how can you achieve this? Do you require all PPES cubes to be published to Cognos Connection or can you link to Upfront? (i suspect Upfront is a no-go).

Thanks in advance

Chris

[sir_jeroen]

You can add a cube to reportnet and I think (not sure) that you can drill through to a report based on that... But look in the configuration guide how to set this up...

[davidsoc]

The documentation seems to all describe PPES -> CRN drill throughs which i have seen working on a Transformer course...
but not the other way around.

As we are still in development I am not in a position to test publishing cubes to Connection etc. so this was just a "test balloon".

If anyone has seen CRN -> PPES drill through working could you let me know?

Thanks again

[wink]

Hi,

It is possible to specify the dimensions and measures shown in a cube using the URL to the cube. You can add even filters to the view this way. The URL can be build up in Reportstudio. Create a hyperlink using the calculated item for the URL and voila.... it almost looks like drilling through to a cube..... This way it also doesn't matter whether you're using the Connection or Upfront portal.

You can find additional info in the 'EnterPrise Server Guide' PDF : in the english version on page 60 'Specify a URL.....'.....

Example: if you have the Great Outdoors Cube publish give this a try:

http://<servername>/<virtual directory>/cgi-bin/ppdscgi.exe?TARGET=Great%20Outdoors&FILTER=Years%0919970101-19971231%09Products%09Tents&FORMAT=HTML

And don't forget to change to <servername> and <virtual directory> variables with your values....

Regards, vincent