AX2280
Querying data using data conversions
You can apply data conversion when querying a table, so that data returned from the query is converted according to the specified conversion target. For example, if a particular table stores data in U.S. dollars, you can convert the data as part of the query and return the values in Canadian dollars instead. This conversion happens on-the-fly whenever the query is refreshed; the converted data is not stored in the database.
The table that you are querying must already be configured to support data conversions.
Data conversions can be performed when querying data via Axiom query, or when using GetData (either as a function or as a data lookup). When setting up an Axiom file to use data conversions, consider the following to help determine whether to use an Axiom query or GetData:
-
When using GetData, you can configure the conversions on a cell by cell basis. Each individual GetData can be configured to perform data conversions or not, and can use different conversion targets. When using Axiom queries, each query can have only one conversion target, and all tables that are enabled for conversion will be converted. Depending on the desired report configuration, you may be able to use parallel Axiom queries to return a mix of converted and non-converted data, or to show different conversion targets side-by-side.
-
Axiom queries allow you to override the default conversion type and/or the conversion scenario as part of the query. GetData functions do not support this override; a GetData function will always use the default conversion type and scenario.
The available conversion rates and conversion targets are defined by your organization. If you are not sure what conversions are available or which target codes to use, please contact your system administrator for assistance.
