Business Intelligence Wizard F1 Help (SSAS)

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 Business Intelligence Development Studio.

Community Additions