Problem with hotfile

[Swathi37]

Hi all

I have serious problem with the hotfile. I had created an imr report using a hot file. But my report runs very slow since the hot file is 1GB. I would like to use an MS-Access table instead of hot file. So how do I delete the hotfile and include the MS-Access Table in the already created catalog? I did create the datadefinition but can't figure out how to include this in the existing catalog. Is this possible? Please let me know.
I appreciate your help.

Thanks
Swathi

 

[CognosProfessional]

Just go directly to Transformer, and right click in the Data Sources box , insert data source, Access Table is the drop down box choice you would use. Follow the next steps as usual, and create the cube. No need for the catalog this way, unless, ofcourse you are using Impromptu.

If you have to use Impromptu, Check this out first,

Distributed Sorting Validation Kit

You can download the Distributed Sorting Validation Kit from the Cognos Support Web site at

http://support.cognos.com/distributedsort

The kit includes the following:

scripts

You can run scripts to check the sorting order of your databases and operating systems. These scripts load data into your databases and use the collating sequences of your databases to sort the data. They also use the collating sequences of your operating systems to sort the same data.

utility

A utility to check the sorting order of the operating system on which your Cognos product is installed.

the Troubleshooting Distributed Sorting book

This book tells you how to run the scripts and utility and how to determine the results of the validation process. It also tells you how to modify the way your Cognos product sorts data.

New Product Features

To eliminate the risk of experiencing the problems, we have enhanced our products in the following ways:

Enable or disable distributed sorting.

On a database connection, you can enable or disable distributed sorting. You can disable distributed sorting if the results of the operating system and database sorting validation process aren’t the same, or if your databases don’t sort in the same order. If neither of these situations exists, you can enable distributed sorting.

Note: When a Cognos product that is multibyte-language-enabled accesses a database it automatically adjusts its default method of distributed sorting for specific databases. This behavior prevents the most common causes of the potential problem.

Specify a special collating sequence.

On a database connection you can specify special options when distributed sorting is not compatible by default. Cognos provides special collating sequences, such as those for EBCDIC and Microsoft Access language variations, to substitute for the collating sequence of your operating system. You can use these special collating sequences to continue to use distributed sorting.

For more information about these new features, see the Troubleshooting Distributed Sortingbook, available with the Distributed Sorting Validation Kit.

CP

 

[Swathi37]

Thank you so much CP. Thanks for the extra information you have given me.
I dont use transformer. I use Impromptu. I still can't figure out the problem of replacing the hotfile with an MS-Access table. Could you please give me the steps?

Thanks for all your help.
Regards
Swathi

 

[CognosProfessional]

A hotfile can only come from Impromptu. In order to save an .imr to a hotfile, you need to create a file that will work in Impromptu. Like, a .dbf file. Can you save your Access file to a .dbf? Then, use the dbf to make a catalog just for this hotfile as a test. does that work for you?

So ya got impromptu. No Powerplay?

CP