One of Cognos learning: Concise Report Preparation Manual

Source: Internet
Author: User

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.

 

 

 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.