Function documentationDimension Types Locate this document in the navigation structure

 

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

The following table describes the types of dimensions within BPC:

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. The Account dimension must include the GROUP property when used for legal consolidation.

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.

Entity

E

  • Entity in Planning, Consolidation, and Ownership applications

  • 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.

Time

T

Time in all applications

Contains the time periods for which you store data.

Currency

R

  • RptCurrency in a Planning application

  • Input_Currency in a Rate application

  • Groups in Consolidation and Ownership applications

Contains the currency rates for all currencies in which your company does business. For validation purposes, a Currency dimension must be present in all application sets, however one does not have to be part of any applications within the application set.

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 on reporting and non-reporting applications, see Application Management.

Intercompany

I

IntCo in Consolidation and Ownership applications

Contains the Intercompany codes for the entities.

User-defined

U

N/A

Referred to in the system as U1, U2, U3, and so on.

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.

Subtable

S

N/A

Breaks down account activity or flow.

Note Note

In addition to the dimensions listed above, BPC 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 BPC for Excel. The Measures dimension allows you to change the view of your data between Periodic, Quarter-to-date (QTD), Year-to-date (YTD), 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.