Arc cube viewer use a modern grid component which gives you the Excel like editing features and can copy/paste from Excel. In this article we cover the most important Arc cube viewer features.
Support Native and MDX views
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:
Copy paste values from Excel
Just copy any data from Excel with CTRL+C and paste it into the cube viewer with a simple CTRL+P:
Copy paste values to Excel
Select any data range from your cube view hit CTRL+C to copy the data, go to Excel and hit CTRL+P to paste your data:
Drag values across multiple cells
Drag down any cells to copy the data across multiple cells:
Find any element
The Arc cube viewer has a Find box where you can find any element on the rows:
When you click on a cell which contains a rule, a blue button will appear in the cube viewer toolbar, click on it to trace the calculation:
Click on any column headers to sort the rows by values:
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: