Databases Reference
In-Depth Information
.
Dimensions
defines the dimensionality of the cube, the most important characteris-
tic of a cube. This collection includes all the dimensions except the
Measure
dimen-
sion. (We provide more information about the
Measure
dimension in Chapter 7,
“Measures and Multidimensional Analysis.”)
.
MeasureGroups
defines the measures in the cube that are accessible for analysis.
.
CubePermissions
defines access to data. (For more information about security archi-
tecture, see Chapter 35, “Security Model for Analysis Services.”)
.
Perspectives
defines different views of the cube. The
Perspectives
collection enables
you to limit the visibility to some elements of the cube and to simplify the model for
the user.
.
MDXScripts
defines the methods for using the physical space (see Chapter 2,
“Multidimensional Space”) to calculate the theoretical space of the cube. The rules
and language for building the script are covered in Chapter 12, “Cube-Based MDX
Calculations.”
.
KPIs
defines a list of objects that support key performance indicators that are avail-
able for the client application. We cover the KPIs in Chapter 15, “Key Performance
Indicators, Actions, and the
DRILLTHROUGH
Statement.”
.
Actions
is a list of objects that enable you to define the actions that must occur in
an application when the user accesses specific cells of the cube. We cover actions in
Chapter 15.
A cube has a large number of parameters that define the behavior of its elements during
its life cycle or that define default parameters for various elements of the physical model.
(For information about those parameters, see the chapters in Part 5, “Bringing Data into
Analysis Services,” and Part 6, “Analysis Server Architecture.”)
In Listing 6.1, we show the definition of the
Warehouse and Sales
cube, without expand-
ing the
Dimensions
collection and the
Measures
collection. This definition of the cube
from the point of view of the conceptual data model is very simple.
LISTING 6.1
A Cube Definition
<Cube xmlns=”http://schemas.microsoft.com/analysisservices/2003/engine”>
<ID>FoodMart2008</ID>
<Name>Warehouse and Sales</Name>
<Language>1033</Language>
<Translations>
<Translation>
<Language>1049</Language>
<Caption>
Сеть
Продуктовых
Магазинов
</Caption>
</Translation>
</Translations>
Search WWH ::
Custom Search