com.essbase.api.datasource

Interface IEssOlapServer

All Superinterfaces:

IEssAppComponent, IEssBaseObject, IEssExtendedObject, IEssProperties, IEssServer, IEssSubstitutionVariables

public interface IEssOlapServer
extends IEssServer, IEssExtendedObject, IEssProperties, IEssAppComponent, IEssSubstitutionVariables

The IEssOlapServer interface is the OLAP server (Essbase). JAPI opens and shares a single connection with Essbase between all its interfaces for each JAPI session. JAPI uses counters to track the number of interfaces using the connection based on the IEssCube.openCubeView/ IEssDomain.openCubeView/IEssCube.openMemberSelection() calls and hence the number of close/disconnect calls should match the number of open calls for a proper closure of the connection.

Version:

1.0, 01/04/2004

Author:

Oracle Corporation

Nested Class Summary

Nested Classes

Modifier and Type	Interface and Description
static interface	IEssOlapServer.IEssOlapConnectionInfo The IEssOlapConnectionInfo interface provides OLAP agent/server connection information.

Nested classes/interfaces inherited from interface com.essbase.api.domain.IEssServer

IEssServer.EEssServerType

Nested classes/interfaces inherited from interface com.essbase.api.base.IEssProperties

IEssProperties.EEssPropertyMode

Nested classes/interfaces inherited from interface com.essbase.api.domain.IEssAppComponent

IEssAppComponent.EEssAppComponentType

Field Summary

Fields

Modifier and Type	Field and Description
static int	ESS_UDF_FUNCTION_RUNTIME
static int	ESS_UDF_FUNCTION_SINGLECELL
static int	ESS_UDF_FUNCTION_TRIGGER_FUNC
static int	ESS_UDF_FUNCTION_VECTOR
static int	PROP_DESCRIPTION
static int	PROP_NAME
static int	s_countProperties
static IEssValueAny.EEssDataType[]	s_propDataTypes
static IEssProperties.EEssPropertyMode[]	s_propModes
static java.lang.String[]	s_propNames

Method Summary

Modifier and Type	Method and Description
void	changeOlapPassword(java.lang.String userName, java.lang.String oldPassword, java.lang.String newPassword) Changes the password of a user at OLAP server.
void	clearActive() Clears the current active application and database for this instance of the IEssOLAPServer object.
void	clearActivePlugin() Clears the current active pluggable engine for this instance of the IEssOLAPServer object.
void	connect() Opens a connection to the olap agent.
void	connect(boolean useEdsAtOlapSvrNode) Deprecated. This functionality has been deprecated.
void	connect(boolean useConnPool, boolean connPerOp) Deprecated. This functionality has been deprecated.
void	connect(boolean useConnPool, boolean connPerOp, boolean useCluster, java.lang.String connPoolOrClusterName) Deprecated. This functionality has been deprecated.
void	convertApplicationToUnicode(java.lang.String appName) Converts application to unicode.
void	copyOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName, java.lang.String destAppName, java.lang.String destCubeName, java.lang.String destObjName) Copies an olap file object.
void	copyOlapFileObjectFromServer(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName, java.io.OutputStream out, boolean lock) Copies an object from the olap server to a client file using output stream and optionally locks the server object to prevent updates by others.
void	copyOlapFileObjectFromServer(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName, java.lang.String clientFileName, boolean lock) Copies an object from the olap server to a client file and optionally locks the server object to prevent updates by others.
void	copyOlapFileObjectToServer(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName, java.io.InputStream in, boolean unlock, long totalLength) Copies an object from a client file to the olap server, and optionally unlocks the server object to allow updates by others.
void	copyOlapFileObjectToServer(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName, java.lang.String clientFileName, boolean unlock) Copies an object from a client file to the olap server, and optionally unlocks the server object to allow updates by others.
IEssOlapApplication	createApplication(java.lang.String appName) Creates a new application and starts it.
IEssOlapApplication	createApplication(java.lang.String appName, short storageType) Creates a new application with the given storage type and starts it.
IEssOlapApplication	createApplication(java.lang.String appName, short storageType, java.lang.String appType) Creates a new application and starts it.
IEssOlapApplication	createApplication(java.lang.String appName, java.lang.String appType) Creates a new application and starts it.
IEssOlapApplication	createApplication(java.lang.String appName, java.lang.String desc, int maxLroFileSize, boolean loadable, boolean autoLoad, boolean allowCommands, boolean allowConnects, boolean allowUpdates, boolean enableSecurity, int lockTimeOutPeriod, IEssCube.EEssCubeAccess minCubeAccess) Creates a new application setting all the specified properties and starts it.
void	createCDF(java.lang.String name, java.lang.String javaSpec, int options, java.lang.String spec, java.lang.String comment) Creates a custom defined function.
void	createCDM(java.lang.String name, java.lang.String definition, java.lang.String signature, java.lang.String spec, java.lang.String comment) Creates custom defined macro.
IEssOlapUser	createOlapExtUser(java.lang.String userName, java.lang.String password, java.lang.String protocol, java.lang.String connParam) Creates a new externally authenticated user.
IEssOlapUser	createOlapExtUserWithType(java.lang.String userName, java.lang.String password, java.lang.String protocol, java.lang.String connParam, short userType) Creates a externally authenticated user with specified application access type.
void	createOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName) Creates a new olap file object.
IEssOlapGroup	createOlapGroup(java.lang.String groupName) Creates a new group.
IEssOlapUser	createOlapUser(java.lang.String userName, java.lang.String password) Creates a new user.
IEssOlapUser	createOlapUserWithType(java.lang.String userName, java.lang.String password, short userType) Creates a new user with specified application access type.
IEssOlapApplication	createShadowApplication(java.lang.String primaryAppName, java.lang.String shadowAppName, boolean hideShadow, int waitForOngoingUpdatesInSecs) Puts the specified primary application on read-only mode and creates a shadow application (a complete copy) out of the primary application, so that one can leverage capabilities of cube modifications and outline restructure on the shadow application, while the primary serves all kinds of read-only operations like queries, etc.
void	delete() Deletes this server from the domain if it exists.
void	deleteCDF(java.lang.String name) Deletes custom defined function.
void	deleteCDM(java.lang.String name) Deletes custom defined macro.
void	deleteLogFile() Deletes the agent log file (essbase.log).
void	deleteOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName) Delete an existing olap file object.
void	disconnect() Closes the connection to the olap agent.
void	dropShadowApplication(java.lang.String shadowAppName) Forcefully deletes the specified shadow application.
java.lang.String[]	getActive() Gets the names of the current active application and cube for this instance of the IEssOlapServer object.
com.essbase.api.scripting.IEssPluggableEngine	getActivePlugin() Gets the instance of active pluggable engine for this instance of the IEssOlapServer object.
java.lang.String[]	getAllApplicationNames() Fetches the names of regular (visible) as well as hidden applications.
java.lang.String	getAllConnectionsParameters(java.lang.String appName, java.lang.String dbName) Gets all parameters that are associated with current connection
IEssOlapApplication	getApplication(java.lang.String appName) Gets the specified application.
IEssIterator	getApplications() Gets the list of applications which are accessible to the caller.
java.lang.String[][]	getCDM_CDF() Gets custom defined functions and macros.
IEssIterator	getConnections() Gets the list of user connections to the olap agent/server.
IEssIterator	getConnections(long sessionId, java.lang.String username, java.lang.String appname, java.lang.String cubeName) Retrieves the list of user session and request information from the olap agent/server.
java.lang.String	getDescription() Gets the olap server description.
java.util.Map<java.lang.String,java.lang.String>	getEssbaseConfigValues() Deprecated.
java.util.Map<java.lang.String,java.util.List<java.lang.String>>	getEssbaseConfigValuesEx() API to get Essbase config value from Essbase.cfg as key value pairs
java.lang.String[]	getHiddenApplicationNames() Fetches the names of hidden applications, if any.
boolean	getIgnoreCellProperties() Get the ignore cell properties value.
java.lang.String	getLocale() Returns the locale of the OLAP server.
long	getLoginId() Returns the signed-in user's login ID for the particular session.
int	getLogSize(boolean agentLog, java.lang.String appName) Gets the size of the Agent log file (ESSBASE.LOG), or of the Server log file (APPNAME.LOG).
IEssCustomMessageHandler	getMessageHandler() Retrieves the custom message handler associated with the session.
java.lang.String	getName() Gets the olap server name/IP address.
IEssOlapFileObject	getOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName) Gets information about a specified olap store file object.
IEssIterator	getOlapFileObjects(java.lang.String appName, java.lang.String cubeName, int objType) Gets all the olap store file objects of the types specified.
IEssOlapGroup	getOlapGroup(java.lang.String groupName) Gets olap group information for the given group.
IEssIterator	getOlapGroups(java.lang.String appName, java.lang.String cubeName) Lists all groups who have access to this Essbase, and given application or cube.
IEssOlapLicenseInfo	getOlapLicenseInfo(java.lang.String serverColumnPort) Get the License information structure.
short	getOlapSecurityMode() Displays the type of security in use: native or Shared Services mode.
java.lang.String	getOlapServerVersion() Gets the full version number of the connected Essbase olap server, in the form release.version.revision.
IEssOlapUser	getOlapUser(java.lang.String userName) Gets a user information structure, which contains security information for the user.
IEssIterator	getOlapUsers(java.lang.String appName, java.lang.String cubeName, java.lang.String protocol, boolean bExternalOnly) Lists all users who have access to a particular Essbase server, application or cube.
com.essbase.api.scripting.IEssPluggableEngine[]	getPluggableEngines(java.lang.String string) Gets the array of pluggable engines for this instance of the IEssOlapServer object.
java.lang.String[]	getRegularApplicationNames() Fetches the names of regular (visible) applications.
IEssIterator	getRequests(java.lang.String userName, java.lang.String appName, java.lang.String cubeName) Gets all the requests at the olap server for the matching userName, appName or cubeName.
java.lang.String	getStartCommand() Deprecated. This functionality has been deprecated.
com.essbase.api.datasource.SystemInfo	getSystemInfo() Provides system information which includes amount of free RAM, CPU usage and free application disk space.
boolean	isConnected() Checks if a connection is open to the olap agent.
IEssOlapFileObject	isOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName) Verifies and retrieves the information about the specified Essbase file object.
boolean	isUnicodeEnabled() Checks if server is unicode enabled.
void	killLastRequest() Deprecated. Replaced with killOwnRequest()
void	killOwnRequest() Kills the last request to a server issued by a user from the same session if it is still running.
void	killPluggableEngines(com.essbase.api.scripting.IEssPluggableEngine[] engines) Kills the pluggable engines for this instance of the IEssOlapServer object.
java.lang.String[]	listSchemas() Returns a accessible list of schemas for the active user.
void	lockOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName) Locks an object on the server to prevent other users from updating it.
void	moveApplication(java.lang.String sourceAppName, java.lang.String destAppName, boolean overwriteIfExists, int timeoutToForceUnloadApp) Moves one application as another.
IEssMaxlSession	openMaxlSession(java.lang.String MaxlSessionName) Opens a Maxl session with the Analytic server and returns a handle to the session.
void	promoteShadowApplication(java.lang.String shadowAppName, java.lang.String baseAppName, int timeoutToForceUnloadApp) Promotes the shadowed application as the base application.
void	refreshPropertyValues() Refreshes the property values.
void	renameOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName, java.lang.String newObjName) Renames an existing olap file object.
void	reRegisterAllApplications() Re-establishes all Analytic Services applications as Shared Services applications.
void	resetTimeoutParameters() Reset JAPI timeout parameters
void	resyncSSSecurity() Synchronizes the Essbase security definitions for all users, groups, and applications with the current state of Shared Services security.
void	setActive(java.lang.String appName, java.lang.String cubeName) Sets the active application and cube for this instance of the IEssOlapServer object.
com.essbase.api.scripting.IEssPluggableEngine	setActivePlugin(java.lang.String pluginName) Sets the active pluggable engine for this instance of the IEssOlapServer object.
void	setConnectionParameter(java.lang.String appName, java.lang.String dbName, java.lang.String name, java.lang.String value) Connection parameters setting method
void	setDescription(java.lang.String desc) Sets the olap server description.
void	setIgnoreCellProperties(boolean ignoreCellProperties) Sets the ignore cell properties value.
void	setMessageHandler(IEssCustomMessageHandler handler) Associates the Custom message handler to the session.
void	setStartCommand(java.lang.String startCmd) Deprecated. This functionality has been deprecated.
void	setTimeoutParameters(int netRetryCount, boolean tryInfinite) Sets JAPI timeout parameters
void	setUnicodeEnabled(boolean enabled) Sets the server unicode enabled.
void	start() Deprecated. This functionality has been deprecated.
void	start(java.lang.String osUserName, java.lang.String osUserPassword, java.lang.String osDomainName) Deprecated. This functionality has been deprecated.
void	stop() Deprecated. This functionality has been deprecated.
void	syncGroups() Forces all groups' security information to be synchronized with the current group information in Shared Services.
void	syncUser(java.lang.String user) Forces a user's/group's security information to be synchronized with that user's/group's current information in Shared Services.
void	syncUsers() Forces all users' security information to be synchronized with the current user information in Shared Services.
void	syncUsersAndGroupsWithApp(IEssOlapApplication application) Synchronize the Essbase application's security definitions so that all users and groups in the application match with the current state of Shared Services security.
void	unlockOlapFileObject(java.lang.String appName, java.lang.String cubeName, int objType, java.lang.String objName) Unlocks a locked object on the server.
void	updatePropertyValues() Updates the property values.
void	writeToLogFile(boolean agentLog, java.lang.String message) Writes a message to the agent log file (essbase.log) or to the server log file (appname.log).

