Drilling Down on Level 0 Attributes

You can use the Essbase attribute feature to retrieve and analyze in terms of characteristics, or attributes, of dimensions. For example, you can analyze product profitability based on the attributes of size or packaging. Attribute dimensions are associated with base dimensions.

You can use an attribute dimension to drill down on the base dimension with which it is associated. In the Sample Basic database, the Product base dimension is associated with several attribute dimensions, such as Caffeinated, Ounces, and Pkg_Type. Each attribute dimension consists of level 0 attribute members. Level 0 attribute members are the lowest level attributes that are associated with members of a base dimension. The Pkg_Type attribute dimension, for instance, contains two level 0 members, Bottle and Can.

You can extract information on all products sold in a can by entering manually the name Can in the worksheet. You can also use Query Designer or the Essbase Member Selection dialog box to select the attribute and display it in the worksheet.

  To drill down on an attribute dimension:

  1. Open a worksheet.

  2. Connect to the Sample Basic database.

  3. Select Essbase, and then Retrieve.

  4. Select Product and, to replace it, enter Can.

  5. Click anywhere outside of cell C1 and select Essbase, and then Retrieve.

  6. Drill down to all products sold in a can by double-clicking Can in cell C1.

    Cola, Diet Cola, and Diet Cream are the members of Product with the Can attribute.

See Also