Assistance with SQL creating transformation & OLAP Report

Need assistance with creating transformations using Figure 8-2 orginial database while incorporating Figure 8-10 HSD-DW SQL Statements. Assignment attachment shows actual step by step questions pertaining to the assignment.
Tutor Answer