Methods inherited from interface com.essbase.api.domain.IEssServer

getServerType

Methods inherited from interface com.essbase.api.base.IEssExtendedObject

clearClientCache, getParent, getParentBase, isClientCachingEnabled, setClientCachingEnabled

Methods inherited from interface com.essbase.api.base.IEssProperties

getCountProperties, getPropertyDataType, getPropertyDataType, getPropertyDataTypes, getPropertyId, getPropertyMode, getPropertyMode, getPropertyModes, getPropertyName, getPropertyNames, getPropertyValueAny, getPropertyValueAny, setPropertyValueAny, setPropertyValueAny

Methods inherited from interface com.essbase.api.domain.IEssAppComponent

getAppComponentType

Methods inherited from interface com.essbase.api.datasource.IEssSubstitutionVariables

createSubstitutionVariable, deleteSubstitutionVariable, getSubstitutionVariables, getSubstitutionVariableValue

Field Detail

PROP_NAME

static final int PROP_NAME

See Also:

Constant Field Values

PROP_DESCRIPTION

static final int PROP_DESCRIPTION

See Also:

Constant Field Values

s_countProperties

static final int s_countProperties

See Also:

Constant Field Values

s_propNames

static final java.lang.String[] s_propNames

s_propDataTypes

static final IEssValueAny.EEssDataType[] s_propDataTypes

s_propModes

static final IEssProperties.EEssPropertyMode[] s_propModes

ESS_UDF_FUNCTION_VECTOR

static final int ESS_UDF_FUNCTION_VECTOR

See Also:

Constant Field Values

ESS_UDF_FUNCTION_SINGLECELL

static final int ESS_UDF_FUNCTION_SINGLECELL

See Also:

Constant Field Values

ESS_UDF_FUNCTION_TRIGGER_FUNC

static final int ESS_UDF_FUNCTION_TRIGGER_FUNC

See Also:

Constant Field Values

ESS_UDF_FUNCTION_RUNTIME

static final int ESS_UDF_FUNCTION_RUNTIME

See Also:

Constant Field Values

Method Detail

getName

java.lang.String getName()
                  throws com.essbase.api.base.EssException

Gets the olap server name/IP address.

Specified by:

getName in interface IEssExtendedObject

Returns:

The olap server name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getDescription

java.lang.String getDescription()
                         throws com.essbase.api.base.EssException

Gets the olap server description.

Returns:

The olap server description.

Throws:

com.essbase.api.base.EssException - if an error occurs.

setDescription

