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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
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

Product

Qty

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

- 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

Categories: 
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