Use Model Manager

Use Model Manager to maintain all the elements that make up a model, including cubes and most dimensions.

To use Model Manager, you must have Model Administration permission for at least one cube.

Open Model Manager

  • Click the logo at the top-left corner and select Model Manager.

Cubes

Create a cube

  1. In the left-side panel, click Create New Cube.
  2. In the main panel, define the cube.

Delete a cube

 Note:  If the cube that you want to delete has unpublished revisions, they must be published before the cube can be deleted.

  1. Select Actions > Delete Cube.
  2. From the drop-down, select the Cube.
  3. Do you want to retain model definition and assets?:  
    • Yes: Select to delete the cube and all its data but keep the model definition, including dimension tables, filter definitions, Cell Comment tables, Line Item tables, and related documents; confirm your decision.

    • No: Select to delete the cube including all its data and the model definition; confirm your decision.

       Note:  Any dimension definitions and filters that are shared with another cube (that is running) will not be deleted. (Shared dimensions are indicated by .)

  4. (Option enabled if you chose No for the previous option) Do you want to retain dimension definitions for future use?:
    • Yes: Select to delete the cube and all its data but keep the model definition, including dimension tables, filter definitions, Cell Comment tables, Line Item tables, and related documents; confirm your decision.
    • No: Select to delete the cube including all its data and the model definition, and to orphan any related documents; confirm your decision.
  5. Click Delete.

 Note:  By default, dimensions and dimension tables in other cubes connected to this cube will be deleted; if this is not what you want, clear these options.

Dimensions

Show the dimensions in a cube

  • In the left-side panel, click <cube name>.

Open a dimension

  • Beneath the cube, click the dimension name.

    The middle panel appears and shows the member hierarchy.

    The number at the end of the title bar shows the member count (including the "root" member).

Get information on a dimension.

  • Select View >  Dimension Definition.

See the properties for a dimension member

  • Select the member in the hierarchy.

    The panel on the right shows the properties of that member (and custom properties, if any).

    Each dimension type has its own properties.

Open the dimension controls

  • To show/hide the dimension controls, click anywhere in the "lip" located between the dimension title bar and its structure:

Show the cubes that share a dimension

  • Beside the dimension name, click .

Switch to an alternate hierarchy

  • In the hierarchy panel, select from the drop-down:

Members

Select dimension members

  • To select a member, click it.
  • To select a range, Shift+ click.
  • To select non-adjacent members, Ctrl+ click.

Add a member to a dimension

  1. Select the dimension.
  2. Select the member that you want as the parent.
  3. In the lip click .
  4. Type a Key (up to 40 characters and unique) and a Name (up to 256 characters)
  5. Click OK.
  6. Use the Member Properties panel to complete the member definition.
  7. Save.

Restrictions on adding members

In Model Manager you can't add members to, or edit, the following dimensions:

Set the Default member for a dimension

  1. Select the dimension.
  2. In the dimension hierarchy, select the .DefaultMember node.
  3. In the Member Properties panel, click
  4. Use Selector to choose a member.

Cut and paste members

  1. Select one or more members from the same level in the hierarchy.
  2. Click to cut your selection.
  3. Select a new location.

  4. Click to paste your selection.

     Tip:  You can also drag-and-drop a selection of members.

Specify a calculation method for a member

You use calculation methods to determine how an account's value is derived, including copying values from other cubes.

Delete a member

  1. Select the dimension.
  2. Select the member.

  3. In the lip click , and confirm your decision.

     Caution:  When you delete a parent, its children are also deleted.

Search/Sort

Turn on member search.

  • Select View >  Find Member.

    The search bar opens beneath the lip.

Search for members

  1. Type a name and/or key in the search bar and click . (Searches are case insensitive.)
  2. To continue the same search, click .

Set the sort order for the dimension default hierarchy

  1. Select Options and click .

  2. From Order members by, select a sort option.

     Note:  This option is not available for level-based dimensions.

Member Properties

Add a note to a member

  • The Note property can contain up to 1,000 characters.

Add a custom property to a member

  1. Do one of the following:
    • Select the member and in the lip click .
    • To create the property based on a new database column, click > Add new.
    • To create the property based on an existing database column, click > Add using existing column.
  2. Complete the details.
  3. Click OK.

Save

Save your changes

  • Select File > Save Dimension.

     Note:  This command saves your edits but does not send them to the cube (and thus does not interrupt access to the cube for other users). To update the cube with your changes, you use the Publish command.

 

Autosave

Model Manager also has an Autosave feature. Changes you make to the data are automatically saved when you perform either of the following actions:

  • Select a different dimension.
  • Open the Publish dialog (select Actions > Publish).

Undo changes

The changes that you make to dimensions in Model Manager are automatically recorded and are known as revisions.

  1. Select a model and a dimension.

  2. Select View > Revisions.

    The Revisions dialog opens.

  3. To get more information about a change, click .

  4. To restore a revision: 

     Note:  Any revisions that are more recent than the selected revision are also restored. Note as well that all changes contained in a revision are restored.

    • Select the revision that you want to restore.
    • Click Restore.
    • Click Yes.

Alternate hierarchies

Manage alternate hierarchies

  • In the lip click .

    The Alternate Hierarchies Editor opens.

     Note:  Only certain dimensions can have alternate hierarchies.

Publish

See the publish state of your cubes

Select Actions > Publish. The icons show the state of each cube as follows:

  • Publish Not Required: No revisions exist; the cube is up-to-date.
  • Publish Required: Revisions exist and have not yet been published.
  • Running: The publish process is under way.

  • Pending: The publish process is waiting to run.

    At any time, to update the statuses, click .

Publish to a cube

  1. Select Actions > Publish,

  2. Beside the cube name click .

    The Confirm dialog opens, showing a graphical analysis of all the cubes and dimensions that the operation will affect.

  3. To publish, click Yes.

 Tip:  Process Manager also provides a Publish process, which you can run on a schedule.