CurrencyTableMake
CurrencyTableMake verb
creates a currency table or updates an existing currency table.
The user interface equivalent is to modify the properties on the Currency Table property sheet.
On
the Cognos®
Transformer user
interface, the currency table has a single property sheet, even when
Euro triangulation is in effect. In MDL, the Base Currency and Euro
Currency tables display as two separate objects. Each has its own CurrencyTableMake statement.
The
default object names for the two types of table are CurrencyBaseTable and CurrencyEuroTable.
You can specify a different object name, but on the user interface,
the default object always displays.
If you specify the option CurrencyTableType,
the object name of the currency table is optional.
The syntax is as follows:
CurrencyTableMake [objCurrencyTable] [currencytableopts] Associations
assocopts| Argument |
Description |
|---|---|
| CurrencyTableMake objCurrencyTable |
Creates the currency table objCurrencyTable or modifies it if it exists. objCurrencyTable can be the object name, object identifier, or both. Include the object name if the currency table does not exist. |
| currencytableopts |
Optional parameters that specify columns in an external data source. For the complete list of options, see currencytableopts. If the currency exists, previously set options are retained unless you change them with this command. |
| Associations assocopts |
Optional parameters that specify associations for the currency table. For the complete list of options, see >assocopts. |
Example
This example defines a currency table.
CurrencyTableMake 869 "CurrencyBaseTable" CurrencyTableType BaseTable
Associations 1315 "Country Code" AssociationType Type_Query
AssociationRole Role_CountryCode AssociationReferenced "Country Code"
Associations 1317 "Date" AssociationType Type_Query
AssociationRole Role_Date AssociationReferenced "Date"
Associations 1319 "Currency" AssociationType Type_Query
AssociationRole Role_Label AssociationReferenced "Currency"
Associations 1321 "Conversion Rate" AssociationType Type_Query
AssociationRole Role_Rate AssociationReferenced "Conversion Rate"