Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 4. Data modeling: End to end 141

At the time of writing, IBM Cognos Framework Manager is available as a

Microsoft Windows application only. The server components of IBM Cognos BI

are available for a range of hardware and operating system platforms.

4.5.2 Create a Cognos model from cubing services

In this section, we demonstrate how to create and publish a Cognos model from

an existing cubing service. This particular example follows on from 4.4.3, “Deploy

a cube model to InfoSphere Warehouse as a cube service” on page 134, in that it

uses our currently deployed cubing service as the starting foundation.

Follow these steps to create and publish a Cognos model from an existing

cubing service:

1. Make a note of the port number for the XMLA service of the published cube

service. Open the InfoSphere Administration Console with a web browser and

navigate to the Manage Cube Servers section. With the chosen cube server

IBM Cognos BI note: InfoSphere Advanced Enterprise Edition includes a

number of licenses for IBM Cognos BI. These include one administration and

a number of consumer entitlements. These copies are restricted to web

support only and cover the following elements of IBM Cognos BI:

򐂰 Query Studio

򐂰 Reporting Studio

򐂰 Analysis Studio

򐂰 Dashboards

򐂰 Event Management

򐂰 Framework Manager

The installation of IBM Cognos BI is separate from that for InfoSphere

Warehouse, but can be installed on the same hardware server.

142 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

highlighted, select XMLA to view details abut the XMLA services, as shown in

Figure 4-36. Make a note of the network port assigned to the XMLA service.

Figure 4-36 Setting for XMLA Port of a cube server

2. Check that the IBM Cognos BI server is running, because this is required to

publish the model.

The start process for the Cognos BI server is particular to each operating

system platform. Check the Cognos BI manual for information about starting

the server.

For Microsoft Windows, as an example, the process is to select All

Programs  IBM Cognos 10  IBM Cognos Configuration, then select

the play button to start the server.

For Linux, to start the Cognos BI server, from the Cognos installed directory,

run the following script:

./cogconfig.sh -s

3. On a Microsoft Windows Client, start the Cognos Framework Manager:

All Programs  IBM Cognos 10  Framework Manager

XMLA port

number

Button to

display XMLA

settings

Chapter 4. Data modeling: End to end 143

4. Create a new project. Under Projects (Figure 4-37), select the link to create a

new project and give the project a name. We use Redbooks Example. Then

select English as the language.

Figure 4-37 Create a new project within IBM Cognos Framework Manager

5. Within the panel that opens next, select the Data Sources option and click

Next. Then select New to create a new data source.

6. Give the Data Source a name, for example, ISW_Repository, then click

Next.

For the data source type, select IBM InfoSphere Warehouse cubing

service (XMLA). Keep the default isolation level, then click Next. The next

set of questions are about the URL of the cubing server XMLA provider. This

URL is composed of hostname:port/Service_name, with the port number

being the value that is noted in step 1. The service name is “IBMXmlAnalysis”

so that the complete URL in our example might appear as follows:

isw10g1:9214/IBMXmlAnalysis

A user name and password might be required if security has been enabled

within the cube model.

Use Test the connection to test the connection to the cube with the details

entered. See Figure 4-38 on page 144.

144 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Having tested the connection, click Finish to save this data source within the

Cognos metadata database.

Figure 4-38 Create a new data source within IBM Cognos Framework Manager

7. The tool returns to the Data Source selection panel with the newly created

data source “ISW_Registory” in the list. To import the cube model in to the

Cognos Framework Manager, select this new data source and click Next.