Viewing Dimension Properties
Using the Insert Properties command in the Essbase ribbon, you can quickly view the properties of a dimension in an ad hoc grid.
- Ensure that you are working with an ad hoc grid connected to Oracle Analytics Cloud - Essbase.
- In the Essbase ribbon, select Insert Properties.
The Select Properties dialog is displayed, listing the available properties for the dimension.
- Using the check boxes, select the properties to view on the grid, as shown in Figure 4-9.
Alternatively, click Select All to select all dimension properties.
Figure 4-9 Select Properties Dialog Showing Several Properties Selected
- Click OK.
The selected dimension properties and their values are displayed in the columns to the left of the selected dimension. In the grid, the dimension properties column headings are designated as follows:
Dimension Name:Property Name
In an example scenario, in the following grid, we select Account in cell A3:
Then click Insert Properties, making the selections shown in Figure 4-9.
The dimension properties are inserted in the columns to the left of the ad hoc grid. The ad hoc grid now starts in column E. Columns A through D contain the dimension property information.
You may continue working with the grid using ad hoc commands, such as Zoom In and Keep Only, while the dimension properties are displayed, as long as the properties have been inserted to the left of the grid.
This feature will be supported in an upcoming release of Oracle Analytics Cloud - Essbase.
Additionally, administrators must set up the database in Oracle Analytics Cloud - Essbase for dimension property viewing in Oracle Smart View for Office.
- Optional: After viewing the dimension properties, you may delete the columns containing the dimension properties and still continue working in the ad hoc grid.