Report Bursting Query

[Raghuvir]

Hi all,

i have prepared one report and i want to burst the report so it goes to the specific recipients. i have manually created an data item for email id.

email 1 consists of 'abc@xyz.com'
email 2 consists of 'pqr@xyz.com'

i have prepared a data item send email and written the below condition.

IF ([SCHEDULE]='BIW') THEN
    ([Email 1])
ELSE
    ([Email 2])

will this be applicable for bursting ?

Regards

[MFGF]

Sounds like something that would be suitable for use as the burst key, yes :)

MF.

[Raghuvir]

Hi MFGF,

i applied the above logic and scheduled the report at a particular time. the report does run successfully but the issue is, when i view the run history details for the report the staus is succeded but there is nothing mentioned about the recipients to whom the mail is sent. neither i am receiving the mail in my inbox.

not able to figure out where i am going wrong.

[MFGF]

Hi MFGF,

i applied the above logic and scheduled the report at a particular time. the report does run successfully but the issue is, when i view the run history details for the report the staus is succeded but there is nothing mentioned about the recipients to whom the mail is sent. neither i am receiving the mail in my inbox.

not able to figure out where i am going wrong.

Did you check the burst option when running/scheduling the report? Have you specified that the report should run and email?

MF.

[Raghuvir]

hi MFGF,

its working now, what i did is, instead of making the data items email1 and email2, i directly mentioned the email id's in the if then condition.


IF ([SCHEDULE]='BIW') THEN
    ('abc@xyz.com')
ELSE
    (pqr@xyz.com)

now i am looking to add emails in cc using bursting, will that be possible ?

Regards

[MFGF]

now i am looking to add emails in cc using bursting, will that be possible ?

Hi,

When you burst, each output goes to a separate burst key. If you are using an email address as the burst key (as you are doing at present) then this is a limiting factor.

My suggestion is that you go into the Admin Console > Configuration > Distribution Lists & Contacts and firstly set up each email address as a contact (in your Cognos namespace). Then set up some distribution lists that group the relevant email addresses together.

Once you have these, you can go into the properties of each Distribution List and make a note of its CAMID - usually this will be CAMID(":name of Distribution list")

Use these CAMIDs as your burst keys in your report.

Cheers!

MF.

[Raghuvir]

Hi MFGF,

Could you please guide me with an example on how to use the CAMID's as the burst keys in a report.

Regards

[MFGF]

Hi MFGF,

Could you please guide me with an example on how to use the CAMID's as the burst keys in a report.

Regards

Not sure I follow. If you can use specific email addresses, what is the difference in using specific CAMIDs?

MF.