void setDescription(java.lang.String desc)
             throws com.essbase.api.base.EssException

Sets the olap server description. The change will become effective after you invoke updatePropertyValues().

Parameters:

desc - The olap server description.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getStartCommand

java.lang.String getStartCommand()
                          throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Gets the command to start this olap server.

Returns:

The startup command.

Throws:

com.essbase.api.base.EssException - if an error occurs.

setStartCommand

void setStartCommand(java.lang.String startCmd)
              throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Sets the command to start this olap server. The change will become effective after you invoke updatePropertyValues().

Parameters:

startCmd - The startup command.

Throws:

com.essbase.api.base.EssException - if an error occurs.

refreshPropertyValues

void refreshPropertyValues()
                    throws com.essbase.api.base.EssException

Refreshes the property values. The JAPI cache for this object is refreshed with the latest values from the server, so that all the getXXX() methods will return the latest values.

Specified by:

refreshPropertyValues in interface IEssProperties

Throws:

com.essbase.api.base.EssException - if an error occurs.

updatePropertyValues

void updatePropertyValues()
                   throws com.essbase.api.base.EssException

Updates the property values. The changes made to this object via setXXX() methods will become effective only after you invoke updatePropertyValues().

Specified by:

updatePropertyValues in interface IEssProperties

Throws:

com.essbase.api.base.EssException - if an error occurs.

connect

void connect()
      throws com.essbase.api.base.EssException

Opens a connection to the olap agent. JAPI opens and shares a single connection with Essbase between all its interfaces for each JAPI session. JAPI uses counters to track the number of interfaces using the connection based on the IEssCube.openCubeView/IEssDomain.openCubeView/IEssCube.openMemberSelection() calls and hence the number of close/disconnect calls should match the number of open calls for a proper closure of the connection.

Throws:

com.essbase.api.base.EssException - if an error occurs.

connect

void connect(boolean useConnPool,
             boolean connPerOp)
      throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Opens a connection to the olap agent. This method allows you to use a connection pool if available and the rest of the connect methods don't use a connection pool.

Parameters:

useConnPool - true to use connection pool if available.

connPerOp - true for connection per operation. false for connection per session.

Throws:

com.essbase.api.base.EssException - if an error occurs.

connect

void connect(boolean useConnPool,
             boolean connPerOp,
             boolean useCluster,
             java.lang.String connPoolOrClusterName)
      throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Opens a connection to the olap agent. This method allows you to use a connection pool if available and the rest of the connect methods don't use a connection pool.

Parameters:

useConnPool - true to use connection pool if available.

connPerOp - true for connection per operation. false for connection per session.

useCluster - true to use cluster if available.

connPoolOrClusterName - connection pool or cluster name to use. If useConnPool is true, this parameter represents connection pool name. If useCluster is true, this parameter represents cluster name. If this parameter is null, a connection pool or a cluster will be chosen, if available, based on the values of other parameters. If it is not null then it should be a valid active connection pool or cluster name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

connect

void connect(boolean useEdsAtOlapSvrNode)
      throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Opens a connection to the olap agent.

Parameters:

useEdsAtOlapSvrNode - If true, the Provider server at the node where this olap server resides is used to traffic the requests between the JAPI client and the olap server. If false, the enterprise server that authenticated the user is used to traffic the requests.

Throws:

com.essbase.api.base.EssException - if an error occurs.

disconnect

void disconnect()
         throws com.essbase.api.base.EssException

Closes the connection to the olap agent. If connection pool is used to obtain the connection, the connection is returned back to the pool.

Throws:

com.essbase.api.base.EssException - if an error occurs.

isConnected

boolean isConnected()
             throws com.essbase.api.base.EssException

Checks if a connection is open to the olap agent. Since 12c version, this will attempt to connect to Essbase agent using the existing session and will return false if it fails. However, invoke the disconnect() to ensure proper session cleanup.

Returns:

true if a connection if open.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapServerVersion

java.lang.String getOlapServerVersion()
                               throws com.essbase.api.base.EssException

Gets the full version number of the connected Essbase olap server, in the form release.version.revision.

Returns:

The version number.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getApplications

IEssIterator getApplications()
                      throws com.essbase.api.base.EssException

Gets the list of applications which are accessible to the caller.

Returns:

The applications (each of type IEssOlapApplication).

Throws:

com.essbase.api.base.EssException - if an error occurs.

getApplication

IEssOlapApplication getApplication(java.lang.String appName)
                            throws com.essbase.api.base.EssException

Gets the specified application.

Parameters:

appName - The application name.

Returns:

The application.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapUser

IEssOlapUser getOlapUser(java.lang.String userName)
                  throws com.essbase.api.base.EssException

Gets a user information structure, which contains security information for the user.

Parameters:

userName - The olap user username.

Returns:

IEssOlapUser The OLAP user

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapUsers

IEssIterator getOlapUsers(java.lang.String appName,
                          java.lang.String cubeName,
                          java.lang.String protocol,
                          boolean bExternalOnly)
                   throws com.essbase.api.base.EssException

Lists all users who have access to a particular Essbase server, application or cube.

Parameters:

appName - - Application name. If null, lists all users.

cubeName - - cube name. If null, lists users for all cubes within application.

protocol - - The name of the external authentication mechanism. This can be null if bExternalOnly is false. - Values are CSS/Client Authentication

bExternalOnly - - true - returns list of external users; false - returns all users

Returns:

IEssIterator - Iterator of EssUSERINFO objects.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapGroup

IEssOlapGroup getOlapGroup(java.lang.String groupName)
                    throws com.essbase.api.base.EssException

Gets olap group information for the given group.

Parameters:

groupName - The olap group name.

Returns:

IEssOlapGroup The OLAP user

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapGroups

IEssIterator getOlapGroups(java.lang.String appName,
                           java.lang.String cubeName)
                    throws com.essbase.api.base.EssException

Lists all groups who have access to this Essbase, and given application or cube.

Parameters:

appName - - Application name. If null, lists all groups.

cubeName - - cube name. If null, lists groups for all cubes within application.

Returns:

IEssIterator of the groups

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapLicenseInfo

IEssOlapLicenseInfo getOlapLicenseInfo(java.lang.String serverColumnPort)
                                throws com.essbase.api.base.EssException

Get the License information structure.

Parameters:

serverColumnPort - The server column port.

Returns:

the License information obejct

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapSecurityMode

short getOlapSecurityMode()
                   throws com.essbase.api.base.EssException

Displays the type of security in use: native or Shared Services mode.

Returns:

short - the security mode ESS_NATIVE_SECURITY 1 ESS_CAS_SECURITY 2 ESS_SS_SECURITY 2

Throws:

com.essbase.api.base.EssException - if an error occurs.

createOlapUser

IEssOlapUser createOlapUser(java.lang.String userName,
                            java.lang.String password)
                     throws com.essbase.api.base.EssException

Creates a new user. The specified user must not already exist. This function requires the caller to have Create/Delete User privilege (ESS_PRIV_USERCREATE) for the logged in server.

Parameters:

userName - - Name of user to create. User names can be 30 characters long.

password - - Security password for new user. Passwords can be up to 100 characters long.

Returns:

IEssOlapUser The new olap user.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createOlapExtUser

IEssOlapUser createOlapExtUser(java.lang.String userName,
                               java.lang.String password,
                               java.lang.String protocol,
                               java.lang.String connParam)
                        throws com.essbase.api.base.EssException

Creates a new externally authenticated user. The specified user must already exist in specified external authentication provider. The parameter password is ignored. This function requires the caller to have Create/Delete User privilege (ESS_PRIV_USERCREATE) for the logged in server.

Parameters:

userName - - Name of user to create. User names can be 30 characters long.

password - - Security password for new user. Passwords can be up to 100 characters long.

protocol - - The name of the external authentication mechanism.

connParam - - Parameters used by the external authentication mechanism, if any.

Returns:

IEssOlapUser The new externally authenticated user.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createOlapUserWithType

IEssOlapUser createOlapUserWithType(java.lang.String userName,
                                    java.lang.String password,
                                    short userType)
                             throws com.essbase.api.base.EssException

