1. Release Notes for Oracle Essbase
  2. History of Removed Features

3 History of Removed Features

Essbase introduces behavior changes in addition to new features. Changes in behavior include not supported and deprecated features, components, configuration settings, options, and syntax. This topic lists the features, by release, that were no longer supported or deprecated.

Terminology

Not Supported—In the release in which a feature is not supported, the functionality is either completely removed from the product or, if not completely removed, is no longer supported.

Deprecated—In the release in which a feature is deprecated, the feature is still fully functional (unless limitations are specified) and supported. Typically, a deprecated feature will no longer be supported in the next release.

Caution:

Oracle strongly recommends not implementing deprecated features.

Note:

Some legacy features or options that were deprecated or not supported in one release were reintroduced in a later release. These are marked with *. For example, custom defined functions and macros were not supported in Essbase 19c, but were added back in Essbase 21c. Implied sharing was also added back in Essbase 21c. For details about the difference between legacy and newer functionality, see Differences Between Essbase 11g and Essbase 21c.

Essbase 19c and Essbase 21c

The following functionality is deprecated: UPPERCASECONNECTION option in esssql.cfg for ODBC.

The following functionality from Essbase 11g is no longer supported:

  • Essbase Administration Services (limited-use EAS Lite is available Essbase 21c for non-OCI, independent deployment only)
  • Essbase Studio. To use drill through functionality previously offered by Studio, you now set up connections and Datasources to establish connectivity to external source data, and then build Drill Through reports in the Essbase platform to access the external data.
  • Implied sharing - not available in Essbase 19c. Available in Essbase 21c with a new configuration setting, IMPLIED_SHARE_ON_CREATE
  • Dynamic Calc and Store (these members are treated as Dynamic Calc)
  • Exporting data to relational databases
  • Loading data from Excel source files
  • Use of Oracle Process Manager and Notification server (OPMN) to manage Essbase Agent
  • Use of OPMN for failover lease management
  • Committed access mode (isolation level). Essbase 21c manages block storage data transactions in uncommitted mode. Essbase releases a block after it is updated, and commits blocks when the transaction is completed.
  • Cache memory locking (including MaxL statement alter database enable cache_pinning)
  • Custom-defined functions and macros * (supported with Release 21c but not 19c)
  • Essbase Web Services. The functionality of Java API SOAP Web services from earlier versions of Provider Services are replaced with REST API.

Not supported configuration settings:

  • AGTSVRCONNECTIONS
  • CALCLOCKBLOCK
  • CLEARLOGFILE
  • CONNECTIONTIMEOUT
  • DATAFILECACHESIZE
  • DEFAULTLOGLOCATION
  • DISKVOLUMES
  • DISPLAYMESSAGELEVEL
  • ENABLESWITCHTOBACKUPFILE
  • ESSLANG
  • HEARTBEATINTERVAL
  • HISLEVELDRILLTHROUGH
  • IBHFIXTHRESHHOLD
  • IMPLIED_SHARE * (replaced in Essbase 21c with IMPLIED_SHARE_ON_CREATE)
  • INCRESTRUC
  • JAVAMAXMEMBERSPEROUTLINE
  • NO_HOSTNAME_LISTCONNECT
  • NOMSGLOGGINGONDATAERRORLIMIT
  • NUMBEROFSECFILEBACKUPS
  • PORTUSAGELOGINTERVAL
  • QUERYTIMEOUT
  • SECFILEBACKUPINTERVAL
  • SILENTOTLQUERY
  • UNICODEENABLE

Essbase 12.2.1

Essbase 12.2.1.3.0

No longer supported starting in this release: MaxL Perl Module

Essbase 12.2.1.2.0

Administration Services and Essbase Studio releases earlier than 11.1.2.4.008 are not supported with Essbase 12.2.1.2.0.

The following functionality from Essbase 11g is no longer supported:

  • Cube Deployment Service (CDS)
  • Essbase BI Acceleration

Essbase 12.2.1.1.0

Administration Services and Essbase Studio releases earlier than 11.1.2.4.008 are not supported with Essbase 12.2.1.1.0.

The following functionality from Essbase 11g is no longer supported:

  • Cube Deployment Service (CDS)
  • Essbase BI Acceleration

Essbase 12.2.1.0.0

The following functionality from Essbase 11g is no longer supported:

  • Direct I/O
  • Block storage outline synchronization
  • Outline change log
  • Currency conversion applications and currency partitions * (supported again with Release 21c)
  • Data compression types: zlib and none
  • Linked partitions
  • Oracle Essbase Administration Services Java API
  • Network File System (NFS) protocol on Network Attached Storage (NAS) devices

