If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos.ini for 8.3?

Started by Arsenal, 11 Feb 2008 09:54:41 AM

Previous topic - Next topic

Arsenal

Hi All,

8.1's transformer had a file called cognos.ini where we could specify the databases. This seems to be missing in 8.3. I'm guessing that because of 8.3 unified architecture, Transformer looks for the databases in the IQD in the main cognos configuration. As a result, if the main gateway is down, then Transformer will be unable to open the model file because it cannot find the information for the database specified in the IQD, whereas in 8.1 even if the main gateway was down, because the databases were specified in cognos.ini, it could still build cubes.

Is this correct? Thanks

Arsenal

Actually, the gateway being up is not an issue.

It seems that when an 8.1 model is saved as an .mdl and opened in 8.3, it opens fine the very first time. Once you build the cube and close the .mdl and try to open it again is when a TR1102 error comes i.e. unable to locate the databse specified within the IQD

ykud

In 8.3 iqds are completely gone.
You should create framework manager packages (query subjects) to use instead of iqds.

jahnavi

The files are saved as mdl and open it on the transformer instead of ini. Then its working fine and no more iqds are there in cognos8.3. you can create the packages and publish the models

DTV12345

"cogtr.xml" may be what you need to look at...

My 2 cents.

PS: before you modify it, back it up!

rockytopmark

cognos.ini is a Series 7 based file.  This file is still required for use with IQDs, but must be created manually in any Cognos 8.x environment.

Simply copy the 8.2 cognos.ini over to your 8.3 environment and you should be all set.

jguevin

IQDs are still valid data sources in 8.3. First you need to install the series 7 iqd bridge from the transformer disk, then you need to copy the data source connections from the cognos.ini file into the cs7g.ini file which lives in the X:\Program Files\Cognos\c8\CS7Gateways\bin.  Stop and start the services.  now you should be able to use the IQDs in trasnformer.  You can see:

KB#1038388
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=137406

if you are a supported customer.

hope this helps
Jeff

Arsenal

thanks for your reply guys

i did chance upon the solution of opening the .pyi files, saving them as .mdl's and then opening the .mdl's in 8.3 transformer

but i also realized that for it to work correctly the second time, the mdl must be saved as .pyj in 8.3 transformer. Otherwise, the next time you open the .mdl, Transformer gives a sign-on error saying it could not find the database.