I'm using Cognos BI 10.2 and I'm facing a problem.
I need every cost center PIC allow to get their own cost center data only and the management level may have all or several cost center data.
I'm going to burst a cost summary report to every cost center PIC & management, but there are some PIC in charge of more than 1 cost center and 1 cost center may have more than 1 PIC.
I need to send the report to the PIC in 1 copy combining all cost center that the person in charge of.
How can I achieve this?
Currently when I'm bursting the report, if the PIC is in charge of 3 cost centers, Cognos will send them 3 copy of the report for each cost center.
Accurate answer: Ditch bursting, use prompts and jobs. More flexibility, more control, higher failure redundancy, all at the cost of more maintenance (which may be offset with 3rd party tools like Motio PI)
Not-so-accurate answer: Do not burst on CC, but burst on PIC and include a page set or section per CC. Depending on how "1 cost center may have more than 1 PIC" is setup in your database, if it is at all, this might fail right here, but ultimatey, it will probably fail on sending to mgmt.
Or implement security so they only see "their" data and let them run the reports in Cognos. Or even create their own.
Yes there may be licensing implications, or may not work for your organization, or is way out of scope, but it is just a suggestion.
Can you create a simplified report against Cognos Samples packages and reproduce the same issue?
OK. I try to explain what I want with examples as per below.
The Overall simplify report Layout is something like this
Cost Center Group | Cost center | Cost Amount
CCGroup1 | CC01 | $100
CCGroup1 | CC02 | $150
CCGroup2 | CC03 | $220
CCGroup3 | CC04 | $120
CCGroup3 | CC05 | $420
CCGroup3 | CC06 | $350
PIC-A
In charge of CC01 so below is the report he should see.
Cost Center Group | Cost center | Cost Amount
CCGroup1 | CC01 | $100
PIC-B
In charge of CC02 & CC03 so below is the report he should see.
Cost Center Group | Cost center | Cost Amount
CCGroup1 | CC02 | $150
CCGroup2 | CC03 | $220
PIC-C
In charge of CCGroup3 so below is the report he should see.
Cost Center Group | Cost center | Cost Amount
CCGroup3 | CC04 | $120
CCGroup3 | CC05 | $420
CCGroup3 | CC06 | $350
Management
Can See all the cost below is this report he should see.
Cost Center Group | Cost center | Cost Amount
CCGroup1 | CC01 | $100
CCGroup1 | CC02 | $150
CCGroup2 | CC03 | $220
CCGroup3 | CC04 | $120
CCGroup3 | CC05 | $420
CCGroup3 | CC06 | $350
So the problem I faced now is I do not sure how to set the burst option to achieve this scenario.
I know this can be done by using a parameter and the jobs, but this involves high maintenance, as I need to maintain and set the parameter for each PIC.
Hope you can provide better solutions... ;)
You would have to map each PIC to Cost Centers.
Then just burst report by PIC to get outputs for every PIC.
Or run report without bursting then you get all data for management
My attached report example is using package [GO Data Warehouse (query)] against Oracle.