COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: juffin on 08 Jun 2014 01:51:04 PM

Title: Report bursting - CAMID etc.
Post by: juffin on 08 Jun 2014 01:51:04 PM
Hi,
I am new to bursting reports..In a book I have seen the author creating a calculated data item named 'Burst Recipients' with expression CAMID("::Anonymous"). What is Anonymous here ? and what all other values it can accept.

Suppose my requirement is to burst a big report based on Product type (burst group) and send each prod type to separate recipient
by each recipient's mail or each recipient's LAN, where can we set the email address or Lan location for each recipient ?
and how is prod type 1  linked to recipient 1 ? (is it through master detail relationship?) 
prod type 1 to recipient 1
prod type 2 to recipient 2
prod type 3 to recipient 3

Please,could you help me understand this concept..

Thanks in advance for your time..
Regards
Jf
Title: Re: Report bursting - CAMID etc.
Post by: MFGF on 10 Jun 2014 05:18:13 AM
Quote from: juffin on 08 Jun 2014 01:51:04 PM
Hi,
I am new to bursting reports..In a book I have seen the author creating a calculated data item named 'Burst Recipients' with expression CAMID("::Anonymous"). What is Anonymous here ? and what all other values it can accept.

Suppose my requirement is to burst a big report based on Product type (burst group) and send each prod type to separate recipient
by each recipient's mail or each recipient's LAN, where can we set the email address or Lan location for each recipient ?
and how is prod type 1  linked to recipient 1 ? (is it through master detail relationship?) 
prod type 1 to recipient 1
prod type 2 to recipient 2
prod type 3 to recipient 3

Please,could you help me understand this concept..

Thanks in advance for your time..
Regards
Jf

When bursting a report, you need two things - a grouped item that you can use to break up the output into different sections, and a burst key which is used as a target for each section. There needs to be a relationship between these defined somewhere - quite often this is done using a specific burst table in a database somewhere. Typically it will have on each row a group item value and the corresponding burst key.

Burst keys can either be email addresses, or they can be internal IDs of a user, group or role defined in the Content Store (CAMIDs). If you go into the admin console and onto the security tab and locate a user, group or role within a namespace, you can see its CAMID by going into its properties and selecting the "View the Search Path, ID and URL" link. There is a predefined user in the Cognos namespace called "Anonymous" - this is the user people are registered under if anonymous access is permitted into your Cognos instance. If you look at it's Search Path, it is shown as CAMID("::Anonymous") - each different group and role will have a different CAMID. The same applies to groups and users in your authentication namespace.

In your situation, I'd suggest you create a burst table comprising the product type values and the corresponding CAMIDs of the users/groups/roles required. Alternatively the email addresses of the users could be used instead of CAMIDs if you are planning to run and email the sections of the output. This table will need to be added into your FM model so you have access to the data within it from your report.

Cheers!

MF.
Title: Re: Report bursting - CAMID etc.
Post by: juffin on 10 Jun 2014 11:59:44 AM
thank you very much MFGF..nice and clear explanation!