Defining Burst Recipients
Define the recipients who will receive data when the
report is run. You can distribute burst reports to individual users,
groups, roles, distribution lists, and contacts. To define the recipients,
you
Create a Calculated Field
You can use a calculated field to dynamically create
burst report recipients.
Steps
Pause the pointer over the query explorer button 
and
click the query that will produce the data to distribute.
In the Insertable Objects pane, on
the Toolbox tab 
, drag Data
Item to the Data Items pane.
In the Expression Definition box,
type the expression that will generate the list of recipients and
click OK.
For example, typing the following expression builds the list
of the employees of The Great Outdoors Company. The expression concatenates
the first letter of each employee's first name with their last name.
lower(substring([Employee summary (query)].[Employee
by organization].[First name],1,1) + [Employee summary (query)].[Employee
by organization].[Last name])
To give the data item a more meaningful name, in the Properties pane,
set the Name property to a different name and
press the Enter key.
Creating a
Burst Table
You can create a burst table to specify the list of
recipients.
You can also use an existing table as the burst table.
Creating a burst table involves
Creating the Burst Table in the Source
Database
You can create a burst table in the source database
for the list of recipients. The steps you must follow depend on
the database system you are using. The burst table must contain
the following columns:
You can also include other columns that provide additional information.
For example, if you plan to distribute reports by email, you can
add a column for the email address of each recipient.
After you create the table, add the recipients who will receive
the report. You can create a mixed recipients list that includes
individual users, groups, roles, contacts, distribution lists, or
email addresses. For example, a burst table may contain the following
recipients.
|
CAMID(":Canada") | Group |
CAMID(":")/contact[@name='Silvano Allessori'] | Contact |
CAMID(":")/distributionList[@name='European Partners'] | Distribution list |
CAMID("LDAP_Local_ID:u:uid=gbelding,ou=people") | Authentication provider user or group, where
LDAP_Local_ID is the name of an LDAP namespace ID, and people is
the name of an organizational unit |
c8@ibmcognos99.com | Email address |
CAMID stands for Cognos Access Manager ID, and it represents
an internal search path to the recipients. Specify search paths
when you want to save burst reports in a directory. You can obtain
the search path in IBM Cognos Connection by opening the Set
properties page for each recipient and clicking View
the search path. Ensure that you use the proper syntax when
adding recipients to the burst table.
In the case of NTLM namespaces, user IDs in the search path use
alphanumeric or numeric characters that make them difficult to read.
You can use the following alternate search path syntax:
directory/namespace[@name="Local NT"]//account[@userName="gbelding"]
where Local NT is the name of a namespace and gbelding is the
name of a user. The double slash before the account element indicates
that you are searching all accounts under the specified namespace.
Note: If you have a mixed recipients list, do not mix
email address recipients and alternate path recipients. Because
the alternate path syntax contains the @ symbol, it will be mistaken
for an email address.
For more information about users, groups, roles, contacts, and
distribution lists, see the Administration and
Security Guide.
Importing the Table
into a Package
After you create the burst table in the source database,
you must add it to the package that you will use to create the report.
In Framework Manager, do the following:
 | Open the package. |
| | Import the table. |
| | Define the relationship between the burst table and the
table containing the data item on which to burst. For example, you are bursting on country code. You define a relationship
between country code in the burst table and country code in the
Country table. |
| | Save and publish the package. |
For more information about importing tables and creating
relationships, see the Framework Manager User
Guide.
