Experience the charm of Cognos Bi 10 series, Part 1: First Installation

Experience the charm of Cognos Bi 10 series, Part 1: First Installation
Wu Minda, Senior Technical Consultant of information management software, IBM
Introduction: this series of tutorials aims to help you learn the main functions of Cognos Bi 10.1. In this section, we will teach you how to install
And deploying Cognos Bi 10.1 and creating your first simple report, it takes about three hours to complete the entire content.
View more content in this series
Mark this article!
Released on: February 1, October 14, 2011
Level: elementary
Preparations
IBM Cognos Business Intelligence 10.1 is the latest Bi solution for query, reporting, analysis, dashboard, and scorecard Functions
Yes, and can be expanded through functions such as planning, solution modeling, and predictive analysis. It can be considered when people try to understand performance and use tools to make decisions
And work style support, so that people can search and combine and interact with all aspects related to the business.
L The query and report functions provide users with the information they need to make decisions based on facts.
L dashboard enables any user to access, interact with, and customize content in a way that allows them to make decisions.
L The analysis function allows you to access information from multiple perspectives and aspects, so that you can view and analyze information and help you make informed decisions.
L collaboration functions include communication tools and social networks, which are used to promote opinion exchange during decision-making.
L The Scorecard function automates the capture, management, and monitoring of business indicators, allowing you to compare them with your own strategic and operational goals.
Before getting started with Cognos Bi 10.1, go to IBM developerworks to download the trial version of Cognos 10.1. IBM Cognos bi
Developer Edition v10.1.0 is: http://www.ibm.com/?works/cn/downloads/im/cognosbi /. You need to download two
Files, IBM Cognos Bi Developer Edition 10.1.0 windows English download file name is czs56en.tar.gz, IBM Cognos
The download file name of business intelligence samples v10.1.0 for DB2 luw windows English is czq90en.tar.gz. IBM Cognos
Bi Developer Edition v10.1.0 has 30 days of use, which is enough for you to complete this tutorial.
According to the system requirements of the trial version, you need to use the Windows operating system for installation. Windows XP SP3 or a later version is required. In addition
Install Windows Internet Information Service IIS and upgrade the Browser IE to version 7 or later. We recommend that you have more than 2 GB of memory and more than 1.5 GB of memory.
The temporary space and the disk space larger than 2 GB for installation.
Because this tutorial requires a database to store sample data of Cognos Bi 10.1, you also need to download the DB2 community from IBM developerworks.
. DB2 express-C 9.7.4 for Windows: http://www.ibm.com/?works/cn/downloads/im/udbexp /. Lower
The file name is db2exc_974_win_x86.exe.
Install DB2
Double-click db2exc_974_win_x86.exe and select any directory for decompression. After successful decompression, click setup.exe to enter the DB2 installation and startup board.
Figure 1. DB2 installation and startup Board

