I have a requirement to define a master detail report like the
following scenario:

We store sales by SalesReps in a cube at sales date level in the cube.

I need to now report in one report the sales as follows in this format:



SalesRep Fiscper ActualSales(Value) ActualSales(Qty)
for each of the above record I will have a number of following
records to display
Number DocumentNo Date ActualSales(Value) ActualSales(qty)


so an example is as follows:


Keith Charles 002.2005 $ 9800 2050 EA
1 981898999 03.02.2005 $5000 1000 EA
2 981234567 10.2.2005 $2000 500 EA
3 789209999 22.02.2005 $2800 550 EA


Bill Brown 002.2005 $12450 6200 EA
1 8989999989 08.02.2005 $9000 5000 EA
2 9898988178 18.02.2005 $3450 1200 EA


......

so I want a list of all sales reps as you can see showing the summary
sales value and qty for every rep in the first line to show summary and
the subsequent lines to show all details for that rep for that month
the actual line items.

How can I build a MDX query to do this.


Thanks in advance
Karen