O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the Business Intelligence Wizard

After you've added the fact tables and dimensions to your cube and configured the properties for both, the next option for you to consider is whether to use the Business Intelligence Wizard to add still more sophisticated options to your BI solution. This wizard presents you with a different list of options depending on whether you've opened it from the cube or from the dimension designer. The complete list of options (for both types) is as follows:

  • Add Writeback: This option, for dimensions only, requires the Enterprise Edition of SSAS. Using this wizard simply sets the WriteEnabled property of a dimension to True.
  • Add Semiadditive Measures: This option, for cubes only, allows you to set the aggregationFunction ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required