Loading Data into Sample Databases

Before you can use a sample application, you must load data into it.

Note:

Before loading data into the Partitioning sample databases, first create a partition user or other user name. See Creating the Partition User.

  To load data into a sample database:

  1. Open the Administration Services Console.

  2. From Enterprise View or a custom view, navigate to the appropriate Essbase Server, application, and database.

  3. Right-click the database and select Load data.

  4. Set the Data Load options.

    • For Data Source Type, select Data file.

    • For Mode, choose one of the following options:

      • Load only: Performs a data load.

      • Build only: Performs a dimension build.

      • Both: Performs both a data load and a dimension build.

    • For Data Source, click Find Data File. In the Essbase Server tab, navigate to the correct data source. For Files of Type, ensure that Data files (*.txt) is selected.

    • For Rules File, if the data source requires a rules file, click Find Rule File. In the Essbase Server tab, navigate to the rule file. For Files of Type, ensure that Rules file (*.rul) is selected.

      Note:

      The ASOsamp database must be loaded using the dataload.rul file. The other samples do not require a rules file.

When the data load is completed, a dialog box appears with information about the files that loaded and whether there were errors.