Dimensions and non associated measures

I have a cube with three dimensions, Date, Country, and Product. This cube
also has two measures, Sales and Amount.

The Sales measure is sliceable by all three dimensions, whereas Amount is
only sliceable by Date and Product.

When the user drills down on the Country dimension they see numbers for the
Amount measure. The user would NOT like to see numbers at all.

For the life of me I can't remember the method used to withhold numbers from
which they have no association with the dimension.

Any ideas?

Jesse O,

Set the measure group property "IgnoreUnrelatedDimensions" to false.


AMB


"Jesse O" wrote:

> I have a cube with three dimensions, Date, Country, and Product. This cube
> also has two measures, Sales and Amount.
>
> The Sales measure is sliceable by all three dimensions, whereas Amount is
> only sliceable by Date and Product.
>
> When the user drills down on the Country dimension they see numbers for the
> Amount measure. The user would NOT like to see numbers at all.
>
> For the life of me I can't remember the method used to withhold numbers from
> which they have no association with the dimension.
>
> Any ideas?
>
>