Multidimensional Models and Relational Database Schemas - Microsoft SQL Server 2008 Analysis Services - page 333

If you don't want to use the BI Dev Studio wizards, you can use the cube editor to
add new measures or new measure groups. Similarly, you can use the dimension
editor to add new dimension attributes to your dimensions and to create hierarchies
and define relationships between your attributes. You can see an example of the
Product dimension in Figure 19.7.

FIGURE 19.7 You can use the dimension editor to add attributes to the Product dimension.

8. Click the Click Here to Generate Data Source View link to launch the Schema
Generation Wizard. Skip the Welcome page.
9. On the Specify the Target page, name your new data source view. Then, click the
Next button.
10. On the Subject Area Database Schema Options page, you can choose the different
features you want to create or enforce for the new relational database schema you
are about to create (see Figure 19.8). On the Specify Naming Convention page, you
can choose prefixes to be used by the Schema Generation Wizard to create tables.
11. In the Schema Generation Progress dialog, you can see the progress of the schema as
it generates. After the schema generates, expand the Updating Subject Area Database
Completed node and the Tables node (see Figure 19.9).
In the Schema Generation Progress dialog box, you can see all the SQL statements
that the Schema Generation Wizard sent to the relational database to generate
tables and keys.