Building Alternate Hierarchies in Aggregate Storage Databases

To build shared members in an aggregate storage outline, select the autoconfigure setting in the Dimension Build Settings dialog box in Administration Services, and then make sure that Essbase is set up to allow sharing (clear Do Not Share in the Dimension Build Settings dialog box in Administration Services or omit the Never allow Data Sharing property in the rules file). When autoconfigure is selected and sharing is enabled, Essbase automatically creates duplicate members under a new parent as shared members. See Building Shared Members by Using a Rules File.

Note:

There are restrictions on using the duplicate generation (DUPGEN) method to build alternate hierarchies in aggregate storage outlines. See Table 195, Data Load Differences Between Aggregate Storage and Block Storage.

Caution!

In alternate hierarchies in aggregate storage databases, you can associate attributes only with level-0 members.