Level 0 Attribute Drill-Down Behavior - Scenario D

In this scenario, base dimension (Product) and level 0 attribute member (Caffeinated_True) are in a column. A drill down on Caffeinated_True pivots it to a row. Product pivots to the right of the row and displays its members associated with Caffeinated_True.

Before drill down: Caffeinated_True and its base dimension (Product) are in the columns of the worksheet.

Caffeinated_True in column F and Product in column C.

After drill down: Caffeinated_True and Product pivot to a row. 100-10, 100-20, 200-10, 200-20, 300-10, 300-20, and 300-30 (members of Product with the Caffeinated_True attribute) are displayed in the column next to Caffeinated_True.

Caffeinated_True in row 2 with Product in row 9 and members in column B.