I have dimension table that has a DimensionKey the maps to the Fact Table.
There are two Attribute Dimensions that have both have the odd Null in them
that I manage not to display the Null's in the Dimension Browser when
browsing the Attributes. My issue though is that the Total for each of the
Attribute includes the Null member values. What setting do I need to ensure
that the Null member values are excluded from the totals. In effect I want
the Attributes to have different values.

Thanks in advance.

We have resolved the issue and get the correct totals. The issue now is that
when we display the Attributes as rows, the first Attribute includes all the
members that meet its definition and the total is correct, but the second
does not show all the members that make up the Attribute table, but only
common one. The total is correct though so it appears to be the display of
the measures or when the measures are processed these are not being recorded
correctly? Any ideas? We have the same problem for Measure Calculated
Members and normal Measures.

Thanks


"Nan" <Nan (AT) 1111 (DOT) com> wrote