Thursday, November 12, 2020

Hyperion on-premise 11.2.3 Readme info

 https://docs.oracle.com/en/applications/enterprise-performance-management/11.2/rmepm/index.html#RMEPM-GUID-A66378C8-76A0-4EFE-8466-4F442398531C


EPM System New Features

Release 11.2.3 contains bug fixes for Windows and Linux only, support for TLS 1.2, and the ability to apply an update directly from Release 11.2.1 or Release 11.2.2. Check the Oracle Enterprise Performance Management System Certification Matrix for all platform requirements.

Saturday, November 7, 2020

Oracle EPM Cloud Planning and How to Restructure Cubes for optimal performance

You can run the Restructure Cube job to perform a full restructure of a block storage cube to eliminate or reduce fragmentation. This will also remove empty blocks.

This feature is not applicable for an Aggregate Storage cube (ASO).

Note:

You should not run this job during the application maintenance time. You also should not launch a consolidation process while the Restructure Cube job is running.

When you perform this operation:

  • Users will be prompted to log out.

  • You must manually set the application to Maintenance mode.

  • After the Restructure Cube job is run, you must manually turn off Maintenance mode.

  • Users will then be informed that the application is available.

Running the Restructure Cube Job

To restructure a cube:

  1. On the Home page, click Application.

  2. Click Jobs.

  3. Click Schedule Jobs.

  4. Select Restructure Cube, then select Run Now, and click Next.

  5. Select when to run the job:

    • Run Now

    • Schedule starting from, and then select the date, time, and time zone.

  6. Enter a Name for the job.

  7. For Recurrence pattern, select how often to run the job, and optionally, select an End Date.

  8. Click Next to continue.

  9. Select a Cube from the drop-down list, then click Next.

  10. Review your selections and then click Finish.

    The Restructure Job is submitted on the Jobs page. Make sure that the job is completed by periodically refreshing the page.

Oracle EPM Cloud and Scheduling Maintenance

 By default, Financial Consolidation and Close automatically perform daily maintenance starting at midnight local time. 

During the nightly maintenance window, the system performs backups, applies any patches, recycles the application, and so on. If you prefer, you can schedule daily maintenance to occur at another time.

During daily maintenance, the service automatically creates a backup snapshot of data and artifacts. When daily maintenance executes, it replaces the prior backup snapshot with a new backup snapshot. 

You should schedule the execution of the EPM Automate Utility on a daily basis to download the backup snapshot to a local computer.

To schedule maintenance:

  1. On the Home page, click Tools.
  2. Click Daily Maintenance.
  3. Select the local time zone and the time of day for maintenance.
  4. Click Save.