Return list of members without measures.

[SQLBI]

Hi,

Is there any way i can use MDX to return a list of a specific dimensions members, without the associated measures or do i need to simply use T-SQL?

My dimension is effectively a list of all sites, and i want to return a list of 'Member Names' to use in a Reporting Services report parameter.

The only code i can get to work so far is

SELECT {[Practice].[Practice].Members} ON COLUMNS
FROM Margin

But this just returns a sum of my measures, accross all dimnsions.

When i exclude the COLUMNS argument and only include ROWS i get an error.

Can anyone suggest where i'm going wrong?

Thanks in advance.

Cheers,
Leigh

The problem with common sense is that it isn't that common!

 

[SQLBI]

Decided to use good old T-SQL and query the dimension tables directly, but if anyone comes up with the MDX syntax for what i want to do i'd still like to see it.

Cheers,
Leigh

The problem with common sense is that it isn't that common!