Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Business Intelligence Wizard F1 Help
Collapse the table of content
Expand the table of content

Business Intelligence Wizard F1 Help


Use the Business Intelligence Wizard to define business intelligence features and set advanced options on cubes and dimensions. The wizard sets properties on existing objects, creates new objects, and generates Multidimensional Expressions (MDX) scripts to provide features such as dimension intelligence and currency conversion.

The Business Intelligence Wizard can guide you through some or all the following steps:

  • Define time intelligence for cubes.

  • Define account intelligence for cubes and dimensions.

  • Define dimension intelligence for cubes and dimensions.

  • Define unary operators for cubes.

  • Set custom member formulas for cubes and dimensions.

  • Specify attribute ordering for dimensions.

  • Enable dimension writeback for dimensions.

  • Define semi-additive behavior for cubes.

  • Define currency conversion for cubes.

After you enhance a cube or dimension by using the Business Intelligence Wizard, you can use Cube Designer, Dimension Designer, or Business Intelligence Wizard to edit its properties in SQL Server Data Tools (SSDT).

© 2015 Microsoft