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

 

Drill Through Question (Multiple DTs to the same target report?)

Started by WPM-CTMA, 18 Feb 2015 09:40:31 AM

Previous topic - Next topic

WPM-CTMA

Hello,
     I have a somewhat busy dashboard associated with data from a number of different sources, and I would like to create individual drill through's for the many different departments or sources of data in the target report.  The target report features the data that fills the dashboard report split into a number of different pages with simple lists.

     I was hoping that I could make multiple drill throughs, that would result in an output from a specific page from the target report, but I am having trouble figuring out how that would be possible.  The idea is that I don't want to have to split that target report into 16 different target reports as that will lead to much more clutter than 1 report.

     If anyone can help me out or understands what I'm trying to do and knows it is not possible, please let me know.  Any further info you need I can provide as well.

cognos810

Hello WPN-CTMA,
Hoping that I got your requirment correct, this is what you could do.
In 1 target report, split the various lists on separate pages. Control the rendering of the page using a paramter. Example: Page 1 renders if a value of "1" is passed from the source report, 2 if "2" is passed, so on and so forth. Lets call this Parameter as "p_PageRender"
Then on your dashbaord change:
1)Create 16 "hidden" text box prompts associated with parameters, p_PageRender_1, p_PageRender_2......p_PageRender_16.
2)Have default values populated as 1,2,3,4.....16 for each one of the text box prompts.
3)Lastly, from the drill through link pass the correct value. Example: If your drill through link intends to open page 1 on the target report, pass the value of Parameter p_PageRender_1 to p_PageRender on the target report. If you intend to show page 16, pass the value of p_PageRender_16 to p_PageRender on the target report.

A lot of work, but will get you what you want keeping 1 target report.

-Cognos810

WPM-CTMA

Quote from: cognos810 on 18 Feb 2015 01:31:54 PM
Hello WPN-CTMA,
Hoping that I got your requirment correct, this is what you could do.
In 1 target report, split the various lists on separate pages. Control the rendering of the page using a paramter. Example: Page 1 renders if a value of "1" is passed from the source report, 2 if "2" is passed, so on and so forth. Lets call this Parameter as "p_PageRender"
Then on your dashbaord change:
1)Create 16 "hidden" text box prompts associated with parameters, p_PageRender_1, p_PageRender_2......p_PageRender_16.
2)Have default values populated as 1,2,3,4.....16 for each one of the text box prompts.
3)Lastly, from the drill through link pass the correct value. Example: If your drill through link intends to open page 1 on the target report, pass the value of Parameter p_PageRender_1 to p_PageRender on the target report. If you intend to show page 16, pass the value of p_PageRender_16 to p_PageRender on the target report.

A lot of work, but will get you what you want keeping 1 target report.

-Cognos810

Thanks so much, to me this sounds like it would work for what I am trying to do, however I don't understand how to create hidden text box prompts associated with the parameters or create a parameter that would control the rendering of the lists on the different pages.   If you see this and have any time to elaborate of give me examples of the syntax I would use to create those things in cognos, that would be amazing

Thanks