Attempting to write MDX select statement that displays last 12 months
that have data in them. Here is what I have so far:



select

tail(Filter({[Period].Month.Members},(NOT
IsEmpty([Measures].CurrentMember))),12) on columns,

{Measures.[Enroll Cnt]} ON ROWS

from Enrollment



I need to limit this to current year ([Period].[2003]. It is pulling
all the months from all the years in the cube now, so I can't tell if
the filter works since I do have an enroll cnt for all months over time.
I don't have an Enroll Cnt for December 2003, so my retrieval should
show December (2002) thru November (2003).


--
Posted via http://dbforums.com

Doesn't [Period].[2003].[Month] within the filter help?
Am I missing something?
- Priya

I kept getting errors when I added that member. Actually, what I really
want to do is this:





select

LastPeriods(12, [Period].[All Period].[2003].[Quarter 4].[November])
on columns

from Enrollment

where [Scenario].[All Scenario].[Actual]





This is similar to how we are currently doing it in an Essbase cube.
However, we are passing in the current month with an Essbase
substitution variable so it is dynamic on the display. How would I
simulate that in Analysis Services?


--
Posted via http://dbforums.com