Add a Classic view to a book

You can create a Classic view of a cube and add it to a book for ad hoc analysis. A view is also called an Exploration.

Views are automatically saved as a part of the book that they are created in. You can also save a view as a separate Planning Analytics Workspace object with a name, so it can be opened from the Welcome page. You can share the view with other people, and reuse the view in other books.

You can choose to save a view to the TM1® database. When a view is saved to the database, it can be used by TM1 processes as a data source from which you can extract data and create or update objects or data.

A view saved to the TM1 database is available to any Planning Analytics client that connects to the database. .

Procedure

  1. Open a book and enable edit mode.
  2. Open the data tree, then click the menu icon next to the cube that contains the data that you want to view and select Add new view (Classic).
    Add new view (Classic)
    Note: You can also add a view from Views under a cube, or by dragging a view and dropping it on to a cube viewer. If you drag a view on to a cube viewer that is not empty, you can choose to either replace the existing view with the new one, or add the view to the book as a new widget.

    The dimensions in the cube are added to the columns, rows, and to the context area. The last dimension in the cube is added to the columns. The second to last dimension is added to the rows. All other dimensions are added to the context area.

    Sales cube view

    If a private or public set that is called Default exists, the view opens with that set selected in rows, columns, and context positions. If both private and public sets that are called Default exist in a dimension, the private set takes precedence. If no sets called Default exist, all members in the dimension are used in the view in the rows and columns.

  3. Save the view.