Inserting Attribute Dimensions on the Sheet--Example

Data source types: Oracle 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 10-1.

Figure 10-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, .

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 10-2, that the attribute dimensions Caffeinated, Ounces, Pkg Type, Population, and Intro Date have been added to the worksheet as page dimensions.

Figure 10-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 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 10-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 10-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.