Viewing the Xcelerator cube
Use the Server Explorer window to view the new cube.
Steps
1. In the Server Explorer window, click Cubes to expand the tree.
2. Double-click the new cube you created.
3. In the Cube Viewer window, click the Recalculate button on the toolbar.
The new cube appears with its default configuration. You can re-arrange the dimensions to
suit your needs and preferences by dragging and dropping them within the Cube Viewer window.
For example, you may want to:
● Put the month dimension in the column area for a traditional annual budget collection
perspective.
● Put more than one dimension on the rows or columns. This is called stacking, and allows
you to compare large amounts of information in a concise format.
● Move dimensions to the title dimension area of the Cube Viewer window.
4. Click on a dimension in a row or column to expand or collapse the dimension hierarchy.
Dimensions that appear in the title area can have only one element selected, whereas dimensions
on rows or columns can display hierarchies that you can interactively expand or collapse.
Experiment with navigating and expanding the hierarchies to view leaf-level cells. Leaf-level cells
are white instead of gray, indicating that the cell is editable. Only leaf-level cells are editable in an
Xcelerator cube.
You can also try re-arranging the dimensions in the view.
For more information about working with cubes and dimensions in Xcelerator, see the IBM Cognos
Express Xcelerator User Guide and IBM Cognos TM1 Developers Guide.
--
BI CENTRE
http://bicentre.blogspot.com
