documentation.HELP! Analysis Services Documentation

Archiving, Restoring, and Copying Data

Analysis Services

previous page next page
Analysis Services

Archiving, Restoring, and Copying Data

The following topics describe procedures for 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

See Also

Archiving, Restoring, and Copying Data

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.