...

Sametime 8.0.1 Integration with IBM Cognos 8.4 Tip or Technique

by user

on
Category: Documents
2

views

Report

Comments

Transcript

Sametime 8.0.1 Integration with IBM Cognos 8.4 Tip or Technique
Tip or Technique
Sametime 8.0.1 Integration with
IBM Cognos 8.4
Product(s): IBM Cognos 8.4 BI Report Studio
Area of Interest: Reporting
Sametime 8.0.1 Integration with IBM Cognos 8.4
2
Copyright
Copyright © 2008 Cognos ULC (formerly Cognos Incorporated). Cognos ULC
is an IBM Company. While every attempt has been made to ensure that the
information in this document is accurate and complete, some typographical
errors or technical inaccuracies may exist. Cognos does not accept
responsibility for any kind of loss resulting from the use of information
contained in this document. This document shows the publication date. The
information contained in this document is subject to change without notice.
Any improvements or changes to the information contained in this document
will be documented in subsequent editions. This document contains
proprietary information of Cognos. All rights are reserved. No part of this
document may be copied, photocopied, reproduced, stored in a retrieval
system, transmitted in any form or by any means, or translated into another
language without the prior written consent of Cognos. Cognos and the
Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated)
in the United States and/or other countries. IBM and the IBM logo are
trademarks of International Business Machines Corporation in the United
States, or other countries, or both. All other names are trademarks or
registered trademarks of their respective companies. Information about
Cognos products can be found at www.cognos.com
This document is maintained by the Best Practices, Product and Technology
team. You can send comments, suggestions, and additions to
[email protected]
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
3
Contents
1
INTRODUCTION ............................................................................................ 4
1.1
1.2
1.3
1.4
1.5
1.6
PURPOSE .............................................................................................................. 4
APPLICABILITY ....................................................................................................... 4
UNDOCUMENTED AND UNSUPPORTED CAPABILITIES USED .................................................. 4
ASSUMPTIONS ........................................................................................................ 4
OVERVIEW ............................................................................................................ 4
REFERENCE ........................................................................................................... 4
2
CREATING THE REPORT................................................................................ 5
2.1
2.2
2.3
2.3.1
2.3.2
2.3.3
CREATING THE LIST REPORT ...................................................................................... 5
CREATING THE CHART .............................................................................................. 7
OVERVIEW OF THE REQUIRED JAVASCRIPT ..................................................................... 8
LOADING THE SAMETIME 8.0.1 JAVASCRIPT REFERENCE .................................................... 9
DYNAMIC EMAIL COLUMN ........................................................................................ 10
STATIC EMAIL REFERENCE ....................................................................................... 11
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
4
1 Introduction
1.1
Purpose
This document describes a technique to integrate IBM Sametime with Report
Studio.
1.2
Applicability
The technique in this document was validated using:
• IBM Cognos 8.4 18.27 using the GO Sales (query) sample package
• IBM Sametime Client 8.0.1
1.3
Undocumented and Unsupported Capabilities Used
This technique requires the use of undocumented and unsupported
capabilities in IBM Cognos 8. There may be a risk associated with this
technique in that support for these capabilities may change or be dropped
entirely in some future release.
1.4
Assumptions
This document makes the assumption that IBM Cognos 8.4 and the IBM
Sametime client are installed on the same server. This document also
assumes full availability of the IBM Lotus Notes email addresses through
connectivity to the network.
1.5
Overview
The technique uses an HTML item within an IBM Cognos 8.4 Report Studio
report to generate contact lists based on email addresses provided by a
Query Item. This contact list will be fully interactive, which when clicked by
the user, will open a default Sametime chat window.
1.6
Reference
References to Sametime Client 8.0.1 can be found at
http://publib.boulder.ibm.com/infocenter/sametime/v8r0/index.jsp?topic=/co
m.ibm.help.sametime.801.doc/Entry/st_inst_preparingthesametimeclient_t.ht
ml
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
5
2 Creating the Report
The following section will provide the steps required to build a list report
using the GO Sales (query) package within the IBM Cognos BI Report Studio.
The list report will display the Product Line, Sales Region and Revenue. The
report will also contain the email address of the account manager which will
be used to provide the interactive Sametime integration. The final report
should represent the following image.
2.1
Creating the List Report
The following section will provide the steps required to create the list
component of the report.
1. Within the File\New dialog box, select the List icon.
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
6
2. Drag and drop the desired query items from the left hand metadata
tree into the list report. For this example the Query Items will be:
• [Sales (query)].[Product].[Product line]
• [Sales (query)].[Retailer site].[Sales region]
• [Sales (query)].[Sales].[Revenue]
• [Sales (query)].[Sales Staff].[Email]
3. Select the Product line column and click Group by
step for the Sales region column.
. Repeat this
4. Click on the filter icon within the toolbar and apply the following
filters.
5. Insert an HTML item as the last column on this list as illustrated
below. The HTML item can be found as an Insertable Object within
the toolbar tab.
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
2.2
7
Creating the Chart
The following section will provide the steps required to create the chart
component of the report. Although the chart is not a requirement for the
Sametime integration to function properly, it has been added to provide
additional context to the report.
1. Drag a Combination chart on the right of the list report from the
Insertable Objects panel.
2. Drag and drop the desired query items from the left hand metadata
tree into the list report. For this example the Query Items will be:
• [Sales (query)].[Sales].[Revenue] as the Default measure field
• [Sales (query)].[Product].[Product line] as the Categories on xaxis.
• [Sales (query)].[Time dimension].[Current year] and [Sales
(query)].[Retailer site].[Sales region] as the Series.
When completed, the report should now represent the following
screen capture.
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
2.3
8
Overview of the Required JavaScript
In total the report utilizes three HTML to achieve various degrees of
Sametime integration.
•
•
•
The HTML item outlined by the red box will be used to Sametime API
and Javascript include file.
The HTML item outlined in green will be used to dynamically build the
email address used to identify the Sametime contacts. The email
address will be based on available data within the query database.
The HTML item outlined in blue will be used to provide a static
method to generate a Sametime contact using a static email address.
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
9
2.3.1 Loading the Sametime 8.0.1 JavaScript Reference
This section will provide the step by step instructions on how to add the
Sametime JavaScript reference using an HTML item.
1. Drag and drop an HTML item onto the top left corner of this report.
2. Double-click on this HTML item and enter the following code:
<!-- Step #1: Import the ST Connect Web API Stylesheet -->
<link rel="stylesheet"
href="http://localhost:59449/stwebapi/main.css" type="text/css"
/>
<!-- Step #2: Import the ST Connect Web API getStatus
JavaScript include file -->
<script type="text/javascript"
src="http://localhost:59449/stwebapi/getStatus.js"></script>
3. Click the OK button to commit the changes to the HTML item.
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
10
2.3.2 Dynamic Email Column
This section will provide the step by step instructions on how to dynamically
build the Sametime contact using email address data within a query
database.
1. Double-click on this HTML item and enter the following code:
'<a class="awareness" userId="' + [Query1].[Email] +
'">Resolving contact, please wait....</a>'
2. Click the OK button to commit the changes to the HTML item.
IBM Cognos Proprietary Information
Sametime 8.0.1 Integration with IBM Cognos 8.4
11
2.3.3 Static Email Reference
The HTML item outlined in blue will display another technique that can be
used to provide a chat pop up window to a static Sametime contact. This
method is useful when email data is not available within the query database.
1. Drag and drop an HTML item onto the top left corner of this report.
2. Double-click on this HTML item and enter the following code:
<br><br>
<table>
<tr><td>Manager:</td><td><a class="awareness"
userId="[email protected]">Resolving contact,
please wait....</a></td></tr>
</table>
3. Click the OK button to commit the changes to the HTML item.
IBM Cognos Proprietary Information
Fly UP