Page number 1/21
Click "install new product" to go to the installation wizard interface, and click "Next" to continue. Read and accept the license agreement, and click "Next" to continue.
Figure 2. Select the installation type
This tutorial selects a typical installation. This option will install the main components and functions of DB2.
Figure 3. Select create response File
Page number 2/21
Select not to create a response file and install it only. Click "Next" to continue.
Figure 4. Select the installation folder
Generally, use the default drive and directory settings. Make sure there is 560 MB of available space. Click "Next" to continue.
Figure 5. Set User Information
Page number 3/21
After DB2 is installed, some DB2 processes run as system services. An operating system account is required to run these services. In this tutorial
The default db2admin user account and password are Cognos. the DB2 installer will create it in the operating system. You can also specify an existing
Account, but this account must have local administrator power. Click "Next" to continue.
Figure 6. configure a DB2 instance
It can be considered that the DB2 instance is a database container. You must have an instance before creating a database. It is automatically created during installation on Windows.
An instance called DB2. By default, the DB2 instance listens to TCP/IP connections on port 50000. You can click Configuration to View Details. In this tutorial
Keep the default configuration. Click "Next" to continue.
Figure 7. Start copying a file
Page number 4/21
Check the preceding installation options. Click Install ". Click "finish.
Install Cognos
Decompress the file czs56en.tar.gz and click Run Cognos 10 bi server installer install.exe.
Figure 8. IBM Cognos Bi Developer Edition installation page
Select Simplified Chinese and click "OK ". In this step, read the license agreement and choose to accept the terms of the agreement.
Figure 9. Select the installation folder
Page number 5/21
You can select the default folder to ensure that there is space available. A Shortcut Folder refers to the Program Group of the product icon. You can also use the default IBM Cognos
Bi Developer Edition.
Figure 10. Configuration
You can use the default port on the configuration page. Then, set the user name and password for the Cognos administrator. In this tutorial, set the Administrator
The password is Cognos.
Figure 11. Installation Summary
Page number 6/21
In the Installation Summary, you can see that the entire installation requires more than 1.5 GB of disk space. Click "Install" to continue.
Figure 12. Complete installation
On the installation page, select start IBM Cognos Bi Developer Edition manager and click "finish ". IBM Cognos bi
Developer Edition manager is a development-specific component that can be used to install and configure IBM Cognos Bi and framework manager.
To manage users and start and stop services.
Figure 13. first startup interface of IBM Cognos Developer Edition Manager
Page number 7/21
Start the IBM Cognos Bi Developer Edition manager for the first time, and click "finish" to let the manager install and configure initialization.
Figure 14. install IBM Cognos Developer Edition Manager
The installation process may take more than ten minutes. Wait patiently until the logon page appears.
Figure 15. log on to the IBM Cognos Developer Edition Manager
Page number 8/21
On the logon page, enter the username and password shown in Figure 10. In this tutorial, select administrator and Cognos, and click OK.
Figure 16. Install cogos Bi suite
Page number 9/21
Select Bi suite and install it. IBM Cognos Bi suite provides you with complete self-service reporting and ad hoc query capabilities for access and repair
Modify and create a report. Access any type of data, including Relational OLAP, analytic OLAP, or desktop files. And through web, PDF, Excel, electronic mail
To send your reports. The installation process may take about half an hour. Wait until the logon page appears. Enter
The user name and password are administrator and Cognos in this tutorial, and then click OK.
Figure 17. Install framework Manager
Select framework manager and install it. This step is completed very quickly. Framework manager is a metadata modeling tool. It enables
Modelers can create and manage business-related metadata for use in all Cognos Bi applications. Main users of framework Manager
Data warehouse developers and data modelers.
Configure Cognos
First, copy db2jcc. jar and db2jcc_license_cu.jar in the c: \ Program Files \ IBM \ sqllib \ Java directory to c: \ Program
Files \ IBM \ Cognos developer \ Tomcat \ lib directory, and then restart the Cognos service in IBM Cognos Developer Edition manager.
Installation sample data
Decompress the file czq90en.tar.gz. click install_db2_samples.exe to install it. Read the license in the instruction step
Agreement and select to accept the terms of the agreement.
Figure 18. Select the installation path
Page number 10/21
The installation path uses the default one, which will be installed in the same directory as IBM Cognos Bi Developer Edition. After the installation is complete, the sample data file will be placed
Find the data file gs_db.tar.gz in c: \ Program Files \ IBM \ Cognos developer \ webcontent \ samples \ CES \ DB2, and
.
Click Start, select Run, enter db2cmd, and then click OK to enter the db2clp window. The installation process may take five minutes.
For more information about commands and display, see Listing 1. In this process, enter the user name and password of DB2. In this tutorial, we will use db2admin and Cognos.
List 1. Create a database and import data
> Cd c: \ Program Files \ IBM \ Cognos developer \ webcontent \ samples \ CES \ DB2 \ gs_db \ win
> Gosalesconfig. bat
> Setupgsdb. bat
-------------------------------------------------------------------
DB2 version 9 or later detected-using DB2 version 9 syntax
-------------------------------------------------------------------
Press enter at the prompts to accept the default value shown
Default values can be specifed in the file gosalesconfig. Sh
-------------------------------------------------------------------
Please enter the name of the database (or the alias) to be used for
Gosales sample data (default = gs_db ):
-------------------------------------------------------------------
This script can create the gs_db database.
Creating the database will cause any existing databases
With the same name to be dropped.
If you choose not to recreate the database,
Existing objects within the database will be dropped.
Wocould you like to create the database gs_db (y/n) default = Y:
Please wait...
Starting gosales_run_scripts
Dropping existing database gs_db if found
Creating Database gs_db
Page number 11/21
Back to Top
Create a data source connection
Start IBM Cognos Bi Developer Edition in the Start menu and run Developer Edition manager to ensure the services on the left are normal.
Click Start in the upper-right corner, and select IBM Cognos administration as shown in Figure 19.
Figure 19. Start Cognos Administration
Please wait...
Starting gosales_run_scripts
Connecting to gs_db
Enter the current password of db2admin: Cognos
Database connection information
Database Server = DB2/NT 9.7.4
SQL authorization id = db2admin
Local Database alias = gs_db
Error dropping existing tables
Creating tables.
Loading data.
Creating primary keys
Creating Indexes
Creating constraints.
Creating stored procedures
Creating views
Granting permissions
Updating statistics
Verifying row counts
Table row count validation successful
Adding Table Comments
Page number 12/21
On the IBM Cognos administration page, select the configuration page, select "data source connection", and click the icon in the upper right corner to create data, as shown in 20.
Source.
Figure 20. Add a data source in Cognos Administration
1. In the specify name and description-new data source wizard, enter "great_outdoors_sales" in the name and click "Next.
2. In the specify connection-new data source wizard, select "IBM DB2" as the data type and click "Next.
3. In the create data source wizard, enter the DB2 database name as "gs_db" in the specify IBM DB2 connection string. In the login window, select "password" and use
The User ID is "db2admin", and the password and confirmation password are written as "Cognos ". Click "test connection" 21, as shown in. Test successful
Click Next. If a problem occurs during the test, you can restart the Cognos service or the system.
Figure 21. specifying an IBM DB2 connection string
Page number 13/21
4. In the specify command-new data source wizard, retain the default value and click Finish.
5. Repeat steps 1 to 4 and create a "great_outdoors_warehouse" data source named "great_outdoors_warehouse ",
The remaining content is the same as "great_outdoors_sales.
6. In the specify name and description-new data source wizard, enter "sales_and_marketing" in the name and click "Next.
7. In the specify connection-new data source wizard, select the "IBM Cognos powercube" type and click Next.
8. Specify the IBM Cognos powercube connection string-in the new data source wizard, enter "C: \ Program" in the Windows location
Files \ IBM \ Cognos
Developer \ webcontent \ samples \ datasources \ cubes \ powercubes \ en \ sales_and_marketing.mdc ". Then click
"Test connection". Click Finish after the test is successful.
9. Repeat steps 6 to 8 and then create the "great_outdoors_sales_en" data source named "great_outdoors_sales_en ",
In Windows, enter "C: \ Program Files \ IBM \ Cognos ".
Developer \ webcontent \ samples \ datasources \ cubes \ powercubes \ en \ great_outdoors_sales_en.mdc ".
10. Repeat steps 6 to 8 and then create the "employee_expenses" data source named "great_outdoors_sales_en ".
Enter "C: \ Program Files \ IBM \ Cognos"
Developer \ webcontent \ samples \ datasources \ cubes \ powercubes \ en \ employee_expenses.mdc ".
11. Repeat steps 6 to 8 and create a "go_accessories" data source named "great_outdoors_sales_en". Windows location
Enter "C: \ Program Files \ IBM \ Cognos developer \ webcontent \ samples \ CES \ cubes \ powercubes \ en \
Go_accessories.mdc ".
12. Repeat steps 6 to 8 and create the "go_americas" data source, that is, "great_outdoors_sales_en ".
Enter "C: \ Program Files \ IBM \ Cognos developer \ webcontent \ samples \ CES \ cubes \ powercubes \ en \
Page number 14/21
Go_americas.mdc ".
13. Repeat steps 6 to 8 and create a "go_asia_pacific" data source named "great_outdoors_sales_en". Windows location
Enter "C: \ Program Files \ IBM \ Cognos developer \ webcontent \ samples \ CES \ cubes \ powercubes \ en \
Go_asia_pacific.mdc ".
Back to Top
Import sample Archives
Next, import the deployment archive of the example to the Cognos environment. These archives are stored in c: \ Program Files \ IBM \ Cognos
Developer \ webcontent \ samples \ content \ DB2 Directory. Copy three files to c: \ Program Files \ IBM \ Cognos
The developer \ deployment directory is ready for deployment. These three files are ibm_cognos_samples.zip, the main Great Outdoors of this tutorial.
Company example; ibm_cognos_drillthroughsamples.zip and great outdoors show example of the drill-through function;
Ibm_cognos_powercube.zip multi-dimensional cube example.
1. On the IBM Cognos administration page, select the configuration page, select "Content Management", click the icon in the upper right corner, and create
Import.
Figure 22. New Import wizard
2. In the deployment archive, select ibm_cognos_samples and click Next.
3. In the specify name and description-create import wizard, follow the default name and click Next.
4. In the public folder content, select the "sample" of the file library content and click Next.
5. In the specify general options-new import wizard, retain the default options and click Next.
6. Review Summary-create an import wizard and click Next.
7. In the Select Operation-new import wizard, select "Save and run once" and click Finish.
8. In the run and use option-ibm_cognos_samples, select "now" and click Run.
9. Repeat steps 1 to 8 and select ibm_cognos_powercube for import.
10. Repeat steps 1 to 8 and select ibm_cognos_drillthroughsamples for import.
The first simple report
Page number 15/21
Start IBM Cognos Bi Developer Edition in the Start menu and run Developer Edition manager to ensure the services on the left are normal.
Click Start in the upper-right corner and select report studio, as shown in Figure 19.
Under the "Cognos> public folder> sample> model" path, select the "go Data Warehouse (query)" data packet to enter IBM report Studio
And then select "new ".
Figure 23. Select a data packet
When selecting a report type, select "list" and click "OK.
Figure 24. Select a report type
Page number 16/21
In the pluggable objects on the left, expand the "Sales and Marketing (query)" directory, expand the "sales (query)" namespace, and select
Product Series, product types, and products, select the quantity and income under "sales materials" and drag them to the list on the right one by one.
Figure 25. Select a project
Page number 17/21
The rest of the work is to click the run button on the toolbar to wait for your first simple report to be published, as shown in 26.
Figure 26. Run a report
The report running result 27 is shown.
Figure 27. First simple report
Page number 18/21
Summary
Throughout the installation process, DB2 is a user data source. We put the sample data in the gs_db database of DB2, and
The Administration has configured the data source.
Cognos connection is a Cognos portal that provides a unified portal for information integration and user access. The administrator can use it to manage users and roles.
Management, server configuration, permission control, and other management functions. End users can access folders, reports, and personalized exhibitions through Cognos connection.
Access the content of Cognos viewer, report studio, Business Insight, and event studio.
Report studio is a professional report production module. Report makers can use this tool to create various types of reports, including unbalanced reports with Chinese characteristics.
Page number 19/21
Charts, dynamic dashboards, and KPI reports. Report makers can design by page. Each page can have multiple queries, and each query can connect to multiple data sources.
To heterogeneous data sources. The report content is simplified and simplified, allowing you to precisely control the attributes of each object in the report.
Business Insight is a custom dashboard tool for business users. Users can drag and drop any Cognos Bi content (including query, report, analysis, TM1
Datasets) to form a custom dashboard.
Cognos framework manager is a client development tool dedicated to metadata management. It can connect to multiple data sources.
OLAP, database, and other data sources, and provides metadata customization and management, security control, and other related control.
Figure 28. Architecture and working principle of IBM Cognos Bi Developer Edition
When you run the first simple report, IBM Cognos Bi Developer Edition runs as follows:
1. In the IBM Cognos framework manager tool, The Modeler ensures that metadata is organized in a way that business personnel can understand.
. The Modeler imports metadata from one or more databases and adds the metadata to the model according to business requirements.
2. modelers publish model data packets to IBM Cognos connection, so that report developers can use them to create reports and
Dashboard. For example, the "go Data Warehouse (query)" data packet in this tutorial.
3. Business personnel and report developers use published data packets to understand business data.
4. the user runs, views, and manages their content on the IBM Cognos connection. Based on different permissions, they can simply run and view reports
Tables, management plans, portal presentations, etc.
References
Learning
L visit the IBM Cognos express homepage for more information about the Cognos express solution.
Page number 20/21
L refer to the Cognos area on IBM developerworks
L refer to the BA software Partner Technical Exchange Platform
L refer to Cognos 10.1 Product Information Center
L keep an eye on developerworks technical activities and network broadcasts.
Obtain products and technologies
L download IBM software: trial version of IBM Cognos Express.
L you can build your next development project directly using the IBM product evaluation trial software downloaded from developerworks.
L use the most suitable method for you IBM product evaluation trial software: Download the trial version of the product, online trial product, use the product or flower in a cloud environment
Try the ibm soa personnel sandbox several hours to learn how to efficiently implement the Service Oriented Architecture.
Discussion
L check my latest blog information.
L participate in the discussion at the COGNOS Enterprise Bi forum.
L participate in the developerworks blog and join the developerworks Chinese community. The developerworks community is a global IT professional
Professional Social Network communities that provide Community functions such as blogs, bookmarks, wiki, groups, contacts, sharing and collaboration.
Page number 21/21
Experience the charm of Cognos Bi 10 series, Part 1: creating the first interactive offline report
Wu Minda, Senior Technical Consultant of information management software, IBM
Introduction: this series of tutorials aims to help you learn the main functions of Cognos Bi 10. In this section, we will teach you how
It takes about one hour to create your first interactive offline report.
View more content in this series
Mark this article!
Released on: February 1, October 14, 2011
Level: elementary
What is interactive offline report?
The IBM Cognos active report is an offline report that can interact with users, including data and presentation content. It cannot access the internal network of an enterprise.
And Databases can still use such reports to analyze data and obtain valuable information. Suitable for IBM Cognos active report
Mobile Office situations, such as the sales system. Users can browse reports offline to explore data and obtain additional information. IBM
Cognos active report expands the application scenarios of business intelligence, and enables the system to provide better performance and support for a larger scale.
You can use IBM Cognos report studio to create an active report. IBM Cognos active report is highly interactive and
Ease of use, the design of reports starts from user needs, and ensures a concise, beautiful, and smooth user experience. IBM Cognos active report is IBM
Expand Cognos report studio reports. Data needs to be presented to customers in a concise and easy-to-understand manner. Some users are used to numbers, while
Others prefer charts. To facilitate the design of more concise reports, IBM Cognos report studio maintains the same functions
Some interactive controls are added, such as tabs and drop-down menus, to define interactive reports and sort and filter data.
As a senior business engineer, you can download the dynamic report you just completed to a local file and send it to other members of the company.
The MHT format is saved and can be sent to colleagues as an email attachment.
If you are using Microsoft Internet Explorer 6.0, you cannot open the activity report in MHT format as a file. Interactive offline report
Microsoft Internet Explorer 7 or later is required. To view activity reports in MHT format in Mozilla Firefox, you must first download
An unmht additional component.
Create the first interactive offline report
1. Start IBM Cognos Bi Developer Edition in the Start menu and run Developer Edition manager.
Under normal conditions, click Start in the upper-right corner and select report studio.
2. Under the "Cognos> public folder> sample> model" path, select the "go Data Warehouse (query)" data packet to enter
Select "new" After IBM report studio ".
Figure 1. Select data packets
Page number 1/13
When selecting a report type, select "Activity Report" and click "OK.
Figure 2. Select a report type
Page number 2/13
3. In the left-side pluggable object, expand the "Sales and Marketing (query)" directory, and then expand the "sales (query)" namespace,
Press and hold the control key, select the product type under "product" and the income and planned income under "sales materials", and drag the Report to the right.
Page, as shown in 3.
Figure 3. Create a list
4. Select the income and planned income in the list report, click the summary on the toolbar, and select the "Total" option in the output,
4.
Figure 4. Summary
5. Select the following toolbox from the left-side pluggable object, and drag block to the front of the list Report on the right. This is
Page number 3/13
Place controls. In the blank area of the toolbox, right-click and choose Activity Report Toolbox project, as shown in Figure 5.
Figure 5. toolbox
6. Drag the "Data drop-down list" control into the "Block" area on the right.
7. In the left-side pluggable object, select a source, expand the "Sales and Marketing (query)" directory, and then expand "sales (query )"
Namespace, select the product series under "product", and drag to the "Data drop-down list" control, as shown in 6. At this time
Reports can be run without interaction control. Therefore, configure the interaction between data.
Figure 6. Place the Data Project to the control
8. Select the interactive action button in the "Data drop-down list" control and select "Create New Connection" in the lower part of the dialog box that appears ",
7.
Figure 7. Interactive Behavior
Page number 4/13
9. In the connection dialog box, create a "filter" method to connect to the data drop-down list and list Report, as shown in figure 8. Will be sent after confirmation
A hidden "product series" column is added to the List report to enable the data drop-down list and list Report interaction function.
Added. Now you can run the report, and the drop-down list will be useful.
Figure 8. Create a data drop-down list and a list Report connection
10. Select the "toolbox" in the left-side pluggable object and drag the "Data check box group" to the "Block" area on the right.
11. In the left-side pluggable object, select a source, expand the "Sales and Marketing (query)" directory, and then expand "sales (query )"
Page number 5/13
Namespace, select the year under "time", and drag to the Data check box group control, as shown in figure 9.
Figure 9. Add year data check box
12. You will find that the interactive behavior circle of the "Data drop-down list" control is light green, indicating that it has been configured. The newly added "Data
The interactive behavior circle of the check box group control has no color, indicating that no configuration has been made. Select the interactive behavior button
In the lower part of the pop-up dialog box, select "Create New Connection ". In the connection dialog box, create a "filter" method to connect to the Data check box group and
List report, as shown in 10. Note: select "Data check box group" on the left, select "list" on the right, and select data items.
Select "year", select "connection", and then confirm.
Figure 10. Create a data check box group and list Report connection
13. You will find that a Hidden Column "year" is added to the List report to enable interaction between the check box group of data and the list report.
Yes. The interactive behavior circles of the "Data drop-down list" control and "Data check box group" control are light green.
The configuration has been completed. You can save your design. Click RUN activity report from the "run" menu. Do not
Close the report studio window.
Figure 11. Save interactive offline reports
Page number 6/13
14. To save the interactive offline report locally, click Download activity report from the "run" menu. When prompted, select
Save the report as an MHT file. In this example, the size of the MHT file is 997 kb. You can send this report to your customers
You can view the MHT file in Microsoft Internet Explorer or Mozilla Firefox.
Interactive offline report for chart Interaction
The Cognos Bi 10 platform re-developed a new graphics engine, a qualitative leap over the Cognos Bi 8 graphics engine. Cognos Bi 10 graphic Introduction
Supports 3-D effects, with over 60 new preset attributes and enhanced graphic capabilities, such as pie charts and cycle charts, to provide new graphics, such as bullet charts and
Strong Graphic Style (color palette, color, fill, image, shadow, etc.). You can also use the conditional format in the legend to summarize small items and images.
Matrix Layout control, trend line, and other functions. To use the new graph engine version 10 in this tutorial, click
Click options. In the advanced options tab, remove the "Create with original chart" option, as shown in Figure 12.
Figure 12. Use the graph engine version 10
Page number 7/13
1. Open the first interactive offline report in report studio. To improve the appearance
In the blank area, click the selected report, and then drag the insert table button on the toolbar to generate a 1X2 table, and then drag the list Report
Drag the cell to the left, the data drop-down list and the data check box group remain unchanged. At last, align the work with the top of the toolbar.
Yes. Align the top of the 1X2 table, as shown in Figure 13.
Figure 13. Insert a table
2. Select the following toolbox from the left-side pluggable object, and drag the data card group to the right of the report area on the right.
Cell.
3. In the left-side pluggable object, select a source, expand the "Sales and Marketing (query)" directory, and then expand "sales (query )"
Namespace, select the product series under "product" and the year under "time", and drag to the data card Group Control
Value, as shown in figure 14.
Figure 14. data card group value
Page number 8/13
4. Select "interactive behavior" in the "data card group" control and select "Create New Connection" in the lower part of the displayed dialog box ". In Connection
In the dialog box, select the data check box group and data card group, and use the year data item for connection, as shown in Figure 15.
Figure 15. Create a connection between a data card group and a data check box Group
5. Create a new connection again ". In the connection dialog box, select the data drop-down list and data card group, and use the product series data items
Connection. In this way, a connection is created between the data card group and the data check box and the drop-down list, and the product series and year are used as the connections respectively.
Data items. In this way, you can see the two connections in the interactive action dialog box, and then confirm. 16.
Figure 16. Use the product series and year as the two connections to connect data items respectively
Page number 9/13
6. Select the "toolbox" in the left-side pluggable object and drag the "chart" to the "data card group" control. 17
. If the "chart" control cannot be found, right-click the "toolbox" and choose "All toolbox Projects" from the shortcut menu ". In the insert Graph
Select the three-dimensional pie chart in the table dialog box.
Figure 17. Insert a chart
7. In the left-side pluggable object, select a source, expand the "Sales and Marketing (query)" directory, and then expand "sales (query )"
Namespace, select revenue under "sales materials", and drag it to the default measurement of the three-dimensional pie chart; select order under "Ordering Method"
Method type, which is dragged to the sequence of the three-dimensional pie chart. Right-click the blank area of the pie chart and select "go to query", as shown in 18.
Figure 18. Set the measurement and sequence of a pie chart
Page number 10/13
8. In the left-side pluggable object, select a source, expand the "Sales and Marketing (query)" directory, and then expand "sales (query )"
Namespace, select the product series under "product" and the year under "time", and drag it to the data item queried by the pie chart. Then go to the page
Select page 1 in resource manager to return to the report page.
Figure 19. add data items
9. Right-click the blank area of the pie chart and select "Main/Detailed relationship", as shown in 20. Create a "Main/Detailed relationship" to split the pie chart and the number
Data Card group combination, where data card group is the main query, and pie chart is the detailed query. Data Card groups can contain product series and years,
This chart shows the annual revenue of each product series. If the "Main/Detailed relationship" cannot be found in the right-click menu, check
Step 6: whether the pie chart has been inserted into the data card group control.
Figure 20. Set main/Detailed relationships
Page number 11/13
10. Create two "new links", which are the associations between the year and the product series. Save your report design.
Figure 21. Establish a connection
11. Click RUN activity report from the "run" menu ". To save the interactive offline report locally, go
Click "Download activity report" in the "run" menu. When prompted, save the report as an MHT file. In this example,
The MHT file size is 2265 kb. You can send the report to your customers in Microsoft Internet Explorer or
You can view the MHT file in the Mozilla Firefox browser. You can select the year and product series to interact and view the chart.
. At the end of this article, the MHT file of the final interactive offline chart is provided for download reference.
Summary
You can use IBM Cognos report studio to create interactive offline reports, also known as activity reports or active reports. Interactive offline report
Tables are extensions of traditional IBM Cognos reports. You can use existing reports and add interactive behaviors to convert them to activity reports.
Provides an easy-to-use interface for end users.
You can use the same objects of other report types to build activity reports. However, some objects are dedicated to activity reports. These objects are classified into two types:
L Activity Report control, such as the data check box, drop-down list, and data card group control used in this tutorial.
L Activity Report variables are used together with the activity report control to add interactivity to the report. Operations performed on the control (for example
Select a project in the control or select a control itself) to set the variable value. In turn, the control can respond to
For example, filter data in the control.
Page number 12/13
Download
Information about the Download Method
References
Learning
L visit the IBM Cognos express homepage for more information about the Cognos express solution.
L refer to the Cognos area on IBM developerworks
L refer to the BA software Partner Technical Exchange Platform
L refer to Cognos 10.1 Product Information Center
L keep an eye on developerworks technical activities and network broadcasts.
Obtain products and technologies
L download IBM software: trial version of IBM Cognos Express.
L you can build your next development project directly using the IBM product evaluation trial software downloaded from developerworks.
L use the most suitable method for you IBM product evaluation trial software: Download the trial version of the product, online trial product, use in a cloud environment
The product may take several hours to try the ibm soa personnel sandbox to learn how to efficiently implement the Service Oriented Architecture.
Discussion
L check my latest blog information.
L participate in the discussion at the COGNOS Enterprise Bi forum.
L participate in the developerworks blog and join the developerworks Chinese community. The developerworks community is a global community.
IT professionals can provide professional social network communities with Community functions such as blogs, bookmarks, wiki, groups, contacts, sharing and collaboration.
Description Download Method of name size
Example of the first interactive offline report! Chart 1117 K HTTP
Page number 13/13