How to: Start the Business Intelligence Wizard in Dimension Designer

In Microsoft SQL Server Analysis Services, you create custom rollup operators and custom member formulas and configure dimensions for writeback by using the Business Intelligence Wizard or Dimension Designer. You can start the Business Intelligence Wizard from Solution Explorer or from Cube Designer in Business Intelligence Development Studio. Dimension Designer can be accessed from Business Intelligence Development Studio.

To start the Business Intelligence Wizard

  • Open the dimension to which you want to add business intelligence, and on the toolbar, click the Add Business Intelligence button. Alternatively, you can right-click the dimension in either Object Explorer or Solution Explorer, and then click Add Business Intelligence.