Migrating the Analysis Services Repository

Note The following is a one-time-only procedure.

The information that is stored in the Analysis Services Repository is used to build the OLAP cube. Initially, this information is stored in the format of an Access database. If you leave the information in this format, permissions for using the cube are difficult to control. Therefore, before you build the cube, you should migrate the Analysis Services Repository to an SQL Server database. This two-part process involves first creating an empty SQL database and then migrating the Analysis Services data into it. To create the SQL database, follow these steps:

1. Choose StartOAll ProgramsOMicrosoft SQL ServerOEnterprise Manager. You see the SQL Server Enterprise Manager window, as shown in Figure 19-49.

Figure 19-49: Use this window to create a new SQL database.

2. Expand the tree in the left pane until you see the Databases folder.

3. Right-click the Databases folder, and choose New Database from the shortcut menu that appears. You see the Database Properties dialog box.

4. In the Name text box, type a name for the database that is to hold the OLAP information (I called mine OLAPRepository) and click OK.

5. Close the SQL Server Enterprise Manager window.

To migrate the Analysis Services information into the SQL database that you just created, follow these steps:

1. Choose StartOAll ProgramsOMicrosoft SQL ServerOAnalysis ServicesO Analysis Manager. You see the Analysis Manager window, as shown in Figure 19-50.

Figure 19-50: Use this window to migrate the Analysis Services Repository.

2. Expand the tree in the left pane until you see the name of the server on which Analysis Services is installed.

3. Right-click the name of the Analysis Services server, and choose Migrate Repository from the shortcut menu that appears to start the Migrate Repository Wizard.

4. On the first screen, choose Analysis Services native format and click Next.

5. On the next screen, enter the name of the server on which SQL 2000 is installed; then click Next.

6. On the next screen, choose the authentication method that you use to connect to the SQL server — either Windows Authentication or SQL Server authentication. If you use SQL Server authentication, enter your login ID and password.

7. Click Next, select the database that you created in the preceding set of steps (see Figure 19-51), and click Finish.

Figure 19-51: Select the SQL database that you created.

8. When the process finishes, close the Analysis Manager window.

Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment