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.

In This Section

See Also


Cube Designer (SSAS)
Dimension Designer (SSAS)
Analysis Services Wizards (SSAS)

Help and Information

Getting SQL Server 2005 Assistance