A multiple currency application includes the Hsp_Rates dimension for storing exchange rates. It includes these members and others that store currency rates:
When generating reports or loading data, refer to the Hsp_InputValue member. When loading data, you must load data against the local currency. You need not refer to the Hsp_InputCurrency member.
By default, the Hsp_Rates dimension is set to Sparse. You can change this (see Setting Dimension Density and Order).