Dimension(dimTag)
|
Returns the name of a predefined dimension. The dimtags are:
-
DIM_NAME_PERIOD
-
DIM_NAME_YEAR
-
DIM_NAME_ACCOUNT
-
DIM_NAME_ENTITY
-
DIM_NAME_SCENARIO
-
DIM_NAME_VERSION
-
DIM_NAME_CURRENCY
|
Period(periodName)
|
Returns the specified period. The periodName options are:
-
FIRST_QTR_PERIOD
-
SECOND_QTR_PERIOD
-
THIRD_QTR_PERIOD
-
FOURTH_QTR_PERIOD
-
FIRST_PERIOD
-
LAST_PERIOD
|
CrossRef(accountName)
|
Generates a cross reference for the account
|
CrossRef(accountName, prefix)
|
Generates a cross-reference for the account. The account name contains a prefix that you define. The default prefix is No, followed by a blank space and the account name, for example, No Salary.
|
getCalendarTPIndex()
|
Generates a member formula that returns an index for the time period; the index is based on the calendar year.
|
getFiscalTPIndex()
|
Generates a member formula that returns an index for the time period; the index is based on the fiscal year.
|
CYTD(memberName)
|
Generates a calendar year-to-date formula for the member
|
CYTD(memberName, calTpIndexName, fiscalTpIndexName)
|
Generates a calendar year-to-date formula for the member, and the time period index based on the calendar year and fiscal year. Use when members are renamed. The default member names are “Cal TP-Index” and “Fiscal TP-Index”
|