Dimension Types

You use dimension types to organize data within applications based on the type of information involved.

The following table describes the types of dimensions within the system:

Type	Identifier	ID	Description
Account	A	`P_Acct` in a Planning application `C_Acct` in a Consolidation application `O_Acct` in an Ownership application `R_Acct` in a Rate application	Contains your chart of accounts.
Category	C	`Category` in Planning and Rate applications `C_Category` in Consolidation and Ownership applications	Contains the types of data you are going to track, such as Actual, Budget, and Forecast. You can set up categories to store versions, such as BudgetV1, BudgetV2.
Currency	R	`RptCurrency` in a Planning application `Input_Currency` in a Rate application	Contains the currency rates for all currencies in which your company does business. For validation purposes, all application sets must contain a Currency dimension; however, each application within an application set is not required to have a Currency dimension. The Currency dimension in a Reporting application must contain the `REPORTING` property; the Currency dimension in a Rate non-reporting application does not need to contain the `REPORTING` property. For information about reporting and non-reporting applications, see Application Management.
Data Source	D	`P_DataSrc` in a Planning application `C_DataSrc` in a Consolidation application	Used in the business rules of a reporting consolidation application to segregate input data
Entity	E	`Entity` in Consolidation and Ownership applications `P_CC` in a Planning application `R_Entity` in a Rate application	Contains the business units that are used to drive the business process. Depending on your application design, the Entity type can be an operating unit, a cost center, a geographic entity, and so on.
Group	G	`Group` in Consolidation and Ownership applications	Reports consolidated results in multiple group currencies within a single entity structure. Group provides multiple currencies for a group member. Note Assign both an R and a G identifier to a consolidation application but assign only the G identifier to the ownership application referred from the consolidation application. You cannot assign both an R and a G identifier to the same ownership application. End of the note.
Inter-company	I	`IntCo` in Consolidation and Ownership applications	Contains the inter-company codes for the entities
Subtable	S	`Flow`	Breaks down account activity or flow
Time	T	`Time` in all applications	Contains the time periods for which you store data
User-defined	U	`P_Activity` in a Planning application	Referred to in the system as U1, U2, U3, and so on

Note Note

In addition to the dimensions listed above, the system also requires a dimension called Measures. This dimension is included automatically in all application sets. It is not listed as a dimension in the Manage Dimensions task, but is displayed on the Current View bar in Interface for Excel, Interface for Word, and Interface for PowerPoint. The Measures dimension allows you to change the view of your data between Periodic, Quarter-to-date (QTD), Year-to-date (YTD), Halfyear-to-date (HALFYTD) (in Microsoft version only), Month-to-date (MTD), and Week-to-date (WTD).

End of the note.

An application set can have multiple dimensions of one type. Each application within the application set, however, can have only one of each of the required types. For example, the application set might contain the entity dimensions EntityB and EntityF, with the Budgeting application using EntityB and the Forecasting application using EntityF.

More Information

Member Behavior Using Dimension Properties

Application Management