CurrencyTables Collection

The CurrencyTables collection contains all CurrencyTable objects in a model.

Discussion

Use this collection to add, select or remove a CurrencyTable object.

You can use external data sources to populate a currency table, or you can create and insert the currency records and rates. Both methods require data that sets the

conversion date
ISO country or region code
conversion rate
currency label (optional)

Transformer uses the currency table information to make the correct conversions when a user views cubes in PowerPlay®. Currency conversion requires that you have at least one time dimension in the model. Transformer stores the currency information at the same level of detail as appears in the time dimension (by default, monthly). You can adjust it to a higher level if required.

For conversions to or from EMU currencies, you need two tables. One table must have the CurrencyTableType property set to trCurrencyTableBase, and the other must be set to trCurrencyTableEuro. A CurrencyTables collection can only contain one of each type of table.

CurrencyRates, CurrencyRecords, and CurrencyTables collections are all required to convert currency. To return this collection, use the CurrencyTables property.

These tables list related methods and properties.

Method	Description
Add Method ()	Adds a CurrencyTable object to the collection.
Item Method	Selects a specific CurrencyTable object in the collection.
Remove Method	Removes a specific CurrencyTable object from the collection.

Property	Description
Application Property	Returns the Transformer Application object.
Count Property	Returns the number of CurrencyTable objects in the collection.
Parent Property	Returns the parent object.

Examples

objBaseTable = objModel.CurrencyTables.Add()