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!
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