Dimensions and members

We have previously discussed that the Essbase database outline is comprised of components called dimensions and members. To quickly review, remember that the outline dimensions are best described as the categories of your data that is, model year, calendar periods, and so on. For you die-hard relational database types, dimensions loosely translate into the columns you use in your tables. Database outline members are the children of the dimensions. The database members and dimensions enjoy a hierarchical parent-child relationship with the dimensions at the highest level.

Dimensions are best used to describe the data in the data warehouse system. Dimensions are the top-most members in the hierarchy. A dimension can represent ...

Get Oracle Essbase 9 Implementation Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.