I have finally been able to call a Named Set from Analysis Services
via the MDX sample application, but I receive all the detail. I only
want to see the Named set itself and not want is defined within it.
How do I do this?

Sample:

select
crossjoin ( {[Report_Period].[All Report_Period].children},{
[Measures].[Total Paid],[Measures].[PMPM],[Measures].[TotalPMPMChng],[Measures].[PKPY]})on
columns,

//[Reports] is my named set
crossjoin ({ ([reports] },{[Category].children}) on rows

from Professional

You accomplish that by using the aggregate function. Add the following to
your MDX statement

With member [YourDimension].[MyAggregate] as 'AGGREGATE({[Reports]})'

Then reference that calculated member in your query instead of your named
set.


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"AudreyR" <arachunok (AT) monroeplan (DOT) com> wrote