There is a need to build a Cognos PowerCube when there is no access to a network for a Cognos Package or Report or IQD based data source.
This could be used for demonstration purposes or for providing a portable testcase to support.
Avoids the need for replicating the same relational database with database scripts, data exports, matching database versions etc.
Resolving the problem
- In Transformer, File Preferences, CSV Output tab.
- Check Output enabled and specify a folder.
- Build the Cube
You can Generate Categories and not build the Cube to create the CSV output, but ensure the Data Source Properties, General, Generate Categories is checked. You can also generate the CSV for only 1 data source by selecting 'Generating Categories for Selected Data Source' for individual data sources.
The option should only be used for creating a local CSV copy of data sources and should be disabled during model design or cube building processes.
Replacing the Transformer data sources with new CSV data sources.
You need to delete the existing data sources and replace by inserting new CSV data sources.
1. Make a backup copy of the model file.
2. Check and make note of the existing data source(s) properties
- Timing, Uniqueness, Sets current period, etc.
- Identify any Calculated Columns added to the data source(s)
3. Remove each existing data source by selecting it and pressing Delete key. You will receive warning that association could be lost and asking to proceed. Click Yes.
4. Insert data source by selecting the Data Sources window and pressing Insert key. New Data Source windows appears.
5. Select Data Source Type, Delimited-field text with column titles. Next.
6. Click Browse, and select the replacement CSV file. Next. Finish.
7. Set the new data source properties to match the removed data source. Repeat for each data source.
8. Recreate any Calculated Columns from the original Data Source(s)
9. Select from the menu, Tools, Check Model. Address any issues with column names that might differ from the original data source.
10. You should now be able to build the cube using local CSV based data sources.