IBM SPSS Statistics integration with Cognos BI

In today’s data-driven landscape, the ability to analyze information to drive decision-making and solve problems is fundamental for success. IBM SPSS Statistics is commonly used tool by statisticians/analytics professionals for ad hoc analysis and hypothesis testing. Rich in Extensive data preparation, analysis and visualization features, IBM SPSS Statistics provides insight into a sample of data and tools for prediction and forecasting. Generally speaking, it helps in:

• Understanding how to leverage the data collected and being able to fill in the gaps
• Understanding the underlying relationships in data from the data warehouse or various repositories and how they impact decisions
• Recognizing what influences business outcomes and to what degree by recognizing what variables drive outcomes
• Testing assumptions before applying the theory to real world events. Also when to adjust or abandon these assumptions

IBM SPSS Statistics offers the full scope of statistical and analytical capabilities that organizations require. It’s an easy-to-use, comprehensive software solution that:

1. Addresses the entire analytical process from planning and data preparation to analysis, reporting and deployment
2. Allows application of statistical information to data to improve understanding and decision quality throughout the enterprise.
3. Provides advanced analysis using statistical algorithms (for regression, correlation, segmentation etc.), and display of those results.
4. Enterprise scale and extensibility as part of the SPSS suite of products.
5. Works with all common data types, external programming languages, operating systems and file types
6. Use with Cognos BI for statistical information in reports, dashboards and scorecards.

Here in this blog I would like to focus on last bullet which says how IBM SPSS Statistics can work with IBM Cognos BI. If you are new to Cognos BI please refer my previous blog “IBM Business Intelligence Software & Its Core Capabilities”. I’ve installed IBM SPSS Statistics 22 and IBM Cognos BI 10.2.1 on 64-bit Windows 7 Professional environment.

Reading Cognos data

Lets read Cognos BI data by choosing menu “File > Read Cognos Data”

Next, Specify the URL for the Cognos server (external dispatcher URI). Description of each field is given as under.

Cognos server URL. The URL of the IBM Cognos Business Intelligence server. This is the value of the "external dispatcher URI" environment property of IBM Cognos Configuration on the server. Contact your system administrator for more information

Mode. Select Set Credentials if you need to log in with a specific namespace, username and password (for example, as an administrator). Select Use Anonymous connection to log in with no user credentials, in which case you do not fill in the other fields.

Namespace ID. The security authentication provider used to log on to the server. The authentication provider is used to define and maintain users, groups, and roles, and to control the authentication process.

User name. Enter the user name with which to log on to the server.

Password. Enter the password associated with the specified user name.

Save as Default. Saves these settings as your default, to avoid having to re-enter them each time.

 

Now, specify the location of the data package or report as shown below. 

  

And select the data fields or report that you want to read.

Optionally, you can:

• Select filters for data packages.
• Import aggregated data instead of raw data.
• Specify parameter values.

 

Once you Run and finish it, you can see the data in Statistics Data Editor. Now you are ready to work & analyze your data using SPSS statistical features.

Export Cognos Active Report

Once you are done with your analysis and ready with output, you may want to export it. Export Output saves Viewer output in HTML, text, Word/RTF, Excel, PowerPoint (requires PowerPoint 97 or later), and PDF formats. Charts can also be exported in a number of different graphics formats.

Note: Export to PowerPoint is available only on Windows operating systems and is not available in the Student Version.

To Export Output

1. Make the Viewer the active window (click anywhere in the window).
2. From the menus choose: File > Export...
3. Enter a filename (or prefix for charts) and select “Web Report (*.htm or *.mht)” as export type as shown below.

4. Now click on “Change Options” button

This Cognos Active report is now ready and  users can easily export their output with others to view & interact on smart devices (iPhone, iPad, iPod, Android and Windows 8)

Cognos Active reports enables quick decision-making anytime and anywhere. Also users can take advantage of IBM Cognos Mobile app (available on iPad) by exporting their output as Cognos Active Report (.mht format).

IBM Cognos Active Report provides an interactive analytics experience in a self-contained Cognos Business Intelligence application for browsing and exploring data offline. Report authors can build reports targeted to users needs, keeping the user experience simple and engaging. Mobile workers can take their data with them to discover opportunities and analyze trends even when they are nowhere near a network.

Want to know more about Cognos Active Report? Please refer www.ibm.com/software/analytics/cognos/business-intelligence/active-report.html

Now, whatever steps we just followed above generates scripts which can be used to automate entire job. The scripting facility allows you to automate tasks, including:

• Opening and saving data files.
• Exporting charts as graphic files in a variety of formats.
• Customizing output in the Viewer.

A number of scripts are included with the software, in the Samples subdirectory of the directory where IBM SPSS Statistics is installed. You can use these scripts as they are or you can customize them to your needs. For more information on scripting and automation please refer http://pic.dhe.ibm.com/infocenter/spssstat/v22r0m0/topic/com.ibm.spss.statistics.help/spss/base/scripts_overview.htm

 

References:

IBM SPSS Statistics 22 product documentation is available at:

http://pic.dhe.ibm.com/infocenter/spssstat/v22r0m0/

Join SPSS Community

http://www.ibm.com/developerworks/spssdevcentral

Cognos Active Report

www.ibm.com/software/analytics/cognos/business-intelligence/active-report.html