Technical Training
Analysis Services TrainingTable of Contents
MSAS - Defining and Creating Auctions
MSAS - Defining and Creating Auctions - Page 2
MSAS - Defining and Creating Auctions - Page 3
MSAS - Defining and Creating Auctions - Page 4MSAS - Defining and Creating Auctions Page - 4
MSAS - Defining and Creating Auctions
Importing an Action into a Virtual Cube
To import an action into a virtual cube, invoke the Import actions Dialog box from the Virtual Cube editor. Actions can be imported only from cubes that are in the same database as the edited virtual cube. If the imported action has the same name as an action already in the virtual cube, the imported action is given a new name consisting of its old name and a numeric suffix. An error message is displayed if the imported action's definition includes a measure, dimension, or other object that is not in the virtual cube or if there are syntax errors. The action is not included in the virtual cube data displayed to end users as long as the error exists. To correct the error, the user must add the missing measure, dimension, or object to the virtual cube and process it. To add a measure or dimension, use the Virtual Cube Wizard. To start Virtual Cube Wizard from within Virtual Cube Editor, on the Edit menu, click Structure... (Wizard).
In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.
In Virtual Cube Editor, on the Edit menu, point to Import, and then click Actions.
|
|
In the Import Actions dialog box, select the check box beside the action, and then click OK. (To select all the actions in a cube, select the check box beside the cube.)
|
|
In Virtual Cube Editor, on the File menu, click Save.
Editing an Action in a Virtual Cube
To edit an action in a virtual cube, use Virtual Cube Editor and the Action Wizard.
In the Analysis Manager tree pane, right-click the virtual cube, and then click Edit.
In the Virtual Cube Editor tree pane, right-click the action, and then click Edit. The action wizard is invoked.
Follow the steps of the action wizard.
Note that Actions in virtual cubes are not visible in the Analysis Manager tree pane. To create and access them, you must first display Virtual Cube Editor.
Analysis Services Training
- MSAS - Browsing the Dependency Network
- MSAS - Building a Relational Decision Tree Model
- MSAS - Introduction to Data Mining
- MSAS - Applying security to a Dimension
- Tutorial 65: MSAS - Managing Cube Roles
- MSAS - Understanding Database Roles
- MSAS - Securing User Authentication
- MSAS - Introducing Analysis Services Security
- MSAS - Writebacks
- MSAS - Defining and Creating Drillthrough
- MSAS - Defining and Creating Auctions
- MSAS - Creating and Maintaining Calculated Members in Virtual Cubes
- MSAS - Building a Virtual Cube
- MSAS - Understanding Virtual Cubes
- MSAS - Introducing Solve Order
- MSAS - Implementing Calculations Using MDX Part 2
- MSAS - Implementing Calculations Using MDX Part 1
- MSAS - Merging Partitions
- MSAS - Introduction and Managing Partitions
- MSAS - Troubleshooting Cube Processing
- MSAS - Optimizing Cube Processing
- MSAS - Processing Dimensions and Cubes
- MSAS - Introducing Dimension and Cube Processing
- MSAS: Optimization Tuning Part 2
- MSAS: Optimization Tuning Part 1
- MSAS: Usage-Based Optimization
- MSAS: Analysis Services Aggregations
- MSAS: The Storage Design Wizard
- MSAS: Analysis Server Cube Storage
- MSAS: Defining Cube Properties
- MSAS: Introduction and Working with Measures
- MSAS: Introduction and Working with Cubes
- MSAS: Virtual Dimensions
- MSAS: Introducing Member Properties
- MSAS: Creating Custom Rollups
- MSAS: Creating a Time Dimension
- MSAS: Understanding Hierarchies
- MSAS: Dimension Storage Modes and Levels
- MSAS: Working with Levels and Hierarchies
- MSAS: Working with Parent-Child Dimensions
- MSAS : Basics of Levels
- MSAS : Working with Standard Dimensions
- MSAS : Shared vs Private Dimensions
- Understanding Dimension Basics
- MSAS : Office 2000 OLAP Components
- MSAS : Client Architecture
- MSAS : Cube Storage options
- MSAS : Meta data Repository
- MSAS : Analysis services Tools for Extended Functionality
- MSAS : The Wizards
- MSAS : The Analysis Manager and Analysis Server
- MSAS : The Data warehousing framework of SQL Server 2000 - Part 2
- MSAS : The Data warehousing framework of SQL Server 2000 - Part 1
- MSAS : Microsoft Data Warehousing Overview
- MSAS : Browsing the Cube
- MSAS : Designing Storage and Processing the Cube
- MSAS : Building the Cube Part #3
- MSAS : Building the Cube Part #2
- MSAS : Building the Cube Part #1
- MSAS : Setting up the Database in Analysis Server
- MSAS : Preparing to Create the Cube
- MSAS : Introducing Analysis Manager Wizards
- Microsoft Analysis Services Installation
- MSAS - Applying OLAP Cubes
- Understanding OLAP Models
- Designing the Dimensional Model and Preparing the data for OLAP
- Design of the data warehouse: Kimball Vs Inmon
- Defining OLAP Solutions and Data Warehouse design
- Microsoft Analysis Services Training
- Data Warehouse database and OLTP database
- Introduction to Data Warehousing









