Chapter Summary

ToDo this
View metadata information for an object in Analysis ManagerSelect the object in the console tree, and click the Meta Data tab in the right pane.
Run a menu command in Analysis ManagerEither select an object in the console tree and click the Action menu, or right-click an object in the console tree.
Create a new databaseRight-click the server in the console tree, and click New Database. Type a name for the database, and click OK.
Create a new data sourceRight-click the Data Sources folder in the library of a database, and click New Data Source. Select the OLE DB provider. Activate the Connection tab, and specify a data source. Then click OK.
Create a cube by using the Cube WizardRight-click the Cubes folder in a database, point to New Cube, and click Wizard.
Create a new dimension from within the Cube WizardOn the add dimension screen of the Cube Wizard, click the New Dimension button.
Add a join between snowflaked dimension tablesDrag the column name from one table to another.
Delete a join between two tablesSelect the join, and press Delete.
Add a new level to a dimension in the Dimension WizardDouble-click the name of a column in the dimension table.
Create a dimension hierarchy from a Date/Time columnSelect a dimension table that contains at least one Date/Time column. Select Time as the dimension type, and select the Date/Time column.
Process a cubeIn the console tree, right-click the cube and click Process.
Browse data in a cubeIn the console tree, right-click the cube and click Browse Data.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.136.97.64