OLAP Extensions Exercises

For these OLAP extensions exercises, the exercises assume database revisions and ETL extensions have been created along the lines of the exercises in those sections.

Recall that in those exercises, database revisions were created to add a staging and warehouse table that closely mirrors FACT_INTERACTIONRESPONSE. If you are completing these exercises separately, remember that the purpose of these exercises is demonstrate the ETL extensions for extension tables in a BBDW database. In other words, creating database revisions extensions and creating ETL extensions are intertwined.

DSV Tables Spec Exercise

DSV Spec Exercise Steps

DSV Spec Exercise Steps (Wizard Version)

Dimensions Spec Exercise

Dimensions Spec Exercise Steps

Dimensions Spec Exercise Steps (Wizard Version)

Dimensional Usage Spec Exercise

Dimensional Usage Spec Exercise

Dimensional Usage Spec Exercise Steps (Wizard Version)

Fact Spec Exercise

Fact Spec Exercise Steps

Fact Spec Exercise Steps (Wizard Version)

Measure Groups Exercise

Measure Groups Spec Exercise Steps

Measure Groups Spec Exercise Steps (Wizard Version)

MDX Scripts Exercise

MDX Scripts Spec Exercise Steps

MDX Scripts Spec Exercise Steps (Wizard Version)

Modify Manifest Spec Exercise

Manifest Spec Exercise Steps

Manifest Spec Exercise Steps (Wizard Version)

Other Groups of Exercises

ETL Extensions Exercises

Revisions Extensions Exercises

Deployment Exercises

Extensibility Model Exercises

OLAP Exercises