COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Olga1993 on 26 Oct 2016 05:47:07 AM

Title: Cognos Active report with visualization bursting
Post by: Olga1993 on 26 Oct 2016 05:47:07 AM
Do you know whether it is possible to create an active report with visualizations and then burst it? Should I make a master-detail link between visualization and bursting query? Why for some visualizations I have master-detail option  and don't have for others? Cognos 10.2.2 version
Title: Re: Cognos Active report with visualization bursting
Post by: MFGF on 01 Nov 2016 03:33:22 AM
Quote from: Olga1993 on 26 Oct 2016 05:47:07 AM
Do you know whether it is possible to create an active report with visualizations and then burst it? Should I make a master-detail link between visualization and bursting query? Why for some visualizations I have master-detail option  and don't have for others? Cognos 10.2.2 version

Hi,

Yes - entirely possible. In terms of bursting, you use the same approach as with any normal report. If your bursting query is separate from your visualization query, then yes - master/detail is the way to go.

Cheers!

MF.
Title: Re: Cognos Active report with visualization bursting
Post by: Olga1993 on 02 Nov 2016 05:41:24 AM
Yes, I've already tried it. When I try to burst an active report with only one visualization without any filters it takes 5 minutes to burst a simple report for two users. But when I try to burst more complicated report (6MB), it stays in executing status for a long time and then gets failed. The report validation is successful. All the master-detail links are done.