Hi All,
I have a DMR model which contains Product, Time and Customer as Regular dimensions and "Number of distinct Orders " as a measure dimension.
My first requirement is ,
To have a drill-able cross-tab containing products in the row edge and Time in column edge. The fact cells should contain number of customers who gave more than 1 distinct orders for the product and time scope. This requirement has been achieved using a filter member set and doing a Count(1 within set) technique.
My second requirement is,
Cross-tab edges same as above, but there are 3 sets of facts.
1> Number of customers having placed order 1 time
2> Number of customers having placed order 2 or 3 times.
3> Number of customers having placed order > 3 times.
I am trying to use the same technique , but not working for me. Could someone shed some light on this. Do I have to use any other technique for this one..maybe tuple calculations??