Even when only a few of the dimension members have measures associated with them, the dimension members are still part of the cube. When drilling down the dimension, these members show up as rows with empty measure values in the UI.
Is there a way to suppress the dimension members which do not have measures associated with them from getting into the cube?

Try using NON EMPTY before one or more of your axis specifications

SELEC
NON EMPTY { Measures.[My Measure] } ON COLUMNS
NON EMPTY { [My Dimension].Members } ON ROW
FROM [My Cube

- Paul

---
Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/