Hello,


I have created my first named set for 3 members without
using explicit member names based on my time dimension.
The named set is called Latest Week Hierarchy

{
Tail(Filter ([Time].[FiscalYPWkdt].[Fiscal Wk
Desc].Members, NOT ISEMPTY([Measures].[Markdown Amt] ) )),
Tail(Filter ([Time].[FiscalYPWkdt].[Fiscal Period
Txt].Members, NOT
ISEMPTY([Measures].[Markdown Amt] ) )),
Tail(Filter ([Time].[FiscalYPWkdt].[Fiscal Yr
Txt].Members, NOT ISEMPTY([Measures].[Markdown Amt] ) ))
}

When would one use a named set?
How does one reference the named set in MDX.

Thanks
Gary

From SQL BOL, Foodmart MDX queries using named sets:

http://msdn.microsoft.com/library/en...anced_1z7c.asp


Some OLAP client tools support server-defined Named Sets.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!