Adding Attribute Dimension Members in Smart View for Office

You create attribute dimensions in the web interface. You can then add members to attribute dimensions using the Admin Extension in Oracle Smart View for Office.

To add members to attribute dimension members:

  1. From the Smart View ribbon, click Panel.
  2. In the Smart View Panel, click Shared Connections or Private Connections, and provide your user name, and password in the login windows.

    If you chose Private Connections, select the private connection in the drop-down list of connections, then provide your login credentials.

  3. From the Smart View Panel, select EPM Cloud.
  4. In the tree in the Smart View Panel, expand the Attribute Dimensions node.

    In the following example, the Attribute Dimensions node contains four attribute dimensions, one for each attribute type: text, date, Boolean, and numeric.


    Smart View Panel showing the folders in the tree for Vision application. The Attribute Dimensions node is expanded to display four attribute dimensions, AttBoolean, AttDate, AttNumeric, and AttText.
  5. Select an attribute dimension, and then select Edit Dimension.

    To illustrate, we selected the AttText attribute dimension to edit. An example of the initial grid for the attribute dimension is shown. This dimension has no members yet, and just two properties, Parent member and Default Alias Table.


    Initial grid for an attribute dimension with no member rows yet, and two property columns, Parent Member and Default Alias Table
  6. Type the attribute member names to add; for example:

    An attribute dimension grid with new members, Gold, Silver, and Platinum, hand-typed in the left column, before the Submit operation. The cells of the three new rows are white; no cell styles applied.
  7. From the Smart View ribbon, click Submit.

    The attribute members are submitted to the application.


    An attribute dimension grid with new members, Gold, Silver, and Platinum, in the left column, after the Submit operation. The rows for the three new members take on the cell styles of member and writeable cells. The attribute members are blue, as are the attribute dimension name and the property column headings. The properties cells for the three new member rows are yellow, meaning they are writeable.
  8. Optional: Continue editing the attribute members, entering data for other properties by typing directly in the grid, and then submit your changes.