Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: bensah on 13 May 2014 08:03:48 AM

Title: Bursting the report by using a prompt report
Post by: bensah on 13 May 2014 08:03:48 AM
Hi,

I have one report with 3 prompts and it is working fine.

Is it possible to use the prompt report for my bursting ?

Thanks,
Benu
Title: Re: Bursting the report by using a prompt report
Post by: Lynn on 13 May 2014 09:30:31 AM
It is indeed possible to burst reports that contain prompts. I think your question is too vague to offer much more.
Title: Re: Bursting the report by using a prompt report
Post by: bensah on 14 May 2014 07:14:16 AM
Thank you for your reply.

My requirement is as below.

Filter Level:- DIS or MKT etc
Level number:- District number if the above filter is DIS .market number if the above filter is MKT. This field will change everymonth.
Report Level:- 500 or 510 or 530 etc
Category:- Braches,Cluster,total

I have created the report and after providing the above prompt value it is working fine.

My bursting Query have 4 columns corresponding to each prompts.

What I have done:-

In the burst option, i have selected burst query and in the group added Filter Level,Level number,report level and category value from the burst query. Burst recipient is my report Query. In the parameter below my burst query I have mapped column names.

while bursting I am not getting any output.

Please let me know if you need any information. I need to do it urgently.
Appreciate your help.

Thanks,
Benu

Text only | Text with Images