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