Creates a new user with specified application access type. The specified user must not already exist. This function requires the caller to have Create/Delete User privilege (ESS_PRIV_USERCREATE) for the logged in server.

Parameters:

userName - - Name of user to create. User names can be 30 characters long.

password - - Security password for new user. Passwords can be up to 100 characters long.

userType - - Application access type for a user. Possible values 0 - for ESS_USER_NONE which means this user will be enabled without any functionality. or 1 - for ESS_USER_ESSBASE which means this user will be enabled with all functionality.

Returns:

IEssOlapUser The new user with specified application access type.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createOlapExtUserWithType

IEssOlapUser createOlapExtUserWithType(java.lang.String userName,
                                       java.lang.String password,
                                       java.lang.String protocol,
                                       java.lang.String connParam,
                                       short userType)
                                throws com.essbase.api.base.EssException

Creates a externally authenticated user with specified application access type. The specified user must already exist in the specified external authentication mechanism. This function requires the caller to have Create/Delete User privilege (ESS_PRIV_USERCREATE) for the logged in server.

Parameters:

userName - - Name of user to create. User names can be 30 characters long.

password - - Security password for new user. Passwords can be up to 100 characters long.

protocol - - Name of the external authentication mechanism

connParam - - Parameters used by external authentication mechanism, if any..

userType - - Application access type for a user. Possible values 0 - for ESS_USER_NONE which means this user will be enabled without any functionality. or 1 - for ESS_USER_ESSBASE which means this user will be enabled with all functionality.

Returns:

IEssOlapUser a externally authenticated user with specified application access type.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createApplication

IEssOlapApplication createApplication(java.lang.String appName)
                               throws com.essbase.api.base.EssException

Creates a new application and starts it.

Parameters:

appName - The application name.

Returns:

IEssApplication The new application.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createApplication

IEssOlapApplication createApplication(java.lang.String appName,
                                      java.lang.String appType)
                               throws com.essbase.api.base.EssException

Creates a new application and starts it.

Parameters:

appName - The application name.

appType - The application type ("native" or "utf8").

Returns:

IEssApplication The new application.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createApplication

IEssOlapApplication createApplication(java.lang.String appName,
                                      java.lang.String desc,
                                      int maxLroFileSize,
                                      boolean loadable,
                                      boolean autoLoad,
                                      boolean allowCommands,
                                      boolean allowConnects,
                                      boolean allowUpdates,
                                      boolean enableSecurity,
                                      int lockTimeOutPeriod,
                                      IEssCube.EEssCubeAccess minCubeAccess)
                               throws com.essbase.api.base.EssException

Creates a new application setting all the specified properties and starts it.

Parameters:

appName - The application name.

desc - the description for this new application.

maxLroFileSize - the maximum file size (in bytes) for Linked Reporting Objects (LRO) attachments. Pass 0 for unlimited file size. There is no default. There is no minimum or maximum value, excepting limitations imposed by your system resources.

loadable - if set to false, prevents all users from loading (starting) the application. Loadable is enabled by default. If set to true, allows users to load (start) the application. This only applies to users who have at least read privilege for the application.

autoLoad - can be set to true if you want the application to load automatically when Analytic Server starts. By default, auto load is disabled.

allowCommands - if set to false, prevents all requests to databases in the application, including non-data-specific requests, such as viewing database information or changing database settings. All users are affected, including other administrators. Administrators are affected by this setting as a safety mechanism to prevent accidental updates to databases during maintenance operations. This setting remains in effect only for the duration of your session. The setting takes effect immediately, and affects users who are currently logged in, as well as users who log in later during your session. [Caution: If performing maintenance operations that require disabling commands, you must make those maintenance operations within the same session]. By default, commands are enabled.

allowConnects - if set to false, prevents any user with a permission lower than Application Managers from making connections to the databases that require the databases to be started. Database connections remain disabled for all databases in the application, until the application setting is re-enabled by setting this to true. By default, connections are enabled.

allowUpdates - if set to false, prevents all users (except Administrators) from making requests to databases in the application. Use before performing update and maintenance operations. The disable updates setting remains in effect only for the duration of your session. [Caution: If performing maintenance operations that require updates to be disabled, you must make those maintenance operations within the same session]. This restriction does not include outline operations. To block metadata updates, set the database to read-only mode, or disable commands and/or connects. By default, updates are enabled.

enableSecurity - when security is disabled, OLAP server ignores all security settings in the application and treats all users as Application Managers. By default, security is enabled.

lockTimeOutPeriod - the time out period (in minutes). This is the the maximum time interval that locks on data blocks can be held by users. When a client data-block lock is held for more than the time out interval, OLAP server removes the lock and the transaction is rolled back. The default interval is 60 minutes. This setting affects all databases in the application.

minCubeAccess - the minimum cube access. This is to grant all users a minimum level of permission to all databases in the application. Users with higher permissions than this specified minimum are not affected.

Returns:

IEssApplication The new application.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createApplication

IEssOlapApplication createApplication(java.lang.String appName,
                                      short storageType)
                               throws com.essbase.api.base.EssException

Creates a new application with the given storage type and starts it.

Parameters:

appName - The application name.

storageType - The application storagetype - Only valid value in this version is 4 which creates an ASO (Aggregate Storage Option) type application.

Returns:

IEssApplication The new application.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createApplication

IEssOlapApplication createApplication(java.lang.String appName,
                                      short storageType,
                                      java.lang.String appType)
                               throws com.essbase.api.base.EssException

Creates a new application and starts it.

Parameters:

appName - The application name.

storageType - The application storagetype - Only valid value in this version is 4 which creates an ASO (Aggregate Storage Option) type application.

appType - The application type ("native" or "utf8").

Returns:

IEssApplication The new application.

Throws:

com.essbase.api.base.EssException - if an error occurs.

convertApplicationToUnicode

void convertApplicationToUnicode(java.lang.String appName)
                          throws com.essbase.api.base.EssException

Converts application to unicode.

Note: If the application is already retrieved before using this API, user has to call getApplication(String) again to get the updated, valid application handle.

Parameters:

appName - The application name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createShadowApplication

IEssOlapApplication createShadowApplication(java.lang.String primaryAppName,
                                            java.lang.String shadowAppName,
                                            boolean hideShadow,
                                            int waitForOngoingUpdatesInSecs)
                                     throws com.essbase.api.base.EssException

Puts the specified primary application on read-only mode and creates a shadow application (a complete copy) out of the primary application, so that one can leverage capabilities of cube modifications and outline restructure on the shadow application, while the primary serves all kinds of read-only operations like queries, etc.

This is especially useful because the outline restructure could take a very long time, depending on the size of the application. Instead of reporting users being blocked by the downtime due to restructure, a shadow solution helps them work on primary application while restructure is happening on this shadow application.

Note that a shadow application can be made as hidden copy of the primary application. This means if you invoke getApplications(), you will not see the shadow application in that list.

The parameter, waitForOngoingUpdatesInSecs allows to control how long the copying process can wait, if there are any ongoing write-operations on the cubes(s) of this application. For example, if there is a dataload in progress, the cloning process will fail. If you specified waitForOngoingUpdatesInSecs as 60, Essbase will wait upto one minute for dataload to complete before initiating cloning process. If dataload doesn't complete within this specified wait-interval, Essbase will not do the copy and fail indicating the same with an error; the dataload will continue.

Parameters:

primaryAppName - Source application name which you intend to clone.

shadowAppName - Unique Destination or secondary application name which will be a copy of the source.

hideShadow - Specify true to hide the application, otherwise false.

waitForOngoingUpdatesInSecs - Waiting period (in seconds) for any active write-operations to complete.

Returns:

A copy (shadow) of the primary application.

Throws:

com.essbase.api.base.EssException - in the event of failing to create the shadow application.

See Also:

getHiddenApplicationNames()

setUnicodeEnabled

void setUnicodeEnabled(boolean enabled)
                throws com.essbase.api.base.EssException

Sets the server unicode enabled.

Parameters:

enabled - true to unicode enable the server.

Throws:

com.essbase.api.base.EssException - if an error occurs.

isUnicodeEnabled

boolean isUnicodeEnabled()
                  throws com.essbase.api.base.EssException

Checks if server is unicode enabled.

Returns:

true if server is unicode enabled.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getConnections

