Home Page Icon
Home Page
Table of Contents for
Start the Lesson
Close
Start the Lesson
by Reed Jacobson, OLAP Train
Microsoft® SQL Server™ 2000 Analysis Services Step by Step
Copyright
Preface
Acknowledgments
Administration Fundamentals
A Data Analysis Foundation
Understanding Data Warehousing
The Structure of a Data Warehouse
Understanding Analysis Services
Chapter Summary
Analysis Manager from 500 Feet
Previewing Analysis Manager
Preparing to Create a Cube
Designing a Cube by Using the Cube Wizard
Processing and Browsing a Cube
Chapter Summary
Dimension and Cube Editors
Start the Lesson
Working with a Standard Star Schema Dimension
Working with a Standard Snowflake Dimension
Working with Time Dimensions
Working with a Cube
Working with Measures in a Cube
Specify the Aggregation Function for a Measure
Working with a Parent-Child Dimension
Chapter Summary
Advanced Dimensions and Cubes
Start the Lesson
Creating a Finance Cube
Creating an Internet Tracking Cube
Creating a Forecast Cube
Creating Virtual Cubes
Chapter Summary
Office 2000 Analysis Components
Start the Lesson
Creating an Excel PivotTable Report
Creating an Office PivotTable List
Creating a Local Cube
Chapter Summary
Multidimensional Expressions
MDX Values
Start the Lesson
Creating Simple MDX Expressions
Retrieving Values from Cells
Calculating Relative Contribution
Comparing Values over Time
Chapter Summary
MDX Sets
Start the Lesson
Preparing to Create MDX Queries
Creating Basic MDX Queries
Creating Calculations by Using Aggregation Functions
Chapter Summary
Advanced Administration
Storage Optimization
Start the Lesson
Specifying Options for Optimizing Storage
Managing the Pool of Potential Aggregations
Chapter Summary
Processing Optimization
Start the Lesson
Understanding OLAP Processing
Managing OLAP Processing
Working with Partitions
Automating the Processing of a Database
Chapter Summary
Dimension Optimization
Start the Lesson
Optimizing Dimensions in a Cube
Creating Virtual Dimensions
Chapter Summary
Security
Start the Lesson
Creating Security Roles
Applying Security to a Dimension
Applying Cell-level Security to a Cube
Chapter Summary
About the Authors
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Storage Optimization
Next
Next Chapter
Specifying Options for Optimizing Storage
Start the Lesson
1.
Start Analysis Manager, right-click the server, click Restore Database, and restore the Chapter 8 OLAP database.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset
