When using a currency partition, and when CCTRACK is set to TRUE (the default) in essbase.cfg, you must FIX on a single currency partition member. The tracking is done at the currency partition level: a database with two partitions has two flags, each of which can be “converted” or “unconverted.” Essbase does not store a flag for member combinations within a partition. Essbase tracks which currency partitions have been converted and which have not. Prevents data inaccuracies due to accidental reconversion of data during a currency calculationīy default, CCTRACK is turned on. CurType includes actual and budget scenarios.Įnables conversion to occur at report time through Report WriterĮnables conversion of a converted currency back to its original, local rate using the CONV TOLOCALRATE command In the Sample.Xchgrate database, the currency type dimension is CurType. Therefore, member names in this dimension need not match member names of the main database. The currency type dimension is created when you generate the currency outline and is not directly mapped to the main database.
To convert data between scenarios, select which type of rate to use. Typically, an application has different exchange rates for different scenarios, such as actual, budget, and forecast. In the Sample.Xchgrate database, the dimension tagged as accounts is CurCategory, and the account categories included are P&L (Profit & Loss) and B/S (Balance Sheet).Ī currency database, which typically includes an optional currency type dimension, which enables different scenarios for currency conversion. For example, it may be necessary to convert Gross Profit and Net Profit using one category of rates, while other accounts use a different set of rates. The categories defined for the accounts dimension in the main database are used to form the members in the accounts dimension of the currency database. Table 32. Xchgrate Database Currency NamesĪ dimension tagged as accounts, which enables the application of various rates to members of the dimension tagged as accounts in the main database.
0 kommentar(er)
