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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Bursting Master-Detail Crosstabs with Singletons?

Started by cognosonthefly, 15 Feb 2018 09:34:12 AM

Previous topic - Next topic

cognosonthefly

Hey everyone!

Currently I face a difficult problem and I would like to hear what you guys think about it:
I have a report which has to be bursted to around 1000 sales people. So I created a burst query which defines my recipients and so on. On one of my report pages I have several crosstabs, each of them references to another query. It is quite easy to filter them using master-detail relationships obviously. But in some crosstabs there are singletons defined inside the crosstab which reference on other queries. In the non-bursted version of the report the filtering is performed using parameters which were configured by prompt page. But I cannot define the parameters when bursting.
Because there are many Singletons in the different crosstabs, I choosed to create a join which sums up the queries of crosstab and singleton. Now I have a lack of performance - because it seems, that the master-detail relationship only applies local - which is quite bad.
Because it is not possible to integrate lists into crosstab I am searching for alternatives.

Thank you very much for your ideas!