.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Help!!! With RollUpChildren!!!!

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server

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:



Month ID


Customer ID

Sales Order ID

Line No



Required Date

Despatched Date

On Time


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

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend