Common Operations on Cubes and their Spotfire Equivalent
Some common operations on cubes have a corresponding action in the Spotfire environment.
| Operation | Explanation | Corresponding Spotfire Equivalent |
|---|---|---|
| Slicing | Slicing is the act of picking a subset of a cube by choosing a single value for one of its dimensions. | In Spotfire, slicing is done by bringing up a filter for the hierarchy and selecting one value.
The fastest way of doing this for a multi-level hierarchy is to bring up the hierarchy filter, select the single value, right-click and choose Deselect Other Values. |
| Dicing | Dicing is the act of picking specific values from dimensions. | Dicing is done by bringing up filters for the hierarchies in question and selecting the specific values in those hierarchies. |
| Drill-down and Drill-up | Drill-down and drill-up are used to navigate among levels of data ranging from the most summarized (up) to the most detailed (down). | This is done by selecting the hierarchy that the levels belong to on a categorical axis and moving the hierarchy slider to the left (drill-up) or to the right (drill-down). |
| Rotating/Pivoting | Rotating (or Pivoting) is the act of changing the dimensional orientation of a report or page display. For example, a rotating operation may consist of swapping the rows and columns, or by moving one of the row dimensions to the column dimension. | In Spotfire, rotating is done by moving the hierarchies to a different categorical axis. |
| Nesting (of multi-dimensional columns and rows) | Nesting is a display technique used to show the results of multiple hierarchies on a column or row.
The column or row labels will display the extra dimensionality of the output by nesting the labels describing the members of each hierarchy. |
Nesting in Spotfire is done by selecting the hierarchies "in nesting order" on a given categorical axis.
The leftmost hierarchy is the top of the nesting and the rightmost hierarchy is at the bottom of the nesting. |