Creating Repository Tables

A repository is a central place in which an aggregation of data is kept and maintained in an organized way. A document repository is a group of specialized database tables used to store different kinds of data models.

A document repository can be located on any database in the network environment, and can even store data models associated with any other database in the environment.

  To create repository tables:

  1. Select Tools, then Administer Repository.

  2. Choose Select to open the Select Connection dialog box and select theInteractive Reporting database connection file for the database on which you want to create repository table, or select the Interactive Reporting database connection file for the active Interactive Reporting document file.

    The Administer Repository dialog box is displayed.

  3. Click Create to open the Create Repository Tables dialog box.

  4. Change the default configuration.

    • Owner Name—Enter the database and owner names (if applicable) under which you want to create the tables. If both database and owner are specified, separate them with a period (for example, Sales.GKL).

    • Grant Tables to Public—Check Grant Tables to Public to grant general access to the repository tables at the database level.

      You must grant access to the repository tables in order for users to download data models; otherwise, you will need to manually grant access to all authorized users using a database administration tool.

      Do not grant tables to public if you need to maintain tight database security and upload privileges are only permitted for a small group of users.

    • Data Type Fields—Change default data types for column fields to match data types of the database server. If the DBMS and middle ware support a large binary data type, use it for VarData columns. If not, use the largest character data type.

  5. Click Create All to create the repository tables under the specified user.

    The All Tables Created dialog box is displayed.

    Note:

    If table creation fails, make sure the database logon ID of the server has been granted Table Create privileges.

  6. Click OK, and then click Close to close the Create All dialog box.