Author Topic: Bursting report to multiple levels  (Read 224 times)

Offline AnuElza

  • Full Member
  • ***
  • Join Date: Feb 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
Bursting report to multiple levels
« on: 16 Feb 2017 04:37:22 pm »
Hi,

I have a report with the following structure:
District Store             Sales
D1         S1                  100
D1         S2                  150
D1         S3                  200
D2         S4                  250
D2         S5                  300

The requirement is to burst the report to District managers and Store managers where District manager should be able to see all stores assigned to them where as Store Manager should see just his store. I am able to burst to District managers, but could anyone help me to understand how do I burst reports to Store managers as well please? Or is this has to be two separate reports?  My report query has above data along with one column for District manger emp no and another col for store manager emp no. And I have a another query for email addresses. Right now, I am creating a master detail with Report query and email query on District manager emp no, which works fine for DMs. How do I burst for Store managers as well.

Offline CognosPaul

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Jan 2009
  • Posts: 1,476
  • Forum Citizenship: +230/-1
    • Paul's Cognos Blog
Re: Bursting report to multiple levels
« Reply #1 on: 16 Feb 2017 06:00:36 pm »
Is your burst table set up with both levels? and more importantly, are both sets of keys absolutely unique?

keyemail
s1email
s2email
s3email
s4email
s5email
d1email
d2email

Master Detail links can be set to feed parameters. What you can do is, instead of doing a link from the burst key to the district key, create a parameter in the target query [District Key]=?burstKey? or [Store Key]=?burstKey?

In the master detail, set the link to the parameter and when the report runs each row in the burst table will run either a district or a store.

Offline AnuElza

  • Full Member
  • ***
  • Join Date: Feb 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: Bursting report to multiple levels
« Reply #2 on: 17 Feb 2017 10:12:05 am »
Hi CognosPaul,
Thanks for looking into this. I tried to implement but no luck. I didn't quite understand how to set that master detail. I tried but got error: RSV-VAL-0016 The burst query Report cannot be a nested query.

I created a sample report out of 'GO Data Warehouse' package. Could you please take a look?
Appreciate your help on this.
Good day!

-Anu

Offline CognosPaul

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Jan 2009
  • Posts: 1,476
  • Forum Citizenship: +230/-1
    • Paul's Cognos Blog
Re: Bursting report to multiple levels
« Reply #3 on: 17 Feb 2017 10:27:35 am »
Try setting the Burst Group query to your burst query.

The system I'm sitting at today doesn't have the samples installed, but take a look at the attached. I think it should work.

Offline AnuElza

  • Full Member
  • ***
  • Join Date: Feb 2017
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: Bursting report to multiple levels
« Reply #4 on: 17 Feb 2017 11:39:48 am »
Thanks!. It worked.
Only thing I noticed is, the report got bursted for all the employees in the query (with no data). I created a local join to limit to only DM or SM employee IDs and used that query as BurstGroup query.

Thanks again for the quick response. You made my day !!


 



           
Twittear