Allowing duplicate member names

In Essbase 7.x and earlier versions, each outline member had a unique name and duplicate member names were not allowed. But in System 9, duplicate member names are allowed. If you want to have duplicate member names in your system, please make sure you check the ALLOW DUPLICATE MEMBER NAMES while creating the Essbase database.

Many people scratch their heads and wonder why you would want to allow duplicate member names in your database outline. Well, one example would be the city of New York and the state of New York. You may want to have New York in your outline as one state of the United States and then you may want to have New York in your outline as a city of New York state.

Tip

A standard existing database outline ...

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.