Database Reference
In-Depth Information
Another thing we'll see is that any aggregations on measure groups that this dimension
joins to that might have been invalidated by the processing are dropped; they'll need to
be rebuilt later on in your processing schedule. These aggregations are called Flexible
aggregations, and they're aggregations that include at least one attribute that has a
Flexible relationship somewhere in the chain of attribute relationships between them
and the key attribute. We can see whether an aggregation is Flexible or Rigid in the
Edit Aggregations dialog of the BIDS Helper Aggregation Manager , as shown in the
following screenshot:
One problem that may result from Type I changes and which may not become
apparent immediately, is that previously saved queries and reports will either stop
working or not return the data you expect. In MDX, a member is identified by its
unique name and this is how it is referenced when you write an MDX query; the
following are some examples of unique names:
[Promotion].[Promotions].[Category].&[Customer]
[Customer].[Customer Geography].[City].&[Alexandria]&[NSW]
[Date].[Calendar Year].&[2001]
 
Search WWH ::




Custom Search