Opportunity star schema

The Opportunity star schema is illustrated here:

The Opportunity star schema consists of the Opportunity measure and references to the dimensions listed in the following table:

Dimension

Role

Sales Person

Owner

Address Region

Default

Calendar

Calendar - Opportunity Creation Date

Calendar (Secondary) - Opportunity Resolution Date

Enterprise

Default

Buyer

Default

Customer

Default

Sales Team

Owner