Running the Model Builder - SQL Server
To create a Planning relational database for SQL Server:
- Open the Model Builder.
- Select the network protocol.
- Specify the name of the BI OLAP server computer.
- Specify the port number. The default is 8211 for https and 8210 for http.
- Specify the administrator user ID.
- Specify the password for the administrator user ID.
- Select the Planning OLAP database.
- Click .
- Optionally, select the check box to load Workforce Budgeting sample data.
- Optionally, select the primary and allocation dimensions. You cannot change the dimensions if you are loading Workforce Budgeting sample data.
- Click .
- Select whether to build the model using the Model Builder or to create a script for manual execution.
- Select Microsoft SQL Server.
- Specify the Planning relational database name.
- Specify the database password.
- Confirm the database password.
- Select the administrator authentication type.
- Specify the administrator user ID.
- Specify the password for the administrator user ID.
- Specify the server computer name including the SQL instance name if applicable.
- Click .
- Specify the data source name.
- Click .
- Click .
After the relational tables are built, open Application Studio and verify the Workforce Budgeting Detail relational alias is set to connect automatically.