Database Dimensions - BI Wizard in Dimension Designer

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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 SQL Server Data Tools (SSDT). Dimension Designer can be accessed from SQL Server Data Tools (SSDT).

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.