O'Reilly logo

Oracle Essbase 9 Implementation Guide by Joseph Sydney Gomez, Sarma Anantapantula

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Types of dimensions

In Essbase, there are two types of dimensions, the first and most common dimension type is the Standard dimension. The other less common dimension type is called an Attribute dimension. Both are explained here.

Standard dimension

Standard dimensions are derived from the main business data components (or data categories we described earlier) and are then defined in a database cube. Some of the Standard dimensions in our example database are: TOTAL VEHICLES, MEASURES, CALENDER PERIODS, TOTAL MODEL YEARS, CUSTOMERS, MARKET, and SCENARIO. These dimensions can be tagged as Accounts, Time, and Country types. Some dimensions are not associated with any type of special dimension types and are considered general dimensions.

Briefly, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required