Retrieving Attribute Dimensions in Free-Form Mode

Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase

In structured grid processing operations, attribute dimensions are not shown. In free-form, you can type an attribute dimension member in the grid and it will be processed and validated. Only the attribute dimension member that you added will be displayed and used during processing and validation; the remaining attribute dimension members will not be included. Structured grid operations that follow this free-form request will retain the attribute dimension member.

If the base dimension exists in the worksheet, you can also retrieve an attribute member by typing the name directly in the worksheet.

To retrieve an attribute dimension in free-form using Member Selection:

  1. In a blank worksheet, select a cell.(The worksheet must be blank.)
  2. From the data source ribbon, select Member Selection.
  3. In the Dimension Name Resolution dialog box, select the attribute dimension.
  4. To orient members vertically in the worksheet starting from the cell you selected in step 3, select the Vertical Orientation check box.

    This check box is cleared by default; meaning that members will be oriented horizontally across the sheet from the cell you selected in step 3.

  5. Click OK to launch the Member Selection dialog box.
  6. Select the members to place on the worksheet.

    Note:

    You can also add attribute dimensions and members to the sheet.