Modifying data sources

sunfloweremryologistData Management

Oct 31, 2013 (3 years and 10 months ago)

79 views


Modifying data sources

If you do not want to use the default data warehouse, you can change the
connection string to point to the new data source.

1.

Open the Cognos administration page by clicking
Launch

>
IBM Cognos
Administration
.

2.

Click the
Configuration

tab and then click
Data Source Connections

to display a list
of data sources.

3.

Click
RIDW
.

4.

In the
Actions

column, click the
Set properties

icon.

5.

Click the
Connection

tab. If you want to change the data source type, click an
item in the
Type

dropdown lis
t.

6.

To modify the connection string, click the edit
.

7.

In the
DB2 database name

field, replace the text
sampledw

with
RIDW
.

8.

I
n the
DB2 connect string

field, replace the parameter,
sampledw
,with
RIDW
.

9.

Click
OK
.




Setting up and Running an ETL catalog

To set up and run and ETL catalog:

1.

Create a new database and name it RICTG:

a.

If you are using DB2, launch the DB2 Control Cente
r by clicking
Start

>
All Programs

>
IBM DB2

>
DB2 copy 1

>
general admin tools

>
Control Center
.

b.

Navigate to the existing database. Then, right
-
click and select
Create
new database standard
.

c.

In the Name field, type
RICTG

for the database name, and then
click
Finish
.

d.

After the database is created, click
OK
.

2.

Connect to the database in Data Manager:

a.

Launch the Data Manager tool.

b.

Click
Create a new catalog
, and type
RICTG

for the catalog name.
Then, click
Next
.

c.

For the DB alias, type
RICTG
.

d.

Type the us
ername and password of a user with the proper credentials
to access the database. Then, click
Finish
.

3.

Restore the OOTB Catalog in Data Manager:

a.

Open the restore catalog by click
File

>
Restore Catalog
.

b.

Navigate to
\
datamgr
\
Insight_catalog
\

OOTBDMCatalog
.ctg
, and click
OK
.

4.

Verify the Data source connection for RQM:

a.

Navigate to the connections.

b.

Double
-
click
Rational Quality Manager
.

c.

Click the
Connections

tab. Then, click
test connection
. Leave the
username and password blank.

5.

Verify Data Warehouse con
nection:

a.

Double
-
click
Rational Data Warehouse
.

b.

Click the
Connection

tab, correct the username and password, and
then click
test connection
.

6.

Update ETL jobs:

a.

In the Data Manager, click
Jobs

>
OOTBE2E
. This represents end
-
to
-
end jobs. Remove the other ET
L step because you are only using RQM.

b.

Delete all icons except
Start
,
RQMAll
, and
Build_Star
.

c.

From the toolbar, click the
Insert a link

icon, and connect the
remaining parts.

d.

In the jobs folder, open the
StarJobs

folder, and click the
Facts

job.

e.

In the

right pane, double
-
click the fact build node,
F_JOB_EXECUTION_DATE_METRICS
.

f.

At the bottom of the general tab, select
Exclude this node from
processing
.

7.

Run the ETL task:

a.

From the toolbar, click the
Save

icon.

b.

From the toolbar, click the
Run

icon.

8.

Pub
lish the Data movement task:

a.

Select the
OOTBE2E

job in Data Manager.

b.

Click
Actions

>
Publish Data Movement Task
.

c.

Click
Jobs

>
OOTBE2E
. Then, click
OK
.

To see the new directory,
datamovementtasks
, login to
Rational® Quality Manager
Custom Reporting
.



Changing database users

Administrators can change which users have access to the

Rational® Quality
Manager Custom Reporting

database.

To change a database user:

1.

Open the Cognos Web application at
http://server:port/insight/servlet/dispatch
.

2.

Open the Cogno
s administration page by clicking
Launch

>
IBM Cognos
Administration
.

3.

Click the
Configuration

tab.

4.

In the left pane, click
Data Source Connections
.

5.

Under the
Name

column, click
RIDW
.

6.

On the next page, click
RIDW

again. Under the
Name

column,
rptuser

no
w
displays.

7.

Under the
Actions

column, click
More
.

8.

Click
Set Properties
.

9.

Click the
Signon

tab, then click
Edit the signon
.

10.

In the
User ID

and
Password

fields, type the authentication information for
a user with access to the RIDW database.

11.

Click
OK
.




Importing reports into Rational Quality
Manager Custom Reporting

Note: The
RQM
-
CR
-
2.0Beta2
-
Reports.zip
file is available
on

the All
Downloads page.

You can import archived reports into
Rational® Quality Manager Custom Reporting
.

To import reports:

1.

Add t
he
RQM
-
CR
-
2.0Beta2
-
Reports.zip

file in the cognos/deployment/ folder
of the install.

2.

Open the Cognos administration page by clicking
Launch

>
IBM Cognos
Administration
.

3.

Click the
Configuration

tab.

4.

In the left panel, click
Content Administration
.

5.

From t
he toolbar in the upper, right corner of the page, click the
New
Import

icon.

6.

On the Select a deployment archive page, select
RQM
-
CR
-
2.0Beta2
-
Reports
,
and then click
Next
.

7.

On the Specify a name and description page, type a name for the import in
the
Name

field. Then, click
Next
.

8.

On the Select the public folders content page, select the checkbox next to
Rational Quality Manager
. Under the Options section, leave the defaults for
all radio buttons, and click
Next
.

9.

On the Select the directory content page,
leave the defaults for all check
boxes and radio buttons, and click
Next
.

10.

On the Summary page, confirm the settings, and click
Next
.

11.

On the Select an action page, select
Save and run once
, and click
Finish
.

12.

On the Run with options page, select
Now

to im
mediately import the reports,
or select
Later

and schedule a future date and time to run the import. Then,
click
Run
.

13.

If you want to view the details of the import, select
View the details of this
import after closing this dialog
, and click
OK
.


The repo
rts are imported into
Custom Reporting
.




Importing custom reports into Rational Quality
Manager

Rational® Quality Manager

allows you to work with the custom reports.

Before importing reports, you must first set up the report host server.

1.

To set up the r
eport host server:

a.

Go to
Admin

>
System Properties
, and click
Custom Reporting
Host Properties
.

b.

Type the host name, port number, and your user ID and password.

c.

Click
Save
.

2.

Point to the
Reports

(
) icon, and click
All Reports
.

3.

From the toolbar, click the
Import Custom Report

(
) icon.

4.

In the Import Report window, click
Browse

to locate the Cognos report.

5.

Open the
Cognos Reports

files, and then open
Rational Quality Manager
.

6.

Open the report category folder, select the report, and click
OK
.

7.

Type a name and descr
iption to assign to the imported report.

8.

Select
Shared

to save the report to the Shared Reports folder, and then click
OK
.

The report is now imported into
Rational Quality Manager
.