Enhancing Cubes with Optional Features

Analysis Services

Analysis Services

Enhancing Cubes with Optional Features

Microsoft® SQL Server™ 2000 Analysis Services offers many powerful optional features you can use to enhance the analysis performed in cubes and the presentation of cube data. There are additional optional features for dimensions that further enhance cube capabilities. For more information, see Enhancing Dimensions with Optional Features.

Topic Description
Creating Calculated Members Contains information about using function libraries to create members that display values calculated at run time.
Creating Calculated Cells Describes using calculated cells to create a multidimensional section of cells, defined by a Multidimensional Expressions (MDX) set expression, to which an MDX value expression is selectively applied depending upon a condition described by an MDX logical expression.
Creating Named Sets Contains information about different options for creating sets of dimension members or set expressions that you can use in MDX queries.
Creating Actions Describes different types of actions, which you can create to provide end users with ways to view and even interact with data sources.
Maintaining Write-Enabled Cubes and Writeback Data Contains information about configuring cube data so that end users can make changes to it.
Specifying Drillthrough Options Describes ways to allow users to see the source data for a cube cell.