Thomas LeBlanc (9/5/2012)
I would first suggest reading some articles from the Kimbal group and concentrate on Fact tables - Tranaction, Snapshot and Accumalitve.You need this understanding to get the measures the reports are requiring.
Making it easier for those that will follow: