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
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
![[cook] [cook] [cook]](/data/assets/smilies/cook.gif)