Creating a Star Schema Template

You can create a star schema template, which enables you to name and save POVs so that you can use them again.

  To create a star schema template:

  1. Open the application.

  2. Select Administration, then Extended Analytics.

  3. Select the POV dimension members.

  4. From Destination Database (DSN), select the database to which you are exporting the star schema.

  5. For Relational Table Prefix, type the prefix that identifies the star schema’s tables.

    Note:

    The prefix can contain up to 10 alpha-numeric characters and must start with a letter. The default prefix is the application name.

  6. Click Save button.

  7. Type a template name.

  8. Optional: To overwrite a template, select Overwrite.

  9. Click Save.

  10. Click OK.