When you save your project in the SuperCHANNEL GUI, the settings are stored in an XML project file. This file contains all the information about your project, including:
- The source and target database details.
- Details of fact tables, classification tables and their columns.
- The links between tables.
- Data mapping from source data types to target data types.
- Information about grouping.
You can use the project file to reload your project back into the SuperCHANNEL GUI and also to run SuperCHANNEL from the command line.
Manually Editing the Project File
It is possible to manually edit the project file in a text editor. However, please take care if you choose to do this. If you make any changes to the file that are not valid then you may not be able to load the project back into the SuperCHANNEL GUI or use it with SNU on the command line.
If you intend to edit the project file manually, follow these rules:
- Make a backup of the project file before editing it.
- Use a text editor that highlights XML syntax.
- After each change, test that the project file can be loaded into SuperCHANNEL. Make another backup before proceeding to the next change.
Editing the Source and Target Database Details
The source and target database details are contained in the
For example, the following lines define the source and target database details:
The following are some of the changes you might make to the source and target database details.
Change the Source Database Location
LOCATION attribute contains the connection string for connecting to the database. If you want to use this project file with a different database, you can change the string. For example:
The new source must have all its tables and views referenced in the project file, otherwise SuperCHANNEL will not load the updated XML file.
Change the Target Database Details
You can change the target database location by editing the value of the
LOCATION attribute on the target
For example the following modification changes the output SXV4 location to D:\SXV4\Retail_Banking_V2.sxv4:
Handle Table Name Changes
If the name of one of the tables in the source database has changed, and that table is used in the SuperSTAR database, then SuperCHANNEL will not load the project file.
When you attempt to load the project file, SuperCHANNEL will display an error message indicating that it cannot find the table:
To resolve this issue, manually edit the project file in a text editor to replace all instances of the old table name with the new table name. You will then be able to reload the project in SuperCHANNEL.
<COLUMN/> elements contain information about columns in the fact or classification table. For example:
VISIBLE attribute determines whether or not to include the column in the build (it is equivalent to the Included in Build check box in the Target Attributes).
To exclude a column from the build, change the value of
N. For example:
Editing Column Labels
LABEL attribute contains the display name that is used for databases, tables, and columns. You can edit this attribute to change what is shown in the SuperSTAR clients.
For example the following
LABEL attribute defines the display name for the database:
The following example shows the display name for a table:
The following example shows the display name for a column:
You can also edit the display name for groups. In this case the attribute to edit is the
Using the Project File on non-Microsoft Platforms
You may also need to modify the project file if you intend to use it with SNU (the SuperCHANNEL command line utility) on a non-Microsoft platform. For example, you will need to manually update any file paths in the project file so that they are appropriate for the platform you are running SNU on.
See Channelling on non-Microsoft Platforms - SNU for more information.