This should be easy... but I'm still learning.

I have a hierarchy displaying
Area
Dept
Task

The measure is Target.

The hierarchy displays fine, but if there isn't a target fact for a specific
task, the Task does not display. How do I display tasks for which there
aren't any measures?
I want to see all Tasks regardless of whether there are any details for them.

most of the client tools remove empty rows/columns by adding the "non empty"
keyword in the MDX statement
like:
select non empty task.members on rows, measures.members on columns
from cube

try to change the "hide empty rows" option (the pivottable has this option)
or the equivalent option of your client tool.
if you can edit the MDX query, remove this keyword your self.


"SteveM" <SteveM (AT) discussions (DOT) microsoft.com> wrote