COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: platipuss on 09 Sep 2009 10:04:04 AM

Title: Set prompt value from burst query
Post by: platipuss on 09 Sep 2009 10:04:04 AM
Is it possible to have the burst query set a prompt value that limits the report?
Title: Re: Set prompt value from burst query
Post by: Filip.Cuppens on 10 Sep 2009 01:14:15 AM
I'm not sure what you are trying to achieve here. Do you want to create a prompt that limits the Burst Query, and then have the Burst query pass that prompt value on to the initial report query ? If that's the case why not just create the prompt on the initial query ?

Perhaps a little bit more explantion and an example will be helpfull.

Regards
Title: Re: Set prompt value from burst query
Post by: platipuss on 06 Oct 2009 12:21:48 PM
I have a prompt that limits the results on the page. Lets say a product id. So I want to burst the report for every product. I would like that prompt to be satisfied by the burst query. This prompt is actually defined in the bi model/data model, and is part of the row level security of the data. So can a burst query satisfy a required prompt.

Thank you for any help!