Chapter Summary
To | Do this |
---|---|
Create a new shared dimension by using the Dimension Editor | In the console tree, expand the desired database and the Library folder. Right-click the Shared Dimensions folder, point to New Dimension, and click Editor. |
Add a new bottom level to a dimension | In the schema pane of the Dimension Editor, double-click the column for the dimension in the appropriate source table. Or drag the column name to the dimension name in the dimension tree. |
Add a new level above an existing level | Drag the column name for the level onto the existing level. |
Browse the rows in a dimension source table | Right-click the caption bar of a source table, and click Browse Data. |
Browse the members of a dimension | Click the Data tab to activate the Preview pane. ... |
Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.