IEssIterator getConnections()
                     throws com.essbase.api.base.EssException

Gets the list of user connections to the olap agent/server.

Returns:

The user connections (each of type IEssOlapConnectionInfo).

Throws:

com.essbase.api.base.EssException - if an error occurs.

getConnections

IEssIterator getConnections(long sessionId,
                            java.lang.String username,
                            java.lang.String appname,
                            java.lang.String cubeName)
                     throws com.essbase.api.base.EssException

Retrieves the list of user session and request information from the olap agent/server. This API will provide an Iterator containing instances that implement IEssOlapServer.IEssOlapConnectionInfo and IEssOlapRequest. To retrieve all the session and request details, type cast the iterator elements to IEssOlapServer.IEssOlapConnectionInfo and IEssOlapRequest To retrieve just the session details type cast the iterator to IEssOlapServer.IEssOlapConnectionInfo and to get the request details only type cast the iterator to IEssOlapRequest and call the desired methods to get the the particular details.

To retrieve all the sessions currently active pass the sessionId as -1 and null for all the rest three arguments. Example:

 IEssIterator iterator = (IEssOlapConnectionInfo)olapSvr.getConnections(-1, null, null, null);

To retrieve the session information of a particular session id, pass the session id with other values as null. Example:

 IEssIterator iterator = (IEssOlapConnectionInfo)olapSvr.getConnections(10332012, null, null, null);

To retrieve the sessions for a combination of userName, appName and cubeName pass the sessionId as -1 and the relevant userName, appName and cubeName for which the session details are required. Example:

 IEssIterator iterator = (IEssOlapConnectionInfo)olapSvr.getConnections(-1, userName, appName, cubeName);

Note: If a valid sessionId is specified then all other arguments are ignored and the details of only that sessionId will be returned.

Parameters:

sessionId - - The session id of the required session.

username - - The user name of the user to which the session belongs.

appname - - The application name top which the session is open.

cubeName - - The cube name to which the session is open.

Returns:

The user sessions iterator.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getActive

java.lang.String[] getActive()
                      throws com.essbase.api.base.EssException

Gets the names of the current active application and cube for this instance of the IEssOlapServer object.

Returns:

The app/cube name pair (String[0] - appName, String[1] - cubeName). null if no active application/cube.

Throws:

com.essbase.api.base.EssException - if an error occurs.

setActive

void setActive(java.lang.String appName,
               java.lang.String cubeName)
        throws com.essbase.api.base.EssException

Sets the active application and cube for this instance of the IEssOlapServer object.

Parameters:

appName - The application name.

cubeName - The cube name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

clearActive

void clearActive()
          throws com.essbase.api.base.EssException

Clears the current active application and database for this instance of the IEssOLAPServer object.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getActivePlugin

com.essbase.api.scripting.IEssPluggableEngine getActivePlugin()
                                                       throws com.essbase.api.base.EssException

Gets the instance of active pluggable engine for this instance of the IEssOlapServer object.

Returns:

The IEssPluggableEngine reference. null if no active engine here.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getPluggableEngines

com.essbase.api.scripting.IEssPluggableEngine[] getPluggableEngines(java.lang.String string)
                                                             throws com.essbase.api.base.EssException

Gets the array of pluggable engines for this instance of the IEssOlapServer object.

Parameters:

string - Instance of IEssOlapServer.

Returns:

The IEssPluggableEngine reference. null if no active application/cube.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getSystemInfo

com.essbase.api.datasource.SystemInfo getSystemInfo()
                                             throws com.essbase.api.base.EssException

Provides system information which includes amount of free RAM, CPU usage and free application disk space. In addition it includes information about predefined system limits.

Returns:

SystemInfo reference

Throws:

com.essbase.api.base.EssException - if an error occurs.

killPluggableEngines

void killPluggableEngines(com.essbase.api.scripting.IEssPluggableEngine[] engines)
                   throws com.essbase.api.base.EssException

Kills the pluggable engines for this instance of the IEssOlapServer object.

Parameters:

engines - the list of engines to kill

Throws:

com.essbase.api.base.EssException - if an error occurs.

setActivePlugin

com.essbase.api.scripting.IEssPluggableEngine setActivePlugin(java.lang.String pluginName)
                                                       throws com.essbase.api.base.EssException

Sets the active pluggable engine for this instance of the IEssOlapServer object.

Parameters:

pluginName - Name of the plugin to be set.

Returns:

the instance of the IEssPluggableEngine

Throws:

com.essbase.api.base.EssException - if an error occurs.

clearActivePlugin

void clearActivePlugin()
                throws com.essbase.api.base.EssException

Clears the current active pluggable engine for this instance of the IEssOLAPServer object.

Throws:

com.essbase.api.base.EssException - if an error occurs.

start

void start()
    throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Starts the OLAP agent if it is not already running.

Throws:

com.essbase.api.base.EssException - if an error occurs.

start

void start(java.lang.String osUserName,
           java.lang.String osUserPassword,
           java.lang.String osDomainName)
    throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Starts the OLAP agent if it is not already running.

Parameters:

osUserName - The OS user name on the destination host.

osUserPassword - The OS user password.

osDomainName - The OS domain name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

stop

void stop()
   throws com.essbase.api.base.EssException

Deprecated. This functionality has been deprecated.

Stops the Essbase OLAP Agent. This function sends a request to the Essbase Agent (ESSBASE.EXE) to shut itself down. The Agent then goes through its normal shutdown procedure, including committing data, stopping all applications and databases, and logging users off before stopping. Only users with Supervisor privilege can shut down the Agent. This function can be called at any time, however, it is normally called to shut down an Agent process which was started in the background.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getLogSize

int getLogSize(boolean agentLog,
               java.lang.String appName)
        throws com.essbase.api.base.EssException

Gets the size of the Agent log file (ESSBASE.LOG), or of the Server log file (APPNAME.LOG).

Parameters:

agentLog - If true, the size of the Agent log file (ESSBASE.LOG) is returned. If false, the size of the Server log file (APPNAME.LOG) is returned.

appName - The application name.

Returns:

The size of the log file.

Throws:

com.essbase.api.base.EssException - if an error occurs.

writeToLogFile

void writeToLogFile(boolean agentLog,
                    java.lang.String message)
             throws com.essbase.api.base.EssException

Writes a message to the agent log file (essbase.log) or to the server log file (appname.log).

Parameters:

agentLog - If true, message is written to the agent log file, essbase.log. If false, message is written to the server log file, appname.log. If false, make sure that an application is active by invoking setActive(), before invoking this method.

message - The message to be logged to the agent log file (essbase.log), or to the server log file (appname.log).

Throws:

com.essbase.api.base.EssException - if an error occurs.

deleteLogFile

void deleteLogFile()
            throws com.essbase.api.base.EssException

Deletes the agent log file (essbase.log).

Throws:

com.essbase.api.base.EssException - if an error occurs.

getRequests

IEssIterator getRequests(java.lang.String userName,
                         java.lang.String appName,
                         java.lang.String cubeName)
                  throws com.essbase.api.base.EssException

Gets all the requests at the olap server for the matching userName, appName or cubeName. If any of these parameters is null, it is not used for filtering.

Parameters:

userName - The user name filter. If null, all users are considered.

appName - The application name filter. If null, all applications are considered.

cubeName - The cube name filter. If null, all cubes are considered.

Returns:

The requests (each of type IEssOlapRequest).

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapFileObjects

IEssIterator getOlapFileObjects(java.lang.String appName,
                                java.lang.String cubeName,
                                int objType)
                         throws com.essbase.api.base.EssException

Gets all the olap store file objects of the types specified. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object types. Values from IEssOlapFileObject.TYPE_*.

Returns:

The OLAP store file objects (each of type IEssOlapFileObject).

Throws:

com.essbase.api.base.EssException - if an error occurs.

getOlapFileObject

IEssOlapFileObject getOlapFileObject(java.lang.String appName,
                                     java.lang.String cubeName,
                                     int objType,
                                     java.lang.String objName)
                              throws com.essbase.api.base.EssException

Gets information about a specified olap store file object. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

Returns:

The olap file object information.

Throws:

com.essbase.api.base.EssException - if an error occurs.

