The error message "No cognos. ini" appears when the IQD file is generated in TRANSFROM.

Source: Internet
Author: User
According to the relevant documentation on the released iqd cube in the forum, I made the configuration and the result was faulty ,,
The specific configuration is as follows.
1. Select model
Download(37.8 KB) 2011-1-7

2. Select the Data Type IQD
Download(41.04 KB)

3. Specify the IQD file path. I put it in F: \ dump \ a. iqd. I am not very familiar with the leveL option. Let's just select the default option. I hope you can advise me.
Download(41.26 KB)

4. Click Finish. The photo processing system should publish the file.
Download(46.21 KB)

5. Now the problem is... When you look at the image, you will be prompted that The cognos. ini file cannot be obtained.
Download(47.19 KB) 2011-1-7

6. this is strange. It was said on the Internet that it was because of cognos. INI file configuration problems, I read the daidao post, said that in the cognos and directory, to create such a file, there is also a D in cognos 8.3: \ Program Files \ cognos \ c8 \ CS7Gateways \ bin \ cs7g. INI file. I have added the database configuration to both files.
[Databases]
ODS_LOCAL = ^ User ID: ^? Password:; LOCAL; OR; ORACLE @ % s @ ods/% s @ COLSEQ =
Here, ODS_LOCAL is the string configured to connect to the database in the local TNS.
Download(31.68 KB) 2011-1-7

View my COGNOS. Ini content
Download(30.32 KB) 2011-1-7

7. Let's take a look at the syntax of my a. iqd file. I don't know if it will be a syntax problem.

COGNOS QUERY
STRUCTURE, 1, 1
DATABASE, orcl_LOCAL
TITLE, [orcl_LOCAL]. [F_SEM_Response]
BEGIN SQL
{
Select to_char (a. month_id) as monthly ID,
A.org _ id as unit ID,
E. configurationname as unit,
A. RESOURCEID as RESOURCEID,
F. ITEM_NAME as Indicator Name,
A. ITEM_VALUE as current value
From
(Select RESOURCEID,
MONTH_ID,
ORG_ID,
ITEM_VALUE
From orcl_LOCAL.ods_zhcx.idx_item_ot_value_month
Where resourceid = 'fzsc03001'
And version_id = '7'
)
Left join
(Select configurationid,
Configurationname from orcl_LOCAL.ods_zhcx.code_pub_cmpy
) E
On (e. configurationid = a. ORG_ID)
Left join
(
Select RESOURCEID, ITEM_NAME from orcl_LOCAL.ods_zhcx.IDX_ITEM_DEFINE
) F
On (a. RESOURCEID = f. RESOURCEID)

}
END SQL
COLUMN, 0, monthly ID
COLUMN, 1, unit ID
COLUMN, 2, Unit
COLUMN, 3, RESOURCEID
COLUMN, 4, Indicator Name
COLUMN, 5, current value

6. jpg(92.35 KB)

Downloads: 0

 

 

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.