Hi All

One or more mdx statements ? Example - a user has chosen 2 quarter in the
time dimension and in my cube he is now looking at
a calc member showing year to date.

When the user selects drill through i would like the mdx drill through
statement to include 2 quarter but also 1 quarter - how would
i go about doing that ?

Can I put this into one mdx drillthrough statement or will this give an
error because i have multiple selections in one field ? Do I need to make 2
drill through statements - one for each quarter ? And how do i say that I
also want 1 quarter (when having selected 3 quater i want 1 og 2 as well).

And i want it to work with months as well - how do i say it should choose
1,2,3,4 when having chosing 5 month ?

Do i put a member prop on each level containg the sort order ?

--Michael Vardinghus