Inserting Attribute Dimensions on the Sheet--Example
Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud 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 6-1.
Figure 6-1 Initial Ad Hoc Grid
Now click Insert Attributes, .
In the Insert Attributes dialog box, note that all attribute dimensions are selected by default:
Click OK and you can see, as shown in Figure 6-2, that the attribute dimensions Caffeinated, Ounces, Pkg Type, Population, and Intro Date have been added to the worksheet as page dimensions.
Figure 6-2 Ad Hoc Grid After Adding Attribute Dimensions
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:
In Figure 6-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 6-3 Ad Hoc Grid After Adding Attribute Members and Dimensions
See also Notes About Inserting Attributes.