COGNOiSe.com - The IBM Cognos Community

Good day guys,

I am trying to burst a revenue report for 4 major cities in the country.

I am trying to burst and save the report output version for each city.  so that the users in the particular city can see their city revenue when they try to open the report output.

I have created the report and set the           Burst group                                              Burst recipient
                                                          bursting key & label as "city" column      City as data item and directory entries as the type

To make the bursting work do i need to create a user group for each city in the Cognos Administrator>Security>Directory>cognos ? How do i need to setup the user group structure?

Thanks in advance
M

Quote from: M on 20 Nov 2015 07:21:17 AM
Good day guys,

I am trying to burst a revenue report for 4 major cities in the country.

I am trying to burst and save the report output version for each city.  so that the users in the particular city can see their city revenue when they try to open the report output.

I have created the report and set the           Burst group                                              Burst recipient
                                                          bursting key & label as "city" column      City as data item and directory entries as the type

To make the bursting work do i need to create a user group for each city in the Cognos Administrator>Security>Directory>cognos ? How do i need to setup the user group structure?

Thanks in advance
M

Hi,

The Burst Recipient part seems to be the issue here. Assuming you are bursting saved outputs back to the content store (so that users can view them by clicking on them), you will need to use CAMIDs as the burst recipient. This means having a CAMID that corresponds to each city in your data. CAMIDs belong to users, groups and roles in the Cognos namespace and in the authentication namespace. If you already have groups that correspond to the cities, you can find the CAMIDs of these groups and (if feasible) derive them using a query calculation in your report [eg CAMID(":New York")] or else add the city values and their corresponding CAMIDs to a burst table in your database and add this to your model and package.

If you don't already have appropriate groups, you're going to need to create these, and add your users into these groups, then use the group CAMIDs as above.

Cheers!

MF.

Thanks MF.

I will try creating roles in cognos namespacce .