I'm new to Analysis Services (about a month) and MDX (about a week), but I've been working through the excellent "Step-by-Step SQL Server 2000 Analysis Services" book and the superb articles on here by William Pearson, and BOL and anything I can find on
the Internet, but I've ground to a big fat halt. I can't find much at all about the proper use of the RollUpChildren function and I've messed around for days with it with no success.
Please please please point me in the right direction!
I have a fact table populated with sales order line data, this being:
Sales Order ID
This is for a report I want to show on time in full (OTIF) delivery as a percentage. The On Time field has either a 0 or 1 to signify late (0) or on time (1). That's my basic measure.
In Analysis Services, I have a customer dimension, with the levels:
- Customer Account
- Sales Order Number
Because I want the user to be able to look at OTIF for the customer, then per sales order and then use drillthrough to see the individual lines for an order.
View Complete Post