If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill Through from PowerCube to Detail level report

Started by cognos8_1, 22 Jun 2007 10:10:58 PM

Previous topic - Next topic

cognos8_1

how do i drill through from a transformer Powercube to detailed level reports in c8?
what settings do i have to make at the cube level ? Or do i have to make any changes in the powerplay configurations ?
I think it is possible by changing the cube propertise. how is the secuirty handled here ? any help in this regard would b highly appreciated.
thanks in advance!

trevorp

Hi

I just managed to get it working and here is what I did;

1) enable the drill thru option on the transformer model
2) publish the cube
3) create a drill thru target report with prompts (prompt names must be the same as in the Cube (if the dimension is Name 1 then the prompt parameter in the report must be ?Name 1?
4) create a drill thru definition in the Cube folder on C8 (under tools)
5) open the cube in analysis studio, select the measure, right click, then goto and you will see your drill thru targets (hopefully)

Hope this helps
Trevor