This is a Microsoft to Oracle port of the well known AdventureWorks database. I originally posted this logic in an Oracle Technology Network article on Essbase Studio.  I am placing it here at github merely for redundancy as Oracle's OTN links continue to be moved without proper redirect or notice.