Essbase Connection Properties

The name of the data source to be used by the Essbase JNDI functionality supported by the dodeca-essbase service.

JNDI allows the specification of connection information on the dodeca-essbase service application server. This removes the need to store (encrypted) credentials in the Essbase connection metadata, which is retained on the client. It also provides a way to manage the credentials completely on the application server.

The data source refers to a JNDI connection, which is configured in the context.xml residing on the server. The context can contain three differenct JNDI connection configurations, all of which are optional and include the following:

If no DataSource is specified, Essbase connections will continue to work as they did prior to the introduction of the JNDI functionality.

The name of the Essbase application.

The name of the Essbase database.

The name of the Essbase OLAP server.

If specified, the APSUrl property overrides the aps.url setting in the dodeca-essbase.properties file associated with the dodeca-essbase service, which is identified by the ServletPath setting.

If not specified, the aps.url value specified in the dodeca-essbase.properties file is used.

The base URL of the REST API for Oracle Essbase. This value is typically in the following form: https://server:433/essbase/rest/v1.

The HTTP address where the servlet is running.

false

Cube information is obtained when an Essbase connection is used by the Dodeca client. Most of the cube information can be obtained without opening the outline, except for the following extended information: SmartLists (i.e. the text list strings and associated values for SmartLists) and the date format string.

Since opening an outline can be time consuming, setting the ExtendedCubeInformationEnabled property to False when the extended information is not needed avoids the overhead incurred when the outline is opened.

The date format string is used internally by the dodeca-essbase service in the data audit log functionality. If ExtendedCubeInformationEnabled is set to False and if date measures are updated, the data audit log tables may not accurately reflect the updated data.

true

The flag that indicates whether the servlet holds an Essbase connection in a cache on the server.

The Essbase (and Essbase Deployment Services/Analytic Provider Services) password used for operations that require administrator privileges.

Refer to the AdminUsername setting for additional information.

The Essbase (and Essbase Deployment Services/Analytic Provider Services) password used for operations that require administrator privileges.

The administrator credentials are only required and used for the following:

EssbaseAuthenticationMode.UserCredentials

Specifies whether to connect directly with provided user credentials or as the authenticated user via impersonation.

The Essbase (and Essbase Deployment Services/Analytic Provider Services) password.

false

When an authentication service is associated with the Dodeca application, the UseAuthenticatedUsernameAndPassword property controls whether the authenticated username and password are used as the Essbase connection username and password.

When an Essbase authentication service is used, the behavior is similar regardless of whether the UseAuthenticatedUsernameAndPassword property is True or False, because any connection to Essbase from the client will attempt to use the authenticated credentials unless a Username and Password are explicitly specified for the Essbase connection metadata instance. The difference is that when the UseAuthenticatedUsernameAndPassword is True and a connection fails, the default login services will not prompt the user for alternate credentials.

When a non-Essbase authentication service is used, it may be desirable to use the authenticated credentials for the Essbase connection. This can be achieved by setting the UseAuthenticatedUsernameAndPassword property to True. If the connection fails, the default login services will not prompt the user for alternate credentials.

The Essbase (and Essbase Deployment Services/Analytic Provider Services) username.

The string value that uniquely identifies the metadata.

The name of the metadata object.

false

Controls whether the XML for the requests to and responses from the server are logged on the server for all clients when using this connection. The server must have the appropriate servlet filter enabled and properly configured via parameters in the web.xml file.

The caption used by the Essbase Login dialog when prompting the user to provide credentials for this connection. If not set, the caption is derived from the connection settings.