Drill-Down Behavior for Level 0 Attribute Members

Drilling down on level 0 attributes produces results that differ from other types of drill-down actions in Spreadsheet Add-in. Level 0 attribute members are the lowest level attributes that are associated with members in a base dimension. A base dimension can be associated with several attribute dimensions. An attribute dimension is associated with a base dimension. For example, in the Sample Basic database, Caffeinated is an attribute dimension associated with the base dimension Product. Caffeinated_True and Caffeinated_False are level 0 attribute members of the Caffeinated attribute dimension.

Currently, every dimension in the database must be represented in the worksheet before you can retrieve data. Attribute dimensions and their members can represent their base dimension in the worksheet. When you retrieve into a blank worksheet, the default layout displays the standard dimensions in the database, such as Product, Year, Market, Measures, and Scenario in the Sample Basic database.

To view an attribute in the worksheet, enter its name manually or use Query Designer or the Essbase Member Selection dialog box to select the attribute and display it in the worksheet.

Note:

Sampling does not support drill down on level 0 attribute members.

The general guidelines for drilling down on level 0 attributes are:

These scenarios are typical of those using level 0 attribute members: