SSAS Time Account Dimension Intelligence

Problem

SSAS includes Time, Account, and Dimension Business Intelligence Wizards; what do these functions do and how should they be used?

Solution

The Time, Account, and Dimension Intelligence Wizards allow you to quickly and easily setup specialized dimension and attribute structures based on a set of inputs. The wizards lead you through a set of questions and based on these answers, create a "cookie cutter" set of dimension properties / calculations. They are part of the Business Intelligence Wizards which is defined by SSAS as a group of enhancements that provide an easy way to create a set of dimension or measure objects which otherwise would take a significant time investment to create. In this tip we will cover the three Business Intelligence Wizards.