I have an MDX query to return healthcare costs
select NON EMPTY { [Measures].[Submitted Amount] : [Measures].[Benefits Not Covered]} on columns
{[Group].[Main Group].Members} on row
from ClaimsI

1) How do I have this only return results for a set of years (2002, 2003) instead of all the years in the cube
2) How would I apply a CrossJoin to show only these years as subordinates to each member

Thank you in advance.

You can add the set of years

select NON EMPTY
{ { [Measures].[Submitted Amount] : [Measures].[Benefits Not Covered]} * {[Time].[2002],[Time].[2003]} } on columns
{[Group].[Main Group].Members} on row
from ClaimsI

BTW, * is an alternate Crossjoin syntax. If you need to return a long period of consecutive years you can use the range expression : [Time].[1998]:[Time].[2005] to avoid enumerating the intermediate members
HTH
Bria
www.geocities.com/brianaltmann/olap.html

Could you elaborate a little on how you implemented this query; assuming
that the year value can change in the query, how did you pass parameters to
the mdx query

thanks, much
-Anup

"Brian Altmann" <anonymous (AT) discussions (DOT) microsoft.com> wrote

[Time].[1998]:[Time].[2005] to avoid enumerating the intermediate members.