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.
The general guidelines for drilling down on level 0 attributes are:
If a level 0 attribute member is in a column, a drill down pivots the attribute to the innermost row of the worksheet.
If a level 0 attribute member is in a row, a drill down does not change the position of the attribute in the worksheet.
A drill down on a level 0 attribute member displays the associated base members to the right of the level 0 attribute.
If the worksheet contains multiple level 0 attribute members, a drill down on one attribute displays other attributes to the left of the level 0 attribute member. Level 0 attribute members in the columns pivot to rows, and level 0 attribute members in rows remain in a row.
A drill down on non-level 0 attribute members matches the current drill down behavior for other types of members.
These scenarios are typical of those using level 0 attribute members: