Lesson: Drilling Down on Attribute Members

You can retrieve and analyze data 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.

  To drill down on an attribute dimension:

  1. Open a worksheet.

  2. Select Essbase, and then Retrieve.

    If necessary, connect to the Sample Basic database.

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

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

    An attribute member in a report.

  5. Double-click, or press Alt+S+I, Can in cell C1 to drill down to all products sold in a can.

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

    Result of drilling down on an attribute member.

User Reference

Drill-Down Behavior for Level 0 Attribute Members

Oracle Essbase Database Administrator's Guide