The Sample currency application builds on the business scenario introduced in Case Study: Designing a Single-Server, Multidimensional Database, as the Beverage Company (TBC) expands its business outside the U.S. TBC adds the following markets:
In addition, TBC adds a new member, U.S., a consolidation of data from the U.S. regions: East, West, South, and Central.
Data for each TBC market location is captured in local currency. U.S. dollar values are derived by applying exchange rates to local values.
TBC must analyze actual data in two ways:
After all actuals are processed, budget data is converted with budget exchange rates.
The TBC currency application consists of the main database (Interntl) and the currency database (Xchgrate). On Essbase Server, the databases are in the Sample application. If you do not have access to the databases, contact your Essbase administrator.