Analysis Services
Table of contents
- Analysis Services Overview
- What's New in Analysis Services
- Installing Analysis Services
-
Analysis Services Architecture
- Analysis Services Features
- Server and Client Architecture
-
Object Architecture
- Object Architecture Overview
- Analysis Server
- Databases
- Data Sources
- Dimensions
- Levels and Members
- Measures
- Cells
- Cubes
- Partitions
- Aggregations
- Roles
- Commands
- Member Properties
- Data Mining Models
- Data Mining Columns
- Security and Authentication
- Data Warehousing and OLAP
-
Administering Analysis Services
- Before Administering Analysis Services
- Administrative Tools
-
Administrative Tasks
- Configuring Analysis Servers
- Creating Prerequisite Objects for Cubes
- Building and Processing Cubes
- Creating Security Roles
- Managing Partitions
- Enhancing Dimensions with Optional Features
- Enhancing Cubes with Optional Features
- Updating Cubes and Dimensions
- Building and Using Data Mining Models
- Archiving, Restoring, and Copying Data
-
Analyzing and Optimizing Performance
- Analyzing Usage Patterns
- Optimizing Performance Based on Usage
- Optimizing the Data Warehouse Database for Analysis Services Performance
- Optimizing Cube Schemas
-
Monitoring Analysis Services Performance
- Analysis Server:Agg Cache Object
- Analysis Server:Connection Object
- Analysis Server:Last Query Object
- Analysis Server:Locks Object
- Analysis Server:Proc Object
- Analysis Server:Proc Aggs Object
- Analysis Server:Proc Indexes Object
- Analysis Server:Query Object
- Analysis Server:Query Dims Object
- Analysis Server:Startup Object
- Automating and Scheduling Administrative Tasks
-
Administrator's Reference
- Specifications and Limits
- SQL
-
User Interface Help Reference
- Analysis Services Icons
-
Wizards
- Action Wizard
- Calculated Cells Wizard
- Cube Wizard
-
Dimension Wizard
- Introduction (Dimension Wizard)
- Choose How To Create Dimension (Dimension Wizard)
- Select Dimension Table (Dimension Wizard)
- Select the Dimension Type (Dimension Wizard)
- Create Time Dimension Levels (Dimension Wizard)
- Create and Edit Joins (Dimension Wizard)
- Select Levels (Dimension Wizard)
- Specify Member Key Columns (Dimension Wizard)
- Select Columns for Parent-Child Dimension (Dimension Wizard)
- Select Dimension with Member Properties (Dimension Wizard)
- Select Levels for Virtual Dimension (Dimension Wizard)
- Select Advanced Options (Dimension Wizard)
- Set Changing Property (Dimension Wizard)
- Set Custom Rollups (Dimension Wizard)
- Set Members with Data Property (Dimension Wizard)
- Specify Ordering and Uniqueness (Dimension Wizard)
- Specify Storage Mode and Member Groups (Dimension Wizard)
- Set Dimension Writeback Capability (Dimension Wizard)
- Select Mining Model and Predictable Column (Dimension Wizard)
- Finish (Dimension Wizard)
- Incremental Update Wizard
- Mining Model Wizard
- Partition Wizard
- Storage Design Wizard
- Usage Analysis Wizard
-
Usage-Based Optimization Wizard
- Introduction (Usage-Based Optimization Wizard)
- Select Partition (Usage-Based Optimization Wizard)
- Select Queries (Usage-Based Optimization Wizard)
- Review Results (Usage-Based Optimization Wizard)
- Aggregations Already Exist (Usage-Based Optimization Wizard)
- Select Data Storage (Usage-Based Optimization Wizard)
- Set Aggregation Options (Usage-Based Optimization Wizard)
- Finish (Usage-Based Optimization Wizard)
- Virtual Cube Wizard
-
Dialog Boxes
- Advanced Settings Dialog Box
- Analysis Services Processing Task Dialog Box
- Archive Database Dialog Box
- Archive Database Progress Dialog Box
- Calculated Member Builder
- Choose a Dimension Table Dialog Box
- Choose a Fact Table Dialog Box
- Convert to Partition Dialog Box
- Cube Browser
- Cube Cell Security Dialog Box
- Cube Editor - Data View
- Cube Editor - Schema View
- Cube Processing Settings Dialog Box
- Cube Role Dialog Box
- Cube Role Manager
- Custom Dimension Security Dialog Box
- Data Mining Model Browser
- Data Mining Prediction Query Task Dialog Box
- Database Dialog Box
- Database Role Dialog Box
- Database Role Manager
- Define Custom Member Column Dialog Box
- Define Custom Member Options Dialog Box
- Define Unary Operator Column Dialog Box
- Delete Member Dialog Box
- Dependency Network Browser
- Dimension Browser
- Dimension Editor - Data View
- Dimension Editor - Schema View
- Dimension Manager
- Drillthrough Options Dialog Box
- Edit Virtual Dimension Dialog Box
- Filter Expression Dialog Box
- Find Node Dialog Box
- Import Actions Dialog Box
- Import Calculated Cells Dialog Box
- Import Calculated Members Dialog Box
- Import Named Sets Dialog Box
- Insert Level Dialog Box
- Insert Measure Dialog Box
- Insert Member Property Dialog Box
- Join Columns Dialog Box
- Level Naming Template Dialog Box
- Linked Cube Dialog Box
- Map the Column Dialog Box
- MDX Builder
- Mining Model Role Dialog Box
- Mining Model Role Manager
- Merge Partitions Dialog Box
- Multidimensional Data Source Dialog Box
- Named Set Builder
- OLAP Mining Model Editor
- Partition Processing Settings Dialog Box
- Prediction Query Builder
- Process Dialog Box
- Process a Cube Dialog Box
- Process a Dimension Dialog Box
- Process a Mining Model Dialog Box
- Properties Dialog Box
- Relational Mining Model Editor
- Register Analysis Server Dialog Box
- Register Function Libraries Dialog Box
- Remote Server Data Directory Dialog Box
- Restore Database Dialog Box
- Restore Database Progress Dialog Box
- Save Object Dialog Box
- Select Column Dialog Box
- Select Nested Table Key Column Dialog Box
- Select Table Dialog Box
- Select the Parent Member Dialog Box
- Select Users Dialog Box
- Set Default Member Dialog Box
- Training Query Dialog Box
- Virtual Cube Editor
- Write Enable Dialog Box
- OLE DB Compliance
- OLE DB for Data Mining Compliance
-
MDX
- MDX Overview
- Basic MDX
-
Advanced MDX
- Creating and Using Property Values
- Building Named Sets in MDX
- Building Calculated Members in MDX
- Building Caches in MDX
- Building Calculated Cells in MDX
- Creating and Using User-Defined Functions in MDX
- Using Writebacks
- Using DRILLTHROUGH to Retrieve Source Data
- Understanding Pass Order and Solve Order
- Effective MDX
- MDX Functions in Analysis Services
-
How To
- Configuring Analysis Servers
-
Creating Cubes' Prerequisite Objects
- How to create a database
- How to specify a data source
- How to create a shared dimension using the Dimension Wizard
- How to create a shared dimension using Dimension Editor
- How to browse a shared dimension
- How to browse a private dimension
- How to create a virtual dimension based on member properties
- How to create a virtual dimension based on columns
-
Building and Processing Cubes
- How to start the Cube Wizard
- How to build a cube with Cube Editor
- How to create a private dimension
- How to add a multiple-column measure to a cube
- How to start the Virtual Cube Wizard
- How to start the Storage Design Wizard
- How to process a cube
- How to process a virtual cube
- How to view an SQL statement
- How to change the temporary file folder used by Analysis Services
- How to browse sample data in Cube Editor
-
Creating Security Roles
- How to create a database role
- How to create a cube role, change its default values, and specify cell security
- How to create a mining model role and change its default values
- How to create a custom rule for dimension security in a database role
- How to create a custom rule for dimension security in a cube role
- How to create a custom rule for cell security
- Managing Cube Storage
-
Enhancing Dimensions
- How to create a member property in a shared dimension
- How to create a custom rollup operator for a shared dimension
- How to create a custom rollup operator for a private dimension
- How to create or select a column to store custom member formulas
- How to create a custom member formula in a write-enabled dimension
- How to create member groups
- How to create a dimension with multiple hierarchies in the Dimension Wizard
- How to create a dimension with multiple hierarchies in Dimension Editor
- How to add a hierarchy to an existing dimension
-
Enhancing Cubes with Optional Features
- How to create calculated cells
- How to import calculated cells into a virtual cube
- How to edit a calculated cells definition
- How to rename a calculated member
- How to create a calculated member in a regular cube
- How to import a calculated member into a virtual cube
- How to edit a calculated member in a virtual cube
- How to create a calculated member in a virtual cube
- How to create a named set in a regular cube
- How to import a named set into a virtual cube
- How to edit a named set in a virtual cube
- How to create a named set in a virtual cube
- How to create an action in a regular cube
- How to import an action into a virtual cube
- How to edit an action in a virtual cube
- How to create an action in a virtual cube
- How to test an action
- How to write-enable a cube
- How to browse writeback data for a cube
- How to delete writeback data for a cube and write-disable it
- How to convert a cube's writeback data to a partition and write-disable the cube
- How to specify drillthrough options for a regular cube
- How to specify drillthrough options for a virtual cube
- How to specify drillthrough options for a linked cube
- How to specify drillthrough options for a partition
- Updating Cubes and Dimensions
- Managing Data Mining Models
-
Archiving, Restoring, and Copying Data
- How to archive an Analysis Services database using Analysis Manager
- How to archive an Analysis Services database using the msmdarch command
- How to restore an Analysis Services database using Analysis Manager
- How to restore an Analysis Services database using the msmdarch command
- How to copy and paste an object
- Analyzing and Optimizing Performance
- Automating and Scheduling Administrative Tasks