September 2019
Beginner to intermediate
346 pages
7h 35m
English
Consider the example of a management information (MI) reporting analyst based in California. The analyst will have to extract information about the sales performance of each region from the central data warehouse to present a global sales performance MI report.
Should the analyst be expected to intuitively know in which currency the revenue of each region is stored in the warehouse? It would be helpful if formats were assigned to the revenue to signify whether the local or a commonly used currency (such as the US Dollar, Yen, Euro, or British Pound) has been used to store the regional revenue figures.
The following statement, when added between the DATA and SET statements, converts the numerical ...
Read now
Unlock full access