Part 2 in this three-part series looks at the process of extracting the required data from Rational Asset Analyzer and transferring it into Rational Insight. After the data has been transferred to the reporting tool, the tutorial describes the tasks to make the data available for use
Create the XML file from the Rational Asset Analyzer v6 REST interface
- Enter this address in your browser, substituting your information for the variables, which are in italics (see Figure 1 for an example):
Figure 1. REST API URL address in a web browser (example)
- When you are in the REST interface, select the cq option (custom query) from the URL column of the table.
Figure 2. REST API
- From the information from the latest scan of custom queries available, select a query to return the results (see Figure 3).
Figure 3. Custom query selection
Figure 4. Custom query results table in the REST API
- Amend the URL to contain the content type,
?contentType=cognos, at the end (Figure 5), and then press the Enter key.
Figure 5. Cognos content type addition to the URL
This will convert the query results to an XML format that IBM® Cognos® Version 8 can use. (The 8 the metadata contains information about the XML fields that Cognos needs.)
Figure 6. Cognos XML file
- Save, and then copy the XML file that contains the query to somewhere on your local system (
c:/temp/Cognos queries, for example).
Create the new data source for use in Rational Insight
Within Rational Insight, you will propagate the XML file through the Cognos 8 engine, not the Insight Configuration Manager.
- Open the Cognos 8 Framework Manager: Click the Windows Update option under the Admin menu, and then select these options from the drop-down menus (see Figure 7): IBM Rational > IBM Rational Insight > IBM Cognos 8 > Framework Manager.
Figure 7. Opening the Cognos Framework Manager
- Then Select File > New Project.
Figure 8. "Create a new project" selected in the Projects menu
- Name the project (for this example, use
RAA Insight CQ).
- Select a location for the project (see Figure 9).
- Click OK.
Figure 9. New Project wizard in Cognos
- Select the language for the project.
- In the Metadata Wizard (Figure 10), select Data Sources under Select Metadata Source, and then click Next.
Figure 10. Select Metadata Source menu
- Select the New option.
- Select Next (Figure 11).
Figure 11. Cognos New Data Source creation wizard
- Click Next.
In the New Data Source wizard, follow these steps:
- Create a name for the new data source (for this tutorial:
File By Language).
- Add a description if required.
- Click Next.
- For the Type property, select XML from the drop-down menu (Figure 12).
Figure 12. Specifying the connection in the New Data Source wizard
- Select Next.
Figure 13. Data source parameter selection
- In the Connection String property field, specify the path to the location of the stored XML file in your local workspace.
- Click Finish.
Figure 14. XML Connection String field
- Wait for a success message like the one in Figure 15 to be displayed.
Figure 15. Final screen with success message
Data sources in the Framework Manager contain information that identifies the location of any data source tables needed for the query subjects.
- When you are modifying a project, you can import metadata from a variety of data sources, both relational and dimensional. Before importing, it is important that you determine that the data source contains the data and metadata that meet your reporting needs. After you have successfully created a new data source for Rational Insight, go back to the Data Sources page.
- Select the newly created data source name (Figure 16).
- Click Next (Figure 17).
Figure 16. Cognos Metadata wizard
Figure 17. Data source name selection in the Cognos wizard
- Select the objects that you want to import: Under the folder with that name (Figure 18), check the box to choose to import Tables and, within that folder, the check box for the data source name (File By Language in this example).
- Click Next.
Figure 18. Select Objects window
- Accept the defaults, and click Import (Figure 19).
- When the import action is complete, click Finish.
Figure 19. Generate Relationships window
Test the connection
Now that you have created a data source, test the connection.
- Go back to the Framework Manager.
- In the left navigator pane (Project Viewer), expand the Data Sources option.
- Right-click the name of the newly created data source, and select the Test option.
Figure 20. Data source testing
- Wait for a success message to be displayed.
Create a package
The data that you pull from the sources appears in the Report Studio as packages. A package is a subset of a project. You create a package to make metadata available to your users.
Packages offer a single, integrated business view of the data that has been extracted. All of the relationships and dependencies between the data are held as metadata within the package.
For example, if your data source contains information from different areas of a business, you might decide to create different packages for Human Resources and Finance. It must contain all information that a specific user or group of users needs to create reports.
- In Framework Manager, in the Project Viewer pane, select Package.
- Right-click and select Create.
Figure 21. Package creation
- Name the package, and click Next.
Figure 22. Package name and description dialog window
- Accept the defaults and click Next.
Figure 23. "Define objects" view
- Keep the default settings and click Finish.
Figure 24. Select Function Lists view
- When you get the success message (Figure 25), click Yes to open the Publish Package Wizard when you are asked whether you want to do so.
Figure 25. Option to open the Publish Package wizard
- Accept the defaults and click Next.
Figure 26. Package location type selection
- Click Next.
Figure 27. Add Security view in the Publish wizard
- Accept the default to "Verify the packaging before publishing," and click Publish.
Figure 28. Options view, ready to publish
The data is now accessible in Rational Insight, and you can use it within reports.
Part 3 in the series covers what you can do with data in Rational Insight and how to create reports and dashboards.
- For more about Rational Asset Analyzer, start with the developerWorks page for links to technical articles and many related resources, and then browse the product over page, and explore the Information Center.
- For more about Rational Insight, browse the developerWorks page for links to technical articles and many related resources, the product overview page for details, and explore the support page, as well as the user guide in the Information Center.
- Visit the Rational software area on developerWorks for technical resources and best practices for Rational Software Delivery Platform products.
- Stay current with developerWorks technical events and webcasts focused on a variety of IBM products and IT industry topics.
- Attend a free developerWorks Live! briefing to get up-to-speed quickly on IBM products and tools, as well as IT industry trends.
- Follow developerWorks on Twitter.
- Watch developerWorks on-demand demos, ranging from product installation and setup demos for beginners to advanced functionality for experienced developers.
- Check the Rational training and certification catalog, which includes many types of courses on a wide range of topics. You can take some of them anywhere, any time, and many of the "Getting Started" ones are free.
Get products and technologies
- Get the free trial download for Rational Asset Analyzer.
- Get the free trial download for Rational Insight.
- Evaluate IBM software in the way that suits you best: Download it for a trial, try it online, use it in a cloud environment, or spend a few hours in the SOA Sandbox learning how to implement service-oriented architecture efficiently.
- Join the Rational Asset Analyzer forum to ask questions and participate in discussions.
- Join the Performance Management with Rational Insight forum to ask questions and participate in discussions.
- Get involved in the My developerWorks community. Connect with other developerWorks users while exploring the developer-driven blogs, forums, groups such as the Rational Café, and wikis.