No longer supported MaxL statements and grammar related to user and group management or to other deprecated security functionality:

  • The following MaxL statements are no longer supported:
    • alter group * (support for a few clauses is reintroduced with Release 21c)
    • alter user * (support for a few clauses is reintroduced with Release 21c)
    • create group * (support for a few clauses is reintroduced with Release 21c)
    • create user * (support for a few clauses is reintroduced with Release 21c)
    • deploy
    • drop group * (support for a few clauses is reintroduced with Release 21c)
    • drop user * (support for a few clauses is reintroduced with Release 21c)
    • export security file
  • In these MaxL statements, the following grammar is no longer supported:
    • alter system statement:
      • clear log file
      • sync security_backup
      • compact security file
      • set message level
      • set eas_loc
    • display group statement—failed_sss_migration
    • display system statement—security file fragmentation_percent
    • display user statement:
      • failed_sss_migration
      • shared_services_native with auto_password
      • migr_modified_access
    • grant statement— all privileges and roles. You can only grant calculation and filter access. * (Support for granting privileges and roles, for EPM Shared Services security mode only, is reintroduced with Release 21c)

Not supported configuration settings:

  • AGENTDELAY
  • AGENTDESC
  • AGENTDISPLAYMESSAGELEVEL
  • AGENTLEASEEXPIRATIONTIME
  • AGENTLEASEMAXRETRYCOUNT
  • AGENTLEASERENEWALTIME
  • AGENTLOGMESSAGELEVEL
  • AGTMAXLOGFILESIZE
  • APSRESOLVER
  • DATAFILECACHESIZE
  • DIRECTIO
  • ESSBASEFAILOVERTRACELEVEL
  • IDMIGRATION
  • PERSISTUSERATLOGIN
  • PORTINC
  • SECURITYFILECOMPACTIONPERCENT
  • SERVERLEASEEXPIRATIONTIME
  • SERVERLEASEMAXRETRYCOUNT
  • SERVERLEASERENEWALTIME
  • UNICODEAGENTLOG

Essbase 11.1.2.4 (11g)

Essbase 11.1.2.4.036

Not supported: The use of environment variables defined at the operating system level are no longer supported in outline member formulas and calculation scripts.

Essbase 11.1.2.4.018

Deprecated features:

The properties service.olap.dataQuery.grid.maxRows and service.olap.dataQuery.grid.maxColumns in the essbase.properties file are deprecated. These properties, if defined in essbase.properties, do not have any effect on the grid result. The results of the grid are controlled by the QUERYRESULTLIMIT configuration setting in the essbase.cfg file on Essbase Server. With these changes, existing use cases that expect an error for the previous lower row and column limits set in Java API will not get an error unless the QUERYRESULTLIMIT limit is exceeded. With these changes, Provider Services Java API does not apply any limits against a previous version of Essbase.

Essbase 11.1.2.4.002

Not supported features:

  • Delayed freespace recovery is no longer supported.
  • MaxL statement: alter database recover freespace. Oracle recommends using the alter database force restructure statement.
  • Configuration setting: DELAYEDRECOVERY

Essbase 11.1.2.4.000

Not supported features:

  • Essbase Integration Services, including Hybrid Analysis and Advanced Relational Access. Many of the basic concepts of Hybrid Analysis and Advanced Relational Access have been folded into the functionality of XOLAP cubes in Essbase Studio.
  • Visual Basic API. Oracle strongly recommends using the Essbase Java API. You can also use the Essbase C API.

Not supported configuration settings:

  • PRELOADALIASNAMESPACE
  • PRELOADMEMBERNAMESPACE
  • PRELOADUDANAMESPACE
  • MAXACTIVEUPDATETRANSACTIONS
  • MAXTOTALACTIVETRANSACTIONS

Deprecated features:

  • Direct I/O
  • Block storage outline synchronization
  • Outline change log
  • Currency conversion applications and currency partitions
  • Data compression types: zlib and none
  • Linked partitions
  • Essbase Administration Services Java API
  • Network File System (NFS) protocol on Network Attached Storage (NAS) devices
  • MaxL statements and grammar:
    • alter user statement — only the add [to group] and remove [from group] grammar is deprecated
    • create group statement — the entire statement is deprecated
    • create user statement — the entire statement is deprecated
    • display group statement — only the all grammar is deprecated
    • display user statement — only the all grammar is deprecated
    • drop group statement — all grammar is deprecated except for from security_file
    • drop user statement — all grammar is deprecated except for from security_file

Essbase 11.1.2.3

Essbase 11.1.2.3.507

Not supported features:

  • MaxL grammar: alter database recover freespace. Oracle recommends using the alter database force restructure grammar.
  • Configuration setting: DELAYEDRECOVERY

Essbase 11.1.2.3.503

Not supported calculation command: SET FORCEPARALLELCALC. Consider using FIXPARALLEL instead.

Essbase 11.1.2.3.500

Not supported configuration settings:

  • VLBREPORT
  • XOLAPENABLEHEURISTICS

Essbase 11.1.2.3.000

Not supported functionality:

  • Oracle Essbase Spreadsheet Add-in
  • Data Mining
  • The following C API functions are not supported with Essbase Studio drill-through.
    • EssGDTConnect
    • EssGDTRequestDrillThrough
    • EssGDTGetInfo
    • EssGDTSetInfo
    • EssGDTListReports
    • EssGDTExecuteReport
    • EssDTAPIGetError
    • EssGDTGetHeader
    • EssGDTGetData
    • EssGDTEndDrillThrough

Deprecated configuration settings:

  • PRELOADALIASNAMESPACE
  • PRELOADMEMBERNAMESPACE

Essbase 11.1.2.2

Essbase 11.1.2.2.100

Not supported functionality:

  • Starting Essbase Server in the foreground
  • Windows Authentication for SQL Server

Not supported configuration setting: MEMSCALINGFACTOR

Essbase 11.1.2.2.000

Not supported configuration settings:

  • HSSREGNAME
  • INSTANCENAME
  • NODENAME is completely replaced by ESSBASESERVERHOSTNAME, which serves all the purposes of NODENAME, as well as specifies the host name to which Essbase binds.
  • SHAREDSERVICESLOCATION is no longer a valid setting. The necessary information is now centralized in the Oracle Hyperion Shared Services Registry.

Deprecated configuration setting: MEMSCALINGFACTOR

Essbase 11.1.2.1

Deprecated configuration settings:

  • HSSREGNAME
  • INSTANCENAME
  • NODENAME is completely replaced by ESSBASESERVERHOSTNAME, which serves all the purposes of NODENAME, as well as specifies the host name to which Essbase binds.
  • SHAREDSERVICESLOCATION is no longer a valid setting. The necessary information is now centralized in the Oracle Hyperion Shared Services Registry.

Essbase 11.1.1.4

Not supported feature: Reference cubes

Not supported Visual Basic API functions:

  • EsbPartitionOpenDefFile
  • EsbPartitionReadDefFile
  • EsbPartitionWriteDefFile

Not supported configuration settings:

  • CssSyncLevel
  • CssRefreshLevel
  • SharedServicesRefreshInterval

Not supported MaxL grammar:

  • For the alter application MaxL statement:
    • sync user
    • sync group
    • sync all_users_groups
  • For the alter group MaxL statement: all sync with all application
  • For the alter system MaxL statement: resync sss
  • For the alter user MaxL statement:
    • set type external with protocol MODULE-STRING identified by AUTH-PARAMETERS
    • sync security with all application
  • For the create user MaxL statement: with protocol MODULE-STRING identified by AUTH-PARAMETERS
  • For the display user system MaxL statement:
    • all shared_services_native with auto_password
    • all migr_modified_access

Essbase 9.3.3

Not supported functionality:

  • Security Synchronization between Essbase and Oracle Hyperion Shared Services
  • Custom authentication using non Oracle Hyperion Shared Services-based LDAP or MSAD modules

Deprecated configuration settings:

  • CssSyncLevel
  • CssRefreshLevel
  • SharedServicesRefreshInterval

Deprecated MaxL grammar:

  • For the alter application MaxL statement:
    • sync user
    • sync group
    • sync all_users_groups
  • For the alter group MaxL statement: all sync with all application
  • For the alter system MaxL statement: resync sss
  • For the alter user MaxL statement:
    • set type external with protocol MODULE-STRING identified by AUTH-PARAMETERS
    • sync security with all application
  • For the create user MaxL statement: with protocol MODULE-STRING identified by AUTH-PARAMETERS
  • For the display user system MaxL statement:
    • all shared_services_native with auto_password
    • all migr_modified_access

Deprecated C main API functions:

  • EssGetMigrModifiedAccessUsers
  • EssGetNewSSNativeEssbaseUsers
  • EssReassignIdentity
  • EssResyncSSSecurity
  • EssSyncGroupWithApp
  • EssSyncUser
  • EssSyncUserWithApp
  • EssSyncUsersandGroupsWithApps