isOlapFileObject

IEssOlapFileObject isOlapFileObject(java.lang.String appName,
                                    java.lang.String cubeName,
                                    int objType,
                                    java.lang.String objName)
                             throws com.essbase.api.base.EssException

Verifies and retrieves the information about the specified Essbase file object. This function returns null and does not throw EssException if the Essbase file object is not found. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name. This is not case-sensitive.

cubeName - The cube name. This is not case-sensitive. null to use application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name. This is case-sensitive

Returns:

The Essbase file object information if it exists, else returns null.

Throws:

com.essbase.api.base.EssException - if an error occurs.

copyOlapFileObjectFromServer

void copyOlapFileObjectFromServer(java.lang.String appName,
                                  java.lang.String cubeName,
                                  int objType,
                                  java.lang.String objName,
                                  java.lang.String clientFileName,
                                  boolean lock)
                           throws com.essbase.api.base.EssException

Copies an object from the olap server to a client file and optionally locks the server object to prevent updates by others. Example:

copyOlapFileObjectFromServer("Sample", "Basic", IEssOlapFileObject.TYPE_TEXT, "Act1", "C:/temp/act1.txt", false);

This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

clientFileName - The full path of destination file in the client.

lock - Flag to control object locking. If true, the server object is locked to prevent updates by other users.

Throws:

com.essbase.api.base.EssException - if an error occurs.

copyOlapFileObjectFromServer

void copyOlapFileObjectFromServer(java.lang.String appName,
                                  java.lang.String cubeName,
                                  int objType,
                                  java.lang.String objName,
                                  java.io.OutputStream out,
                                  boolean lock)
                           throws com.essbase.api.base.EssException

Copies an object from the olap server to a client file using output stream and optionally locks the server object to prevent updates by others. Example:

copyOlapFileObjectFromServer("Sample", "Basic", IEssOlapFileObject.TYPE_TEXT, "Act1", fileOutputStream, false);

This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - appName The application name.

cubeName - cubeName The cube name. null to use the application directory.

objType - objType The object type. Value from IEssOlapFileObject.TYPE_*.

objName - objName The object name.

out - The output stream to which the file has to be written. This should not be null.

lock - lock Flag to control object locking. If true, the server object is locked to prevent updates by other users.

Throws:

com.essbase.api.base.EssException - if an error occurs.

copyOlapFileObjectToServer

void copyOlapFileObjectToServer(java.lang.String appName,
                                java.lang.String cubeName,
                                int objType,
                                java.lang.String objName,
                                java.lang.String clientFileName,
                                boolean unlock)
                         throws com.essbase.api.base.EssException

Copies an object from a client file to the olap server, and optionally unlocks the server object to allow updates by others. Example:

copyOlapFileObjectToServer("Sample", "Basic", IEssOlapFileObject.TYPE_TEXT, "Test", "C:/temp/test.txt", false);

This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

clientFileName - The full path of source file in the client.

unlock - Flag to control object locking. If true, the server object is unlocked to allow updates by other users.

Throws:

com.essbase.api.base.EssException - if an error occurs.

copyOlapFileObjectToServer

void copyOlapFileObjectToServer(java.lang.String appName,
                                java.lang.String cubeName,
                                int objType,
                                java.lang.String objName,
                                java.io.InputStream in,
                                boolean unlock,
                                long totalLength)
                         throws com.essbase.api.base.EssException

Copies an object from a client file to the olap server, and optionally unlocks the server object to allow updates by others. Example:

copyOlapFileObjectToServer("Sample", "Basic", IEssOlapFileObject.TYPE_TEXT, "Test", fileInputStream, false);

This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - cubeName The cube name. null to use the application directory.

objType - objType The object type. Value from IEssOlapFileObject.TYPE_*.

objName - objName The object name.

in - the input stream to from which the file has be read. This should not be null.

unlock - unlock Flag to control object locking. If true, the server object is unlocked to allow updates by other users.

totalLength - Total length of the file object.

Throws:

com.essbase.api.base.EssException - if an error occurs.

lockOlapFileObject

void lockOlapFileObject(java.lang.String appName,
                        java.lang.String cubeName,
                        int objType,
                        java.lang.String objName)
                 throws com.essbase.api.base.EssException

Locks an object on the server to prevent other users from updating it. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

unlockOlapFileObject

void unlockOlapFileObject(java.lang.String appName,
                          java.lang.String cubeName,
                          int objType,
                          java.lang.String objName)
                   throws com.essbase.api.base.EssException

Unlocks a locked object on the server. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createOlapFileObject

void createOlapFileObject(java.lang.String appName,
                          java.lang.String cubeName,
                          int objType,
                          java.lang.String objName)
                   throws com.essbase.api.base.EssException

Creates a new olap file object. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

deleteOlapFileObject

void deleteOlapFileObject(java.lang.String appName,
                          java.lang.String cubeName,
                          int objType,
                          java.lang.String objName)
                   throws com.essbase.api.base.EssException

Delete an existing olap file object. Outline Objects can not be deleted. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

renameOlapFileObject

void renameOlapFileObject(java.lang.String appName,
                          java.lang.String cubeName,
                          int objType,
                          java.lang.String objName,
                          java.lang.String newObjName)
                   throws com.essbase.api.base.EssException

Renames an existing olap file object. Outline and LRO Objects cannot be renamed. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The current object name.

newObjName - The new object name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

copyOlapFileObject

void copyOlapFileObject(java.lang.String appName,
                        java.lang.String cubeName,
                        int objType,
                        java.lang.String objName,
                        java.lang.String destAppName,
                        java.lang.String destCubeName,
                        java.lang.String destObjName)
                 throws com.essbase.api.base.EssException

Copies an olap file object. Outline Object can not be copied. This operation is not allowed for combined Object Types IEssOlapFileObject.TYPE_BACKUP, IEssOlapFileObject.TYPE_DATA, IEssOlapFileObject.TYPE_WORKSHEET and IEssOlapFileObject.TYPE_ALL

Parameters:

appName - The application name.

cubeName - The cube name. null to use the application directory.

objType - The object type. Value from IEssOlapFileObject.TYPE_*.

objName - The object name.

destAppName - The destination application name.

destCubeName - The destination cube name.

destObjName - The destination object name.

Throws:

com.essbase.api.base.EssException - if an error occurs.

killLastRequest

void killLastRequest()
              throws com.essbase.api.base.EssException

Deprecated. Replaced with killOwnRequest()

Kills the last request if it is still running.

Throws:

com.essbase.api.base.EssException - if an error occurs.

killOwnRequest

void killOwnRequest()
             throws com.essbase.api.base.EssException

Kills the last request to a server issued by a user from the same session if it is still running.

Throws:

com.essbase.api.base.EssException - if an error occurs.

delete

void delete()
     throws com.essbase.api.base.EssException

Deletes this server from the domain if it exists. Otherwise this API throws an exception.

Specified by:

delete in interface IEssServer

Throws:

com.essbase.api.base.EssException - if an error occurs.

changeOlapPassword

void changeOlapPassword(java.lang.String userName,
                        java.lang.String oldPassword,
                        java.lang.String newPassword)
                 throws com.essbase.api.base.EssException

Changes the password of a user at OLAP server. The user does not have to be logged on to the OLAP server while calling this API.

Parameters:

userName - The userName whose password has to change.

oldPassword - The old password of the user.

newPassword - The new password to be set.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getLoginId

long getLoginId()
         throws com.essbase.api.base.EssException

Returns the signed-in user's login ID for the particular session.

Returns:

loginid - the loginid from the user's session

Throws:

com.essbase.api.base.EssException - if an error occurs.

getLocale

java.lang.String getLocale()
                    throws com.essbase.api.base.EssException

Returns the locale of the OLAP server.

Returns:

locale - locale of the OLAP server.

Throws:

com.essbase.api.base.EssException - if an error occurs.

syncUser

void syncUser(java.lang.String user)
       throws com.essbase.api.base.EssException

Forces a user's/group's security information to be synchronized with that user's/group's current information in Shared Services. If Essbase has not been migrated to Shared Services, this function is not supported and returns an error. This function requires the caller to be an Administrator, Application Manager, or Database Manager.

