One of Cognos learning: Concise Report Preparation Manual

1. Establish a database connection
(1) Start Cognos impromptu Administrator
(2) create a database connection catalog --> Databases
(3) Select the database type, newdatabase
(4) Fill in the database alias (remember this alias, which is used to create the. IQD File
2. Create an IQD File
(1) generated through Cognos impromptu Administrator
(2) handwriting

Handwritten. IQD file format:
COGNOS query
Structure, 1, 1
Database, ibm4
Begin SQL

Select sts_id,
Sts_words
From h_fee_status
Where table_name = 'acct'
And column_name = 'payment _ Method'

End SQL
Column, 0, payment method ID
Column, 1, Payment Method

Note:
1. The blue text is a fixed IQD File Format
2. Begin SQL ........ Any query statement can be written between end SQL statements, as long as it complies with the Oracle syntax.
3. In self-written SQL statements, the table name and field name must be capitalized.
4. The pink character is used to name the Chinese character name for each field, so that the Chinese character name can be seen in transformer.
3. Create a model file
(1) Start powerplay Transformer
(2) After file --> new, you can proceed in sequence as prompted.
(3) Select the IQD file in the following interface.
(4) Save the model file as the. Pyi file.
(5) Use powerplay Transformer

The. MDC file can be generated, that is, the ** cube we call the power cube.

5. Create a report
(1) Start Cognos powerplay
(2) file --> New
(3) Select the data source and. MDC file. Note that you must select remote
(4) Save the report as a. ppx file instead of a one-time. When the. ppx file is updated, the data in the table can be automatically updated.
6. Publish the. ppx file to powerplay enterprise-server.