Introduction | Information
Center
Defining, editing, and deleting Hyperion Essbase Deployment Services data source definitions
Use the Data Sources page to define an existing data source that IBM Alphablox
applications can access. This page describes the entries for defining
a data source connecting through the Essbase Enterprise Server adapter.
To define a data source:
- Click the Create button.
- In the Data Source Name text box, enter a unique data source name
(required). Allowable characters are A-Z, a-z, 0-9, underscore, or special
characters (for example, accented characters) when running in a language other
than English. The display of the name is case sensitive but the actual username
that is authenticated is case insensitive. The names Public, Private,
and Properties are reserved and cannot be used for an object name.
- In the Description text box, enter a description. The description
appears in the console when using the
show
command. A description
is not required when creating a data source definition.
- Select the Essbase Enterprise Server adapter from the Adapter drop
list.
- Provide the requested information. For more information, see:
If necessary, ask your database administrator for this information.
- Optionally, you can enter a default username and password. If these text
boxes are left blank, application users must obtain database access under
their own user names and passwords.
- Click the Save button.
Note: The username and password specified
should exist in both the Deployment Services and the OLAP/Analytic Server.
To edit a data source:
- Select a data source name from the Data Sources list box.
- Click the Edit button to delete the data source.
- Make your changes.
- Click the Save button.
To delete a data source:
- Select a data source name from the Data Sources list box.
- Click the Delete button to delete the data source.
The data source information is immediately deleted and cannot be recovered.
Enter the TCP/IP address or name of the host machine on which the Essbase Deployment Services
resides.
Enter the TCP/IP address or name of the Essbase Server where
the data source resides.
Enter the name of the Hyperion Essbase application or
catalog of the database that is being defined to IBM Alphablox. For example,
Essbase provides a sample application named Sample.
Enter the name of the Hyperion Essbase database that
the IBM Alphablox application uses. For example, Essbase provides a sample
database named Basic.
Enter the name of the Hyperion Essbase alias table that
the data source uses. If this field is blank, the default alias table is used.
The alias table is an object in the Hyperion Essbase
database used to map member names in an outline to names that are displayed
in user queries. There might be alias tables set up in the database for different
countries or regions because the names of members might change from place to
place. For example, a particular car model might be called "Milano"
in the United States and called "75" in Europe.
Related topics: