Creating or Upgrading OLAP Metadata Catalogs Automatically

When you complete installation of Integration Services and start Integration Services Console, the program automatically displays the OLAP Metadata Catalog Setup dialog box, as shown in Figure 2, OLAP Metadata Catalog Setup Dialog Box.

This dialog box enables you to create a standard OLAP Metadata Catalog automatically, using Integration Services Console. If you have an older version of the OLAP Metadata Catalog, you also use this dialog box to upgrade the older version to the current version.

Figure 2. OLAP Metadata Catalog Setup Dialog Box

OLAP Metadata Catalog Setup Dialog Box.

If you prefer to create the OLAP Metadata Catalog manually, see Upgrading OLAP Metadata Catalogs Manually.

  To create an OLAP Metadata Catalog automatically:

  1. From the Server Name drop-down list in the OLAP Metadata Catalog Setup dialog box, type or select the server computer on which you have installed Essbase Integration Server.

    It is necessary to type a server name the first time it is used. After the OLAP Metadata Catalog is successfully created, the server name is then displayed in the Server Name drop-down list box.

  2. From the Catalog ODBC DSN drop-down list, select the Data Source Name for the OLAP Metadata Catalog that you are creating.

    Note:

    You must create the database in which you will store the OLAP Metadata Catalog, assign the appropriate user permissions, and configure the ODBC connection before you can create the catalog.

  3. In the Code Page drop-down list box, select the code page that corresponds to the code page of the relational database that will be used as the OLAP Metadata Catalog.

    The code page is a portion of the locale which identifies the local language and cultural conventions such as the formatting of currency and dates and the sort order of data.

  4. In the User Name drop-down list, select or type the user name to which you have assigned permission to access the database in which the OLAP Metadata Catalog will be stored.

  5. In the Password text box, type the password for the user name to which you have assigned permission to access the database in which the OLAP Metadata Catalog will be stored.

  6. If you want the OLAP Metadata Catalog Setup dialog box to be displayed automatically each time you start Integration Services Console, leave the Show this dialog at Startup check box selected.

    If you do not select the “Show this dialog at Startup” check box, you can access the “OLAP Metadata Catalog Setup” dialog box from the console by selecting Tools, then Create Catalog.

    If an OLAP model or metaoutline is open when you select Tools, then Create Catalog, you are prompted to disconnect from the current catalog (Connections, then OLAP Metadata Catalog, then Disconnect). Note that disconnecting from an OLAP Metadata Catalog causes the open OLAP model or metaoutline to close.

  7. Click Create.

    Integration Services Console creates the OLAP Metadata Catalog automatically.

    Note:

    If you are migrating from a previous release of Integration Services, the OLAP Metadata Catalog auto-creation process upgrades the existing OLAP Metadata Catalog.