Category Dimension Properties
The category dimension defines the groupings in which you store information in your model.
Typical categories are Budget, Actual, and Forecast. Any dimension that is assigned the type C is a category dimension. Each model can have only one category-type dimension.
A category dimension has the following required properties:
|
Property Name |
Description |
|---|---|
|
YEAR |
Used to assign a YEAR to the category, to be used with the EPMRetrieveData and EPMMemberOffset functions in reporting. For more information, see the application help for SAP BusinessObjects Analysis, edition for Microsoft Office available on the SAP Help Portal. |
The following properties are required only if the category dimension is used in a consolidation model.
|
Property Name |
Description |
|---|---|
|
CATEGORY_FOR_OPE |
Category of source data to use when performing carry forward (CopyOpening). |
|
FX_DIFFERENCE_ONLY |
Specifies whether the translation result is calculated normally (blank or N) or if only the translation difference with the source category is computed ( Y). |
|
FX_SOURCE_CATEGORY |
Category of source data to be used when running currency translation on a simulation category. |
|
OPENING_PERIOD |
Period number of source data to use when performing carry forward (CopyOpening). This can be absolute (for example, 12 for December) or relative (for example, -1 for prior period). |
|
OPENING_YEAR |
Year offset of source data to use when running carry forward (CopyOpening). This is relative (for example, -1 for prior period). |
|
OWN_CATEGORY |
Category of source ownership data to be used when running consolidation on a simulation category |
|
OWN_YEAR |
Period number of source ownership data to be used when running consolidation on a simulation category. This can be absolute (for example, 12 for December) or relative (for example, -1 for prior period). |
|
OWN_PERIOD |
Year offset of source ownership data to be used when running consolidation on a simulation category. This is relative (for example, -1 for prior year). |
|
RATE_CATEGORY |
Category of source exchange rate data to use when running currency translation on a simulation category |
|
RATE_PERIOD |
Period number of source exchange rate data to use when running currency translation on a simulation category. This can be absolute (for example, 12 for December) or relative (for example, -1 for prior period). |
|
RATE_YEAR |
Year offset of source exchange rate data to be used when running currency translation on a simulation category. This is relative (for example, -1 for prior year). |
|
STARTMNTH |
Starting month. |