Using the Arc cube viewer

Arc v0.9.5 introduces a new cube viewer to explore your cubes. The new cube viewer supports both native and MDX views.

Native view vs MDX view

A native view is the name of the standard view you have been used to using in TM1 for many years. These views do not support the new multiple hierarchies and are essentially deprecated. Arc supports reading native views but you cannot save a native view.

MDX views were added to TM1 to support multiple hierarchies, these views contain a single MDX statement. The Arc cube viewer is based on MDX, each time you drag/drop a hierarchy or select a set of elements the MDX is updated and executed against the TM1 model.

You can save MDX views with Arc, these views can be used in the newer TM1 interfaces such as PAX and PAW.

Open an existing cubeview

To open a cube view, look for the cube in the menu list, open the view list by clicking on the drill down button and then click on the view name you want to open:

Create a new cube view

To create a new view, just click the [New View] button under the cube name. You can then drag and drop the dimension you need in a title, row or column dimension. Click the execute button in yellow to refresh the view:

Default member of a dimension

You do not need to drag and drop all dimensions in the view to be able to see data. You just need at least one dimension on row and one on column. For all other dimensions which are not part of the view definition, Arc is going to use their default member. To learn how to define a default member for your dimensions, you should look at the following article:

Save view as a new MDX view

When saving a MDX view, Arc also saves the “view definition” as part of the view. If the MDX is updated outside of Arc (or Canvas), you will need to update / edit the MDX manually. Clear the MDX statement to revert to the drag/drop interface.

See the MDX

To access the MDX behind the view, just click the MDX button. Note that you cannot override manually the MDX. To update the MDX query, make some changes in the view and then click again to the MDX button to see the changes: