In This Section:
Loading Data into Sample Databases
Providing User Access to Sample Applications
The Essbase Server installation includes sample applications that are designed to familiarize you with Essbase features. Each application contains one or more databases and each database has an associated data load file, as described in Table 145:
Table 145. Sample Databases and Data Load Files
Application | Database | Data Load File |
---|---|---|
Interntl and Xchgrate databases demonstrate Essbase Currency Conversion features. | ||
Demo See the Oracle Essbase Technical Reference and documentation for Essbase Report Writer. | ||
Demonstrates Essbase Partitioning features. See Designing Partitioned Applications. | ||
Demonstrates Essbase Partitioning features. See Designing Partitioned Applications. | ||
Contains a Unicode-mode version of the Basic database in the Sample application, which includes alias tables in English and four other character sets. Characters in this application are encoded in UTF-8. | ||
DMDemo[a] Demonstrates Data Mining features. | ||
Demonstrates aggregate storage features. | dataload.txt[b] |
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 username. See Creating the Partition User.
To load data into a sample database:
Open the Administration Services Console.
From Enterprise View or a custom view, navigate to the appropriate Essbase Server, application, and database.
Right-click the database and select Load data.
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.
When the data load is completed, a dialog box appears with information about the files that loaded and whether there were errors.
Essbase provides a comprehensive security system for a secure multiple-user environment. By default, the sample applications are created with a security access level of None, which means that no user can connect to the sample databases unless the user is defined as an administrator.
The system administrator, defined when installing Essbase, automatically holds administrator privileges. Therefore, the system administrator can make the sample applications available to other users.
To provide all users with Write access to a sample application:
Log on to Administration Services Console using the system administrator account.
From Enterprise View, find the appropriate Essbase Server and application.
Right-click the application and select Edit properties.
In Application Properties, select the General tab.
For Minimum access level, select Write.
For example, if you want all users to have at least Write access to all databases in the application (meaning that all users can update data values), select Write.
From the Minimum Database Access group, select Write.
Click Apply.
Repeat this procedure for each database.
The selected application is ready for use. If you want to provide access to another application, repeat the procedure.
To prepare the sample aggregate storage application for use:
Load data using the following data and rules files:
ARBORPATH/app/ASOsamp/Sample/dataload.txt ARBORPATH/app/ASOsamp/Sample/dataload.rul
For instructions on loading data to aggregate storage databases, see the Oracle Essbase Administration Services Online Help.
Precalculate aggregations on the database to improve retrieval times, using one of these methods:
Aggregation Design Wizard in Administration Services.
See the Oracle Essbase Administration Services Online Help.
execute aggregate process MaxL statement.
See the Oracle Essbase Technical Reference.
Make sure that the essbase.jar file is in the ESSBASEPATH/java directory.
Essbase includes two sample applications and databases that demonstrate the features of Partitioning:
Samppart—Company
Sampeast—East
The Partitioning applications and databases include partition definitions stored in .ddb files. The .ddb files define the map between member combinations in the target database, Company, and the source database, East.
For the Partitioning applications to work in your environment, you may need to create a user named partitionuser (see Creating the Partition User), or change the embedded user names in the .ddb files (see Changing Embedded User Names in Sample Partition Definitions).
Before you work with the Samppart and Sampeast applications, you may need to create a user named partitionuser, which must have Application Manager access to both applications.
To create partitionuser:
Log on to Administration Services Console using the system administrator account.
In Enterprise View, navigate to the Administration Server's node and select the appropriate Essbase Administration Server name.
Right-click the User node and select Create user.
For Create user on Essbase Administration Server, enter partitionuser for Username.
For Password, type a password.
For Confirm Password, type the password again.
For Administrator privileges, select true.
Click OK.
If you choose not to create partitionuser, you can change the embedded username in the partition definition files (.ddb) to the username of your choice, as long as that user has administrator privileges. The .ddb files shipped with Samppart and Sampeast are based on the server name “localhost.”
To change the username in the Samppart.Company and Sampeast.East .ddb files:
Open Administration Services Console.
In Enterprise View, expand the Applications node and select the Samppart application.
Expand the Databases node and select the Company database.
Expand the Partitions node, select Source Databases, and then double-click:
servername:Sampeast:East [transparent]
For Data Source and Data Target, select a username from User list.
Enter the password.
Click Repair to save your changes.
Note:
If, in the Repair Partition dialog box, you changed the username for the Data Source and the Data Target groups, you do not need to repeat this process to change the username in the Sampeast.East .ddb file.