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. Select Consolidation, then Extract, and then Data.
2. Select the POV dimension members.
3. From Destination Database (DSN), select the database to which you are exporting the star schema.
4. For Relational Table Prefix, type the prefix that identifies the star schema’s tables.

   Note:

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

5. Click Save Template.
6. Enter a template name and click OK.