Have you looked through Bill Pearson's articles (like this one) to see if his walk-through of a Rolling Avergae might be applicable?  If not directly applicable it's possible it...

Two things - I would turn on the tracing (verbose, just remember to turn it back off or to less verbose when you're done) for RS and look through those...

Are you using AS 2000 or 2005?

For the fields you outlined, where are these found (ie fact table or dimension/s)?  If we can assume that the rating is found in...

interesting approach to rounding...  I could understand 143614.00, or perhaps 143613.993 but i can't quite see how the '2' in the thousandths location enables the 9 to round past 0...

Not quite sure I'm up with the parameters you're using (I'm guessing this is in Reporting Services) but it sounds like you may want a Named Set rather than a...

If you've installed to the default dirs, then

C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Programming Samples\Data Flow\DataSetDestination Component Sample

I think BOL covers off how to set it up.

Try using the AddCalculatedMembers function, maybe like...

SELECT

 {p_Channel} ON 0,

 ADDCALCULATEDMEMBERS({[Channel].[All Channel].Children}) ON 1

FROM

 Sales

Remember you can also specify a set using <from> : <to> , e.g [20060601]:[20061231] and if using 2K5, i think you can use null on either end to have it...

Have you read the white paper on some of the different ways to handle/implement many-to-many?  It may help you with some of your design questions.

It was written by Marco Russo,...

This link should give you a heads up on where to start, note it also has a link to the Migration Considerations, really worthwhile reading if you've got anything...

here's one presentation i found when googling 'example OLTP to OLAP schema' there's quite a few more

http://www.educationdw.com/tutorial/DW_navathe.pps

Somehwta off-topic but one that we got caught on -> if you happen to be using SSIS on a 64bit box and want to use Excel (and i think maybe...

Well, technically, you *could* create DB's, Cubes, dimensions etc from within SSMS but you'd have to be pretty well versed at writing XMLA scripts.

Below is how you could do it using TSQL(which of course could be put in to a SSIS package), note that you may need to change the start date and...

Have you been through either the samples for SSIS or Books OnLine (BOL) (see here for a 'how-to' for this exact topic)