Inserting Attribute Dimensions on the Sheet--Example

Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud Ad Hoc

Using Oracle 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

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.

Now click Insert Attributes, Insert Attributes button on Essbase ribbon .

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.

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

Ad hoc grid with attribute dimensions added as page dimensions to the first row of the sheet.

You can also choose to add attribute members, instead of attribute dimensions, to the sheet. In the Insert Attributes dialog box, click The Member Selection button in the Insert Attributes dialog box 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

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.