Database Reference
In-Depth Information
If you ever find that your cube seems to contain no data even though
it has processed successfully, check to see if you have accidentally
deleted the
Calculate
statement from the beginning of your MDX
Script. Without this statement, no aggregation will take place within the
cube and you'll only see data at the intersection of the leaves of every
dimension, as if every measure had
AggregateFunction
set to
None
.
Semi-additive aggregation types
The semi-additive aggregation types are as follows:
•
AverageOfChildren
•
FirstChild
•
LastChild
•
FirstNonEmpty
•
LastNonEmpty
They behave the same as measures with aggregation type
Sum
on all dimensions
except the
Time
dimension. In order to get Analysis Services to recognize a
Time
dimension, you'll need to have set the dimension's
Type
property to
Time
in the
Dimension Editor.
Sometimes you'll have multiple role-playing
Time
dimensions in a cube,
and if you have semi-additive measures, they'll be semi-additive for
just one of these
Time
dimensions. In this situation, Analysis Services
2012 uses the first
Time
dimension in the cube that has a relationship
with the measure group containing the semi-additive measure. You can
control the order of dimensions in the cube by dragging-and-dropping
them in the
Dimensions
pane in the bottom left-hand corner of the
Cube
Structure
tab of the Cube Editor; the following blog entry describes
how to do this in more detail:
http://tinyurl.com/gregsemiadd
.
However, this behavior has changed between versions in the past and
may change again in the future.
Search WWH ::
Custom Search