Essbase - (Accounts|Measures) Dimensions

Essbase Overview

About

Accounts dimensions are dimension that contains items that you want to measure, and makes Essbase built-in accounting functionality available.

Accounting classifications.

Ex:

  • income
  • expense
  • profit
  • inventory

Ex static Account:

  • unit
  • price
  • sales

Calculations

For a dimension tagged as accounts dimension, you have two types of calculations :

Rules when tagging a dimension as accounts

  • You can tag only one dimension in an outline as accounts.
  • All members in the accounts dimension inherit the accounts property.
  • You can specify that members of the accounts dimension are calculated on the second pass through an outline.
  • You can create an outline that does not have an accounts dimension.





Discover More
Essbase Outline
Essbase - Dimension

in Essbase. A dimension represents the highest consolidation level in the database outline. The database outline presents dimensions and members in a tree structure to indicate a hierarchy relationship....
Essbase Overview
Essbase - Standard dimensions

Standard dimensions represent the core components of a business plan and often relate to departmental functions. Typical standard dimensions: : Time, Accounts (The Measure dimension), Scenario...
Essbase Overview
Essbase - Time balance properties

The tags : first, last, average, and expense are available exclusively for use with accounts dimension members. Using this tag requires an accounts dimension and a time dimension If an...
Tbc Measures Dimension
Essbase - Two-Pass Calculations

This label indicates that some member must be calculated twice to produce the desired value. The two-pass property works only : on members of the dimension tagged as account and on members tagged...
Essbase Overview
Essbase - Variance Reporting

Variance reporting properties determine how Essbase calculates the difference between actual and budget data in a member with the @VAR or @VARPER function in its member formula. Any member that represents...



Share this page:
Follow us:
Task Runner