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

Question when doing master detail

Started by asmfloyd, 13 Nov 2018 06:49:51 PM

Previous topic - Next topic

asmfloyd

Hi,
  I need to burst the funds and nav of each banks by year. So I kept bankid and year as a master query in page set. Then trying to burst by bankid with year as a prompt.


In the page; I created a First list which will display Nav value of funds of category A ( A as a filter) of Bankid. This list is linked by master detail to page.

2nd list will display nav values of fund of category B for the same bankid. This is linked by master detail to page.

3rd list will display nav values of fund of category C for the same bankid. This is linked by master detail to page.

Now my 3rd list —category C does not have values for all banks.(bankids)

So when I burst by adding 3rd list; it is bursting only the bankids which has category C's.

What can I do so that it bursts all banks? And when category c is not there; let it give no values.

Thanks,


CognosPaul

What query are you using to define the burst? The burst query can be completely separate from the other queries on the page, make sure that have the entire list of banks you want.