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 ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial