Creating an Account Dimension

You use the Dimension Wizard to create the initial structure of the Account dimension. As you work through the steps of the wizard, you will select the data source table, the key attribute, and other attributes that you want to include in the dimension. You’ll also set some of the more important attribute properties. But for financial analysis, the dimension design for the Account dimension will not be complete. You will need to use the Business Intelligence Wizard to set additional properties to further enhance your Account dimension.

Note

Note

Analysis Services uses account and time information to enable specialized dimension ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.