Currency Dimension Properties

Currency, Parent, Alias: Default, Alias: T1, Data Storage, Two Pass Calculation, Description, Formula, UDA, Smart List, Data Type, Operation, Symbol, Scale, Triangulation Currency, Reporting Currency, Thousands Separator, Decimal Separator, Negative Style, Negative Color

If the Currency symbol is not specified, it is set by default to the ISO symbol if the currency being loaded is defined in Oracle Hyperion Planning.

Table 5-11 Currency Dimension Properties

Column Header in Load File	Planning Property	Value	Default	Required
Currency	Currency Name	Text	None	Yes
Symbol	Symbol	Text, subject to Planning currency symbol naming restrictions	ISO symbol if the currency being loaded is defined Planning; the same as the currency name if the currency being loaded is not defined in Planning	No
Scale	Scale	An integer value from 0 to 9, where 0 corresponds to 1, 1 corresponds to 10, 2 corresponds to 100, and so on	No scaling	No
Triangulation Currency	Triangulation Currency	A currency defined in the application	None	No
Reporting Currency	Reporting Currency	True, False, or an integer: non-zero is true; zero is false	False	No
Thousands Separator	Thousands Separator	default; none; comma; dot; space	None	No
Decimal Separator	Decimal Separator	default; dot; comma	dot	No
Negative Style	Negative Sign	default; prefixed; suffixed; parentheses	prefixed	No
Negative Color	Negative Color	default; black; red	black	No