Parameters:

user - - String, the user/group name to be synchronized.

Throws:

com.essbase.api.base.EssException - if an error occurs.

syncUsers

void syncUsers()
        throws com.essbase.api.base.EssException

Forces all users' security information to be synchronized with the current user information in Shared Services. If Essbase has not been migrated to Shared Services, this function is not supported and returns an error. This function requires the caller to be an Administrator, Application Manager, or Database Manager.

Throws:

com.essbase.api.base.EssException - if an error occurs.

syncGroups

void syncGroups()
         throws com.essbase.api.base.EssException

Forces all groups' security information to be synchronized with the current group information in Shared Services. If Essbase has not been migrated to Shared Services, this function is not supported and returns an error. This function requires the caller to be an Administrator, Application Manager, or Database Manager.

Throws:

com.essbase.api.base.EssException - if an error occurs.

syncUsersAndGroupsWithApp

void syncUsersAndGroupsWithApp(IEssOlapApplication application)
                        throws com.essbase.api.base.EssException

Synchronize the Essbase application's security definitions so that all users and groups in the application match with the current state of Shared Services security. If Essbase has not been migrated to Shared Services, this function is not supported and returns an error. This function requires the caller to be an Administrator, Application Manager, or Database Manager.

Parameters:

application - - IEssOlapApplication, the application to sync with

Throws:

com.essbase.api.base.EssException - if an error occurs.

resyncSSSecurity

void resyncSSSecurity()
               throws com.essbase.api.base.EssException

Synchronizes the Essbase security definitions for all users, groups, and applications with the current state of Shared Services security. If Essbase has not been migrated to Shared Services, this function is not supported and returns an error. This function requires the caller to be an Administrator.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createOlapGroup

IEssOlapGroup createOlapGroup(java.lang.String groupName)
                       throws com.essbase.api.base.EssException

Creates a new group.

The specified group must not already exist. his method requires the caller to have Create/Delete User privilege (ESS_PRIV_USERCREATE) for the logged in server.

Parameters:

groupName - name of the group to be created

Returns:

IEssOlapGroup The new group.

Throws:

com.essbase.api.base.EssException - if an error occurs.

Since:

11.1.1

createCDF

void createCDF(java.lang.String name,
               java.lang.String javaSpec,
               int options,
               java.lang.String spec,
               java.lang.String comment)
        throws com.essbase.api.base.EssException

Creates a custom defined function.

Parameters:

name - Function name

javaSpec - Java Specification

options - An option must be one of possible values of IEssOlapServer.ESS_UDF_FUNCTION_*

spec - Function specification

comment - Description for this function.

Throws:

com.essbase.api.base.EssException - if an error occurs.

deleteCDF

void deleteCDF(java.lang.String name)
        throws com.essbase.api.base.EssException

Deletes custom defined function.

Parameters:

name - Function that has to be deleted.

Throws:

com.essbase.api.base.EssException - if an error occurs.

createCDM

void createCDM(java.lang.String name,
               java.lang.String definition,
               java.lang.String signature,
               java.lang.String spec,
               java.lang.String comment)
        throws com.essbase.api.base.EssException

Creates custom defined macro.

Parameters:

name - Macro name

definition - Macro definition

signature - Signature for this macro.

spec - Specification for this macro.

comment - Description for this macro.

Throws:

com.essbase.api.base.EssException - if an error occurs.

deleteCDM

void deleteCDM(java.lang.String name)
        throws com.essbase.api.base.EssException

Deletes custom defined macro.

Parameters:

name - Macro that has to be deleted.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getCDM_CDF

java.lang.String[][] getCDM_CDF()
                         throws com.essbase.api.base.EssException

Gets custom defined functions and macros.

The result will consist of 'n' x 5 elements where 'n' represents the total number of custom functions and custom macros. For any 'x' value ranging from 0 to n-1,
Result [x][0] represents the Name
Result [x][1] represents the Specification
Result [x][2] represents the Comment
Result [x][3] represents the Type either a value "cdf" or "cdm"
Result [x][4] represents the Scope which is will be "global"

Returns:

list of CDF and CDMs.

Throws:

com.essbase.api.base.EssException - if an error occurs.

setMessageHandler

void setMessageHandler(IEssCustomMessageHandler handler)
                throws com.essbase.api.base.EssException

Associates the Custom message handler to the session. The API includes a mechanism for intercepting error messages and other messages generated at the server and for displaying the appropriate messages automatically on the client program's screen. This mechanism, although generally useful, can be turned on if desired. The API allows your program to prevent those messages from appearing and to trap them for processing within your program. You can choose which messages to display and then display the chosen messages in a way that is consistent with the client program's internal message and error handling. This mechanism provides seamless integration of Essbase with your program. Client programs using this API should always use the getMessageHandler() API to retrieve the latest state of the handler. The CustomMessageHandler should also be exposed to the APS server in 3tier mode.

Parameters:

handler - Custom message handler.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getMessageHandler

IEssCustomMessageHandler getMessageHandler()
                                    throws com.essbase.api.base.EssException

Retrieves the custom message handler associated with the session. Client programs should always use the instance returned by this API to access the latest state of the Custom message handler.

Returns:

IEssCustomMessageHandler or null if one was not associated

Throws:

com.essbase.api.base.EssException - if an error occurs.

See Also:

setMessageHandler(IEssCustomMessageHandler)

reRegisterAllApplications

void reRegisterAllApplications()
                        throws com.essbase.api.base.EssException

Re-establishes all Analytic Services applications as Shared Services applications. This function requires the caller to be an Administrator, Application Manager, or Database Manager. For any applications for which the caller does not have sufficient permissions, the re-registration will be skipped with a warning. If Essbase has not been migrated to Shared Services, this function is not supported and returns an error.

Throws:

com.essbase.api.base.EssException - if an error occurs.

openMaxlSession

IEssMaxlSession openMaxlSession(java.lang.String MaxlSessionName)
                         throws com.essbase.api.base.EssException

Opens a Maxl session with the Analytic server and returns a handle to the session. Maxl statements can be executed using the returned handle. Client applicaions should IEssMaxlSession.close() the session after usage is complete. The session instance can be used to execute multiple Maxl statements sequencially using the same handle.

Parameters:

MaxlSessionName - - a name to the session.

Returns:

IEssMaxlSession - a handle to the session opened.

Throws:

com.essbase.api.base.EssException - if an error occurs.

Since:

11.1.2

listSchemas

java.lang.String[] listSchemas()
                        throws com.essbase.api.base.EssException

Returns a accessible list of schemas for the active user. These schemas are the ones that store Custom Objects.

This method is supported against Essbase version 11.1.2.3

Returns:

list of custom object storage schemas, accessible to logged-in user.

Throws:

com.essbase.api.base.EssException - on failure to retrieve schemas.

Since:

11.1.2.3

moveApplication

void moveApplication(java.lang.String sourceAppName,
                     java.lang.String destAppName,
                     boolean overwriteIfExists,
                     int timeoutToForceUnloadApp)
              throws com.essbase.api.base.EssException

Moves one application as another.

If the destination application already exists and you want to overwrite, set the overwriteIfExists as true. One can imagine this move operation to be moving of the Essbase application directory from source location to destination, at a file system level. Accordingly, Essbase has to unload both applications, if they are running before doing this move. At the time of unloading, if the destination application is seen servicing any on-going operations like any queries, then Essbase will terminate those operations and try to unload the application. In case a graceful unload fails or takes longer, then, the the input argument, timeoutToForceUnloadApp (unit is in seconds) will decide to forcefully terminate the application. Example, if one specifies 60 seconds and in the event of killing ongoing requests and graceful unload application operation doesn't complete within one minute, Essbase will trigger forceful termination after one minute. After which, Essbase will be able to perform the move operation.

This move operation is supported on all kinds of applications like Aggregate, Block and Hybrid storage applications.

Note when moving an existing application, only the application and cube artifacts like meta-data and data are replaced from the source to destination. All security layer associations on the destination application like users, groups and security filters are retained and that of source will be lost. All partitions associated with the destination application are also retained and anything such on source will be lost during the move.

Example, if users "x" and "y" had read-access to App1, then, after moving say App2 as App1, both "x" and "y" will be able to access App1. If App2 was associated with user called "z", then after move, "z" wont be able to access App1.

In the case of overwriting an existing application, the number of cubes and the cube names have to match between both the applications. Otherwise, move is not allowed and it will fail with an error, leaving both the applications as it was.

Example, ASOAppNew/cubeNew cannot be replaced as ASO/cube. ASOAppNew/cube can be replaced as ASO/cube.

Tips: Anyone using this need not necessarily unload or stop the application, prior to calling this move API, because Essbase will load the application to gather information and then, unload when it going to move the applications. In other words, if the application is already running, one can decide to avoid calling unload as a pre-requisite.

Parameters:

sourceAppName - Name of the application to be moved.

destAppName - Name of application to be moved as.

overwriteIfExists - If true, replaces the existing application.

timeoutToForceUnloadApp - Time interval (in seconds), to force unload in the event of applications performing an ongoing requests even after time interval.

Throws:

com.essbase.api.base.EssException - if it fails to move the cube to destination application.

promoteShadowApplication

void promoteShadowApplication(java.lang.String shadowAppName,
                              java.lang.String baseAppName,
                              int timeoutToForceUnloadApp)
                       throws com.essbase.api.base.EssException

Promotes the shadowed application as the base application.

One can imagine this operation to be moving of the Essbase application directory from source location to destination, at a file system level. Accordingly, Essbase has to unload both applications, if they are running before doing this promote. At the time of unloading, if the destination application is seen servicing any on-going operations like any queries, then Essbase will terminate those operations and try to unload the application. In case a graceful unload fails or takes longer, then, the the input argument, timeoutToForceUnloadApp (unit is in seconds) will decide to forcefully terminate the application. Example, if one specifies 60 seconds and in the event of killing ongoing requests and graceful unload application operation doesn't complete within one minute, Essbase will trigger forceful termination after one minute. After which, Essbase will be able to perform the promote operation.

This promotion operation is supported on all kinds of applications like Aggregate, Block and Hybrid storage applications.

Note when moving an existing application, only the application and cube artifacts like meta-data and data are replaced from the source to destination. All security layer associations on the destination application like users, groups and security filters are retained and that of source will be lost. All partitions associated with the destination application are also retained and anything such on source will be lost during the promote.

Example, if users "x" and "y" had read-access to App1, then, after moving say App2 as App1, both "x" and "y" will be able to access App1. If App2 was associated with user called "z", then after promote, "z" wont be able to access App1.

Please note the promotion from shadowed application to base is honored, only if there are no changes to the number of cubes and cube names. In other words, for example, if a cube gets renamed or if there is any addition or deletion of an application after it was shadowed, then, promotion of such an application will not be supported. In such a case, this will fail with an error, leaving both the applications as it was.

Example, ASOAppNew/cubeNew cannot be replaced as ASO/cube. ASOAppNew/cube can be replaced as ASO/cube.

Tips: Anyone using this need not necessarily unload or stop the application, prior to calling this promote API, because Essbase will load the application to gather information and then, unload when it going to promote the applications. In other words, if the application is already running, one can decide to avoid calling unload as a pre-requisite.

Parameters:

shadowAppName - Name of the hidden shadowed application that has to be promoted to base.

baseAppName - Name of the primary application.

timeoutToForceUnloadApp - Time interval (in seconds), to force unload in the event of applications performing an ongoing requests even after time interval.

Throws:

com.essbase.api.base.EssException - if it fails to promote the cube to destination application.

dropShadowApplication

void dropShadowApplication(java.lang.String shadowAppName)
                    throws com.essbase.api.base.EssException

Forcefully deletes the specified shadow application.

Note the shadow application can also be deleted using the regular #IEssOlapApplication.delete(). The only difference is that if the shadow application is corrupted or has any locks, then it wont be able to drop the application. So, this API guarantees a forceful deletion of the application.

This API is more of a equivalent of MAXL statement "drop application APP_NAME cascade force"

Parameters:

shadowAppName - Name of the shadowed application that has to be cleaned up.

Throws:

com.essbase.api.base.EssException - if it fails to delete the application.

getHiddenApplicationNames

java.lang.String[] getHiddenApplicationNames()
                                      throws com.essbase.api.base.EssException

Fetches the names of hidden applications, if any.

Hidden applications can be created using IEssOlapApplication.copy(String, boolean). Once created these are not visible by anyone who uses the standard getApplications().

Returns:

list of hidden applications.

Throws:

com.essbase.api.base.EssException - on failure to fetch the hidden application list.

See Also:

IEssOlapApplication.copy(String, boolean)

getAllApplicationNames

java.lang.String[] getAllApplicationNames()
                                   throws com.essbase.api.base.EssException

Fetches the names of regular (visible) as well as hidden applications.

Returns:

list of both regular and hidden applications.

Throws:

com.essbase.api.base.EssException - on failure to fetch the application list.

See Also:

getHiddenApplicationNames()

getRegularApplicationNames

java.lang.String[] getRegularApplicationNames()
                                       throws com.essbase.api.base.EssException

Fetches the names of regular (visible) applications.

Returns:

list of both regular applications.

Throws:

com.essbase.api.base.EssException - on failure to fetch the regular application list.

See Also:

getAllApplicationNames()

setIgnoreCellProperties

void setIgnoreCellProperties(boolean ignoreCellProperties)
                      throws com.essbase.api.base.EssException

Sets the ignore cell properties value. if true, ignore cell status and TID, in imported data and change status to LOADED, TID to new transaction id. if false, validate status and store the values from the imported data.

Parameters:

ignoreCellProperties - true if cell properties are set to be ignored.

Throws:

com.essbase.api.base.EssException - if an error occurs.

getIgnoreCellProperties

boolean getIgnoreCellProperties()
                         throws com.essbase.api.base.EssException

Get the ignore cell properties value.

Returns:

true is ignore cell properties is set.

Throws:

com.essbase.api.base.EssException - if an error occurs.

See Also:

setIgnoreCellProperties(boolean)

setConnectionParameter

void setConnectionParameter(java.lang.String appName,
                            java.lang.String dbName,
                            java.lang.String name,
                            java.lang.String value)
                     throws com.essbase.api.base.EssException

Connection parameters setting method

Parameters:

appName - - application name

dbName - - database name

name - - the name of the parameter

value - - the value of the parameter

Throws:

com.essbase.api.base.EssException - if an error occurs.

getAllConnectionsParameters

java.lang.String getAllConnectionsParameters(java.lang.String appName,
                                             java.lang.String dbName)
                                      throws com.essbase.api.base.EssException

Gets all parameters that are associated with current connection

Parameters:

appName - - application name

dbName - - database name

Returns:

- String that contains all parameters in pairs name=value

Throws:

com.essbase.api.base.EssException - if an error occurs.

getEssbaseConfigValues

@Deprecated
java.util.Map<java.lang.String,java.lang.String> getEssbaseConfigValues()
                                                                             throws com.essbase.api.base.EssException

Deprecated.

API to get Essbase config value from Essbase.cfg as key value pairs

Returns:

Map<String,String> - Holds Essbase.cfg file as key value pairs

Throws:

com.essbase.api.base.EssException - if an error occurs

Since:

12.2.1.1.108

getEssbaseConfigValuesEx

java.util.Map<java.lang.String,java.util.List<java.lang.String>> getEssbaseConfigValuesEx()
                                                                                   throws com.essbase.api.base.EssException

API to get Essbase config value from Essbase.cfg as key value pairs

Returns:

Map<String,List<String>> - Holds Essbase.cfg file as key value pairs

Throws:

com.essbase.api.base.EssException - if an error occurs

setTimeoutParameters

void setTimeoutParameters(int netRetryCount,
                          boolean tryInfinite)
                   throws com.essbase.api.base.EssException

Sets JAPI timeout parameters

Parameters:

netRetryCount - - netRetryCount value

tryInfinite - - tryInfinite value

Throws:

com.essbase.api.base.EssException - if an error occurs.

resetTimeoutParameters

void resetTimeoutParameters()
                     throws com.essbase.api.base.EssException

Reset JAPI timeout parameters

Throws:

com.essbase.api.base.EssException - if an error occurs.