Database Reference
In-Depth Information
We will be implementing dynamic partitioning on the Sales measure group in our
sample cube here. To do this, we need to make sure there is only one partition in that
measure group, and we need to change its
Binding type
to
Query Binding
. Since this
is only a template partition, we don't want it to be able to store any data. So, we add
a condition to the
WHERE
clause in the
SELECT
statement that this partition is bound
to like
WHERE 1=0
, as shown in the following screenshot. This will ensure that, if it is
processed, no rows will be read during processing and that it will contain no data.
If we want to use the Design Aggregation wizard at this point,
we will need to either remove the
WHERE
clause from the query,
deploy the cube, and process it before launching the wizard; or
set the
EstimatedRows
property on the partition to the average
number of rows we expect to have in each partition.
Search WWH ::
Custom Search