Some common operations on cubes have a corresponding action in the Spotfire environment.
Option |
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 multidimensional 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. |
See also: