documentation.HELP! Analysis Services Documentation

Managing Data Mining Models

Analysis Services

previous page next page
Analysis Services

Managing Data Mining Models

The following topic describes procedures for 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

See Also

Mining Model Wizard

Relational Mining Model Editor

OLAP Mining Model Editor

Mining Model Role Manager

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]

© documentation.help. Design: rehmann.co.