Inserting Attribute Dimensions on the Sheet--Example
Data source types: Oracle Analytics Cloud - Essbase, Planning Ad Hoc
Using Essbase Sample Basic, from the Action Panel, select Ad hoc analysis to place dimensions, including page dimensions, on the worksheet, as shown in Figure 8-1.
Figure 8-1 Initial Ad Hoc Grid
![Using Sample Basic, shows worksheet after performing initial ad hoc analysis command. Product, Market, and Scenario are the page dimensions, Measures and Year are the dimensions in the ad hoc grid. Using Sample Basic, shows worksheet after performing initial ad hoc analysis command. Product, Market, and Scenario are the page dimensions, Measures and Year are the dimensions in the ad hoc grid.](img/adhoc_stacked_mbrs1.jpg)
Now click Insert Attributes, .
In the Insert Attributes dialog box, note that all attribute dimensions are selected by default:
![Insert Attributes dialog listing all attribute dimensions, a check box next to each attribute dimension name, and a Member Selection button where you can select individual attribute members to add as page dimension on the sheet. Insert Attributes dialog listing all attribute dimensions, a check box next to each attribute dimension name, and a Member Selection button where you can select individual attribute members to add as page dimension on the sheet.](img/ins_attrib_dialog.jpg)
Click OK and you can see, as shown in Figure 8-2, that the attribute dimensions Caffeinated, Ounces, Pkg Type, Population, and Intro Date have been added to the worksheet as page dimensions.
Figure 8-2 Ad Hoc Grid After Adding Attribute Dimensions
![Ad hoc grid with attribute dimensions added as page dimensions to the first row of the sheet. Ad hoc grid with attribute dimensions added as page dimensions to the first row of the sheet.](img/after_insert_attribs.jpg)
You can also choose to add attribute members, instead of attribute dimensions, to the sheet. In the Insert Attributes dialog box, click for an attribute dimension and select an attribute member to use.
In the Insert Attributes dialog box, notice that the attribute dimensions Caffeinated, Pkg Type, and Populations, the attribute members Caffeinated_True, Bottle, and Medium are selected:
![Insert Attributes dialog listing all attribute dimensions, a check box next to each attribute dimension name, and a Member Selection button where you can select individual attribute members to add as page dimension on the sheet. This dialog shows three attribute members selected along with two attribute dimensions. Insert Attributes dialog listing all attribute dimensions, a check box next to each attribute dimension name, and a Member Selection button where you can select individual attribute members to add as page dimension on the sheet. This dialog shows three attribute members selected along with two attribute dimensions.](img/ins_attrib_dialog_attribs.jpg)
In Figure 8-3, notice that the attribute members Caffeinated_True, Bottle, and Medium, along with the Ounces and Intro Date attribute dimensions, have been added to the worksheet as page dimensions.
Figure 8-3 Ad Hoc Grid After Adding Attribute Members and Dimensions
![Ad hoc grid with attribute members Caffeinated_True, Bottle, and Medium added to the sheet as page dimensions, along with attribute dimensions Ounces and Intro Date. Ad hoc grid with attribute members Caffeinated_True, Bottle, and Medium added to the sheet as page dimensions, along with attribute dimensions Ounces and Intro Date.](img/after_insert_attrib_mbrs.jpg)
See also Notes About Inserting Attributes.