1. Release Notes for Oracle Essbase
  2. Releases
  3. Stack Deployment on OCI
  4. Release 21.6.0.0.1 - August 2024 - Stack Deployment on OCI Marketplace

Release 21.6.0.0.1 - August 2024 - Stack Deployment on OCI Marketplace

Here’s an overview of new features, enhancements, issues, patches, other changes, and version information for this Stack deployment on OCI Marketplace release.

New Features, Enhancements, and Issues

For prior new features and enhancements, see previous Release Notes. For a description of current features, see the Oracle Essbase 21c documentation. Following are the details specific to this release for specific deployment options.

Marketplace deployment only

  • Dropdown selection of secrets with the choice to choose the compartments

    For more information, see Create Stack.

  • Option to upgrade to the recommended flex shape

    See Upgrade Stack.

  • Essbase Image based on Oracle Linux 8

    Support is added for Oracle Linux 8 as the OS for both new deployments and stack upgrades.

  • Cube Designer Support for Federated Partitions

    Essbase users can now use Cube Designer to create a federated partition by creating a Cube. FederatedPartition worksheet in the application workbook for the Essbase cube, and then validating the sheet and saving the partition to the server. See Create a Federated Partition in Cube Designer.

  • Encryption at Rest

    You can encrypt Essbase applications using the Oracle Cloud Infrastructure (OCI) Vault. See Encryption at Rest for Essbase Applications.

All deployments

  • Redwood Web User Interface

    You can now try out the new Redwood web user interface by selecting the Redwood option when logging in to Essbase.

    The Redwood interface features several enhancements:
    • A new Redwood look and feel.
    • You work in the context of the application or cube instead of working in the application and cube inspectors.
    • Objects such as scripts or the outline are opened in tabs, so you can easily toggle between them.
    • Enhanced functionality for adding members, where you can provide, in one dialog, all the general properties like storage type, dimension type, solve order, formulas, attributes, and UDAs. You can also add the multiple members consecutively using the shortcut ‘Ctrl + Enter’ or by clicking the Add button without closing the dialog.
    • Enhanced search capability, with improved performance and access to the following operations in the Search dialog: Locate, Member inspector, and Hierarchy (Shows the hierarchy of the member in a tree view, where you can locate, launch the member inspector, or add a sibling or a child, if the outline is in Edit mode).

  • MDX Export Enhancements

    MDX export allows users to save query results directly to a file. This is useful for handling large queries or for exporting data later to import using a data load.

    MDX Export for aggregate storage (ASO) cubes includes the following new feature:
    • Support for native (block storage) data export format using the DATAEXPFORMAT directive.
    New features for aggregate storage (ASO) and block storage (BSO) cubes:
    • Unique member name support for duplicate member outlines.
    • Improved performance and no query limitation of 232 cells when you export only level-0 data and use two axes in the SELECT section of the query.

    For more information, see MDX Export Specification.

Version Details

Patches certified with this release - it is a pre-requirement that you apply the supported patches listed below:

  • Software versions:
  • Applied patches - listed below and as noted in the documentation:

    Note:

    Essbase Release Update patches only contain Essbase binaries. In addition, other patches, such as for Fusion Middleware, can be downloaded and applied manually. These patches are included in the latest listings.
    • 36822778 - WLS STACK PATCH BUNDLE 12.2.1.4.240710

      Note:

      After installing above latest WLS STACK PATCH BUNDLE, check to see whether patch 33735326 was included. If it is not present, it needs to be applied.

      To check which patches have been applied, navigate to <ORACLE_HOME>/OPatch, and use the opatch lsinventory command. To check specifically for patch 33735326, you can use grep.

      For example,

      opatch lsinventory | grep 33735326
      • 36822804 -- WLS STACK PATCH BUNDLE 12.2.1.4.240710 (PATCH 36822778) (INTERIM PATCH 36822782)
      • 35965629 -- ADR FOR WEBLOGIC SERVER 12.2.1.4.0
      • 36805124 -- WLS PATCH SET UPDATE 12.2.1.4.240704
      • 36426672 -- WEBLOGIC SAMPLES SPU 12.2.1.4.240416
      • 36725924 -- Coherence 12.2.1.4 Cumulative Patch 22 (12.2.1.4.22)
      • 33093748 -- FMW PLATFORM 12.2.1.4.0 SPU FOR APRCPU2021
      • 36770738 -- FMW Thirdparty Bundle Patch 12.2.1.4.240625
      • 28186730 -- OPATCH 13.9.4.2.16 FOR EM 13.4 AND FMW/WLS 12.2.1.3.0, 12.2.1.4.0 AND 14.1.1.0.0
      • 32720458 -- JDBC 19.3.0.0 FOR CPUAPR2022 (WLS 12.2.1.4, WLS 14.1.1)
      • 36553894 -- RDA release 24.3-2024716 for FMW 12.2.1.4.0
    • 31676526 - RCU Patches for ADB
    • 30540494 - RCU Patches for ADB
    • 30754186 - RCU Patches for ADB
    • 36700543 - Oracle ADF BUNDLE PATCH 12.2.1.4.240605
    • 36316422 - Oracle OPSS Bundle Patch 12.2.1.4.240220 README
    • 33735326 - Fix for Bug 33735326, log4j (2.17.1) patch
    • 35426547 - Release Update: Oracle Essbase 21.6.0.0.0

Patching

See Patch and Roll Back for patching instructions.

Bug Fixes and Known Issues

The following are the new or continuing known issues in this version of Oracle Essbase via Marketplace:

For defects fixed and other known issues in Oracle Essbase, see https://support.oracle.com/rs?type=doc&id=2814450.1.

Deprecation Notes

Measures Dimension (DV) Flattening Selector has been deprecated from the Essbase web interface. Essbase metadata is managed by DV.