documentation
.HELP!
Analysis Services Documentation
Variance
Analysis Services
previous page
next page
Analysis Services
Variance
Alias for
Var
.
See Also
Var
previous page
start
next page
Menu
Homepage
Table of contents
Analysis Services Overview
What's New in Analysis Services
Cube Enhancements
Dimension Enhancements
Data Mining Enhancements
Security Enhancements
Client Connectivity Enhancements in PivotTable Service
Other Enhancements
Installing Analysis Services
Hardware and Software Requirements for Installing Analysis Services
Running Setup
Setup Parameters and Silent Installation
Reinstalling Analysis Services
Stopping or Removing Analysis Services
Upgrading from an Earlier Version
Backward Compatibility
7.0 Analysis Services Client and Local Cube Support
Supported Migration Paths for Analysis Services Repositories
Archiving and Restoring Databases Between Versions of Analysis Services
Analysis Services Architecture
Analysis Services Features
Ease of Use
Flexible Data Model
Scalability
Integration
Widely Supported APIs and Open Architecture
Server and Client Architecture
Server Architecture
Client Architecture
Object Architecture
Object Architecture Overview
Analysis Server
Databases
Data Sources
Dimensions
Introduction to Dimensions
Dimension Structure
Dimension Storage Modes
Dimension Processing
Dimension Hierarchies
Ragged Dimension Support
Dimension Characteristics
Shared and Private Dimensions
Changing Dimensions
Dependent Dimensions
Write-Enabled Dimensions
Balanced and Unbalanced Hierarchies
Ragged Hierarchies
Dimension Varieties
Regular Dimensions
Virtual Dimensions
Virtual Dimensions Created in Version 7.0
Parent-Child Dimensions
Data Mining Dimensions
Levels and Members
(All) Level and All Member
Data Members
Member Names and Member Keys
Custom Rollup Operators
Custom Rollup Formulas and Custom Member Formulas
Member Groups
Measures
Aggregate Functions
Using Aggregate Functions
Display Formats
Cells
Cell Properties
Calculated Cells
Cubes
Introduction to Cubes
Cube Structure
Cube Storage
Cube Processing
Cube Varieties
Regular Cubes
Linked Cubes
Distributed Partitioned Cubes
Virtual Cubes
Local Cubes
Real-Time Cubes
Write-Enabled Cubes
Partitions
Introduction to Partitions
Partition Structure
Partition Storage
Indexed Views for ROLAP Partitions
Remote Partitions
Incremental Updates and Partitions
Aggregations
Roles
Database Roles
Cube Roles
Mining Model Roles
Commands
Actions
Calculated Members
Named Sets
Library Registrations
Member Properties
Multiple Language Implementation Using Member Properties
Data Mining Models
Introduction to Data Mining Models
Data Mining Model Structure
Data Mining Algorithms
Microsoft Decision Trees
Microsoft Clustering
Data Mining Model Nodes
Data Mining Model Storage
Data Mining Columns
Data Mining Column Data Types
Data Mining Column Content Types
Nested Data Mining Columns
Data Mining Column Storage
Security and Authentication
Administrator Security
End-User Security
User Accounts and Groups
Database, Cube, and Mining Model Roles
Levels of End-User Security
Server Security and Authentication
Authentication Methods
Authentication of Direct Connections
Authentication of Connections
Database Security
Cube Security
Dimension Security
Custom Rules in Dimension Security
Multiple Custom Rules in Dimension Security Applied to an End User
Cell Security
Custom Rules in Cell Security
Mining Model Security
Operational Considerations
Data Warehousing and OLAP
About Data Warehouses
About OLAP
OLAP and Data Warehouses
Maintaining OLAP Data
Administering Analysis Services
Before Administering Analysis Services
Administrative Tools
Analysis Manager
MMC
Starting Analysis Manager
The Analysis Manager Tree Pane
Using Active Directory with Analysis Services
Using Data Transformation Services with Analysis Services
Using MDX with Analysis Services
Msmdarch Command
Administrative Tasks
Configuring Analysis Servers
Registering Servers
Setting Server Properties
Migrating Analysis Services Repositories
Creating Prerequisite Objects for Cubes
Creating Databases
Specifying Data Sources
Creating Shared Dimensions
Creating a Shared Dimension with the Wizard
Creating a Shared Dimension with the Editor
Creating Virtual Dimensions
Viewing Dimension Data
Building and Processing Cubes
Building Cubes
Building a Cube with the Wizard
Building a Cube with the Editor
Creating and Maintaining Private Dimensions
Adding a Multiple-Column Measure to a Cube
Building a Virtual Cube
Building a Linked Cube
Building a Distributed Partitioned Cube
Building a Real-Time Cube
Designing Storage Options and Aggregations
Processing Cubes
Managing Linked Cubes
Viewing Cube Data
Browsing Cube Data
Browsing an Unprocessed Cube
Creating Security Roles
Creating Database Roles
Creating Cube Roles
Creating Mining Model Roles
Defining Custom Rules for Dimension Security
Defining Custom Rules for Cell Security
Managing Partitions
Creating Partitions
Different Fact Tables for Partitions
Same Fact Table for Multiple Partitions
Data Slice
Merging Partitions
Fact Table Considerations When Merging Partitions
Merging Partitions That Have Data Slices
Enhancing Dimensions with Optional Features
Creating Member Properties
Using Custom Rollup Operators
Creating Custom Member Formulas
Creating Member Groups
Creating Dimensions with Multiple Hierarchies
Adding Hierarchies to Existing Dimensions
Enhancing Cubes with Optional Features
Creating Calculated Members
Creating Calculated Members in Regular Cubes
Creating Calculated Cells
Creating Calculated Cells in Regular Cubes
Creating Calculated Cells in Virtual Cubes
Creating and Maintaining Calculated Members in Virtual Cubes
Importing a Calculated Member into a Virtual Cube
Editing a Calculated Member in a Virtual Cube
Creating a Calculated Member in a Virtual Cube
Creating Named Sets
Creating Named Sets in Regular Cubes
Creating and Maintaining Named Sets in Virtual Cubes
Importing a Named Set into a Virtual Cube
Editing a Named Set in a Virtual Cube
Creating a Named Set in a Virtual Cube
Creating Actions
Creating Actions in Regular Cubes
Creating and Maintaining Actions in Virtual Cubes
Importing an Action into a Virtual Cube
Editing an Action in a Virtual Cube
Creating an Action in a Virtual Cube
Maintaining Write-Enabled Cubes and Writeback Data
Write-Enabling a Cube
Browsing Writeback Data
Deleting Writeback Data and Write-Disabling a Cube
Converting Writeback Data to a Partition
Specifying Drillthrough Options
Updating Cubes and Dimensions
Updating and Refreshing Cube Data
Updating and Rebuilding Dimensions
Updating and Rebuilding Shared Dimensions
Updating and Rebuilding Private Dimensions
Building and Using Data Mining Models
Creating Data Mining Models
Creating Relational Data Mining Models
Creating OLAP Data Mining Models
Editing Data Mining Models
Editing Relational Data Mining Models
Editing OLAP Data Mining Models
Training Data Mining Models
Viewing Data Mining Models
Viewing with Data Mining Model Browser
Viewing with Dependency Network Browser
Advanced Data Mining Model Operations
Using Roles in Data Mining Models
Archiving, Restoring, and Copying Data
Archiving and Restoring Databases
Archiving an Analysis Services Database
Restoring an Analysis Services Database
Copying and Pasting Objects
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
Processing Objects Using Data Transformation Services
Creating an Analysis Services Processing Task
Adding Connections and Other Tasks to the Package
Changing Properties of an Analysis Services Processing Task
Creating Predictions Using Data Transformation Services
Administrator's Reference
Specifications and Limits
SQL
Partition Filters and Incremental Update Filters
Dimension Filters
Drillthrough Filters
User Interface Help Reference
Analysis Services Icons
Analysis Manager Icons
Cube Editor Icons
Dimension Browser Icons
Dimension Editor Icons
OLAP Mining Model Editor Icons
Relational Mining Model Editor Icons
Virtual Cube Editor Icons
Wizards
Action Wizard
Introduction (Action Wizard)
Select Target (Action Wizard)
Select the Action Type (Action Wizard)
Define the Action Syntax (Action Wizard)
Finish (Action Wizard)
Calculated Cells Wizard
Introduction (Calculated Cells Wizard)
Define the Calculation Subcube (Calculated Cells Wizard)
Define the Calculation Condition (Calculated Cells Wizard)
Define the Calculation Formula (Calculated Cells Wizard)
Finish (Calculated Cells Wizard)
Cube Wizard
Introduction (Cube Wizard)
Select a Fact Table (Cube Wizard)
Define Measures (Cube Wizard)
Select Dimensions (Cube Wizard)
Finish (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
Introduction (Incremental Update Wizard)
Select Partition (Incremental Update Wizard)
Specify Data Source and Fact Table (Incremental Update Wizard)
Create Filter Expression (Incremental Update Wizard)
Finish (Incremental Update Wizard)
Mining Model Wizard
Introduction (Mining Model Wizard)
Select Source Type (Mining Model Wizard)
Relational Model Steps (Mining Model Wizard)
Select Case Tables (Mining Model Wizard)
Select Data Mining Technique (Mining Model Wizard)
Create and Edit Joins (Mining Model Wizard)
Select the Key Column (Mining Model Wizard)
Select Input and Predictable Columns (Mining Model Wizard)
OLAP Model Steps (Mining Model Wizard)
Select Source Cube (Mining Model Wizard)
Select Data Mining Technique (Mining Model Wizard)
Select Case (Mining Model Wizard)
Select the Predicted Entity (Mining Model Wizard)
Select Training Data (Mining Model Wizard)
Create a Dimension and Virtual Cube (Mining Model Wizard)
Finish (Mining Model Wizard)
Partition Wizard
Introduction (Partition Wizard)
Specify Data Source and Fact Table (Partition Wizard)
Select Data Slice (Partition Wizard)
Specify Partition Type (Partition Wizard)
Finish (Partition Wizard)
Storage Design Wizard
Introduction (Storage Design Wizard)
Select a Partition (Storage Design Wizard)
Aggregations Already Exist (Storage Design Wizard)
Select Data Storage (Storage Design Wizard)
Set Aggregation Options (Storage Design Wizard)
Finish (Storage Design Wizard)
Usage Analysis Wizard
Introduction (Usage Analysis Wizard)
Select Filter Criteria (Usage Analysis Wizard)
Review Results (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
Introduction (Virtual Cube Wizard)
Select Cubes (Virtual Cube Wizard)
Select Measures (Virtual Cube Wizard)
Select Dimensions (Virtual Cube Wizard)
Finish (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
Menus (Cube Editor Data View)
Toolbar (Cube Editor Data View)
Tree Pane (Cube Editor Data View)
Properties Pane (Cube Editor Data View)
Data Tab (Cube Editor Data View)
Cube Editor - Schema View
Menus (Cube Editor Schema View)
Toolbar (Cube Editor Schema View)
Tree Pane (Cube Editor Schema View)
Properties Pane (Cube Editor Schema View)
Schema Tab (Cube Editor Schema View)
Cube Processing Settings Dialog Box
Cube Role Dialog Box
Summary Tab (Cube Role Dialog Box)
Membership Tab (Cube Role Dialog Box)
Dimensions Tab (Cube Role Dialog Box)
Cells Tab (Cube Role Dialog Box)
Options Tab (Cube Role Dialog Box)
Cube Role Manager
Custom Dimension Security Dialog Box
Basic Tab (Custom Dimension Security Dialog Box)
Advanced Tab (Custom Dimension Security Dialog Box)
Common Tab (Custom Dimension Security Dialog Box)
Data Mining Model Browser
Toolbar (Data Mining Model Browser)
Content Detail Pane (Data Mining Model Browser)
Content Navigator Pane (Data Mining Model Browser)
Attributes Pane (Data Mining Model Browser)
Legend Pane (Data Mining Model Browser)
Keyboard Shortcuts (Data Mining Model Browser)
Data Mining Prediction Query Task Dialog Box
Mining Model Tab (Data Mining Prediction Query Task Dialog Box)
Query Tab (Data Mining Prediction Query Task Dialog Box)
Output Tab (Data Mining Prediction Query Task Dialog Box)
Database Dialog Box
Database Role Dialog Box
Membership Tab (Database Role Dialog Box)
Cubes Tab (Database Role Dialog Box)
Mining Models Tab (Database Role Dialog Box)
Dimensions Tab (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
Network Browser Pane (Dependency Network Browser)
Toolbar (Dependency Network Browser)
Slider Pane (Dependency Network Browser)
Legend Pane (Dependency Network Browser)
Keyboard Shortcuts (Dependency Network Browser)
Dimension Browser
Dimension Members Pane (Dimension Browser)
Member Properties Pane (Dimension Browser)
Custom Member Formula Pane (Dimension Browser)
Dimension Editor - Data View
Menus (Dimension Editor Data View)
Toolbar (Dimension Editor Data View)
Tree Pane (Dimension Editor Data View)
Properties Pane (Dimension Editor Data View)
Data Tab (Dimension Editor Data View)
Dimension Members Pane (Dimension Editor Data View)
Member Properties Pane (Dimension Editor Data View)
Custom Member Formula Pane (Dimension Editor Data View)
Dimension Editor - Schema View
Menus (Dimension Editor Schema View)
Toolbar (Dimension Editor Schema View)
Tree Pane (Dimension Editor Schema View)
Properties Pane (Dimension Editor Schema View)
Schema Tab (Dimension Editor Schema View)
Dimension Manager
Drillthrough Options Dialog Box
Columns Tab (Drillthrough Options Dialog Box)
Filter Tab (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
Menu Bar (OLAP Mining Model Editor)
Toolbar (OLAP Mining Model Editor)
Structure Pane (OLAP Mining Model Editor)
Properties Pane (OLAP Mining Model Editor)
Browser Pane (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
General Tab (Properties Dialog Box)
Environment Tab (Properties Dialog Box)
Processing Tab (Properties Dialog Box)
Logging Tab (Properties Dialog Box)
Add-ins Tab (Properties Dialog Box)
Active Directory Tab (Properties Dialog Box)
Relational Mining Model Editor
Menu Bar (Relational Mining Model Editor)
Toolbar (Relational Mining Model Editor)
Structure Pane (Relational Mining Model Editor)
Properties Pane (Relational Mining Model Editor)
Browser Pane (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
Menus (Virtual Cube Editor)
Toolbar (Virtual Cube Editor)
Tree Pane (Virtual Cube Editor)
Properties Pane (Virtual Cube Editor)
Data Pane (Virtual Cube Editor)
Write Enable Dialog Box
OLE DB Compliance
OLE DB for Data Mining Compliance
MDX
MDX Overview
Introduction to MDX
Key Concepts in MDX
Comparison of SQL and MDX
Basic MDX
The Basic MDX Query
Members, Tuples, and Sets
Axis and Slicer Dimensions
Specifying the Contents of an Axis Dimension
Specifying the Contents of a Slicer Dimension
Establishing Cube Context
Advanced MDX
Creating and Using Property Values
Using Member Properties
Intrinsic Dimension and Level Member Properties
Intrinsic Member Properties
Custom Member Properties
Using Cell Properties
FORMAT_STRING Contents
FORE_COLOR and BACK_COLOR Contents
Building Named Sets in MDX
Using WITH to Create Named Sets
Building Calculated Members in MDX
Using WITH to Create Calculated Members
Using Functions in Calculated Members
Conditional Expressions
IIf Function
Building Caches in MDX
Using WITH to Create Caches
Building Calculated Cells in MDX
Using WITH to Create Calculated Cells
Creating and Using User-Defined Functions in MDX
Using Writebacks
Using DRILLTHROUGH to Retrieve Source Data
Understanding Pass Order and Solve Order
Effective MDX
Comments in MDX
Working with Empty Cells
Creating a Cell Within the Context of a Cube
Working with the RollupChildren Function
WHERE Clause Overrides
MDX Functions in Analysis Services
MDX Function Reference
MDX Syntax Conventions
MDX Function List
A
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ancestors
Ascendants
Avg
Axis
B
BottomCount
BottomPercent
BottomSum
C
CalculationCurrentPass
CalculationPassValue
Call
Children
ClosingPeriod
CoalesceEmpty
Correlation
Count
Cousin
Covariance
CovarianceN
Crossjoin
Current
CurrentMember
D
DataMember
DefaultMember
Descendants
Dimension
Dimensions
Distinct
DistinctCount
DrilldownLevel
DrilldownLevelBottom
DrilldownLevelTop
DrilldownMember
DrilldownMemberBottom
DrilldownMemberTop
DrillupLevel
DrillupMember
E
Except
Extract
F
Filter
FirstChild
FirstSibling
G
Generate
H
Head
Hierarchize
Hierarchy
I
Ignore
IIf
Intersect
Is
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item
L
Lag
LastChild
LastPeriods
LastSibling
Lead
Level
Levels
LinkMember
LinRegIntercept
LinRegPoint
LinRegR2
LinRegSlope
LinRegVariance
LookupCube
M
Max
Median
Members
MemberToStr
Min
Mtd
N
Name
NameToSet
NextMember
NonEmptyCrossjoin
O
OpeningPeriod
Order
Ordinal
P
ParallelPeriod
Parent
PeriodsToDate
Predict
PrevMember
Properties
Q
Qtd
R
Rank
RollupChildren
S
SetToArray
SetToStr
Siblings
Stddev
StddevP
Stdev
StdevP
StripCalculatedMembers
StrToMember
StrToSet
StrToTuple
StrToValue
Subset
Sum
T
Tail
ToggleDrillState
TopCount
TopPercent
TopSum
TupleToStr
U
Union
UniqueName
UserName
V
ValidMeasure
Value
Var
Variance
VarianceP
VarP
VisualTotals
W
Wtd
Y
Ytd
Registered Function Libraries
Visual Basic for Applications Functions
Excel Functions
User-Defined Functions with MDX Syntax
How To
Configuring Analysis Servers
How to register an Analysis server
How to add a linked Analysis server using SQL Server Enterprise Manager
How to start the Migrate Repository Wizard
How to configure Analysis Services for the Web
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
How to start the Partition Wizard
How to process a partition
How to merge two partitions
How to specify a data source for a linked cube
How to create a linked cube
How to process a linked cube
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
How to incrementally update a cube
How to refresh data in a cube
How to incrementally update a shared dimension
How to rebuild the structure of a shared dimension
Managing Data Mining Models
How to start the Mining Model Wizard
How to start Relational Mining Model Editor
How to start OLAP Mining Model Editor
How to process a data mining model
How to start Mining Model Role Manager
How to add a role to a data mining model
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
How to start the Usage Analysis Wizard
How to start the Usage-Based Optimization Wizard
Automating and Scheduling Administrative Tasks
How to create an Analysis Services Processing task
How to create a Relational Data Mining Prediction Query task
Get in touch
Submit feedback about this site to:
[email protected]