Essbase Patch – 11.1.2.3.500 – Good News

Hybrid Aggregation Mode in Block Storage Databases

A new Essbase configuration setting, ASODYNAMICAGGINBSO, controls whether block storage databases use hybrid aggregation mode. Hybrid aggregation for block storage databases means that wherever possible, block storage data calculation executes with efficiency similar to that of aggregate storage databases.

The following are some scenarios where hybrid aggregation is highly likely to improve calculation performance:

•          A block storage database has stored members that are not level 0, and are calculated according to hierarchy (rather than by calculation scripts).
•          A Dynamic Calc member has more than 100 children.
•          You are using a transparent partition between an empty aggregate storage target and a block storage source. If the formulas on the aggregate storage target are simple and translatable to block storage formula language, you can achieve fast results on block storage using hybrid aggregation.
•          You are using a transparent partition between two block storage databases, and calculation performance is a concern.

 

Outline Structure for Hybrid Aggregation

To use hybrid aggregation most effectively:

•          If there are non-level-0 stored members that are batch calculated based solely on their hierarchy, it’s recommended that you convert them to Dynamic Calc members.
•          If the conversion to Dynamic Calc members affects solve order for dependent formulas, you may also need to adjust the outline’s order of dimensions, and/or their dense or sparse configurations, to align the solve order with the previous batch calculation order.

Faster Queries for MDX Aggregate and Sum Functions

In aggregate storage databases, performance is improved for MDX queries containing the Aggregate or Sum functions. Essbase performs dependency analysis and uses a formula cache to execute these requests dynamically.

Using FIXPARALLEL Parallel Calculation

Overview of FIXPARALLEL

Although parallel calculation can be performed using the CALCPARALLEL configuration setting, in certain cases it might be beneficial to use the FIXPARALLEL command block method.

In a FIXPARALLEL command block, you input some commands to be executed, along with a number of threads (numThreads) and a member list (mbrList) specifying the database regions (slices) to be calculated. Essbase creates a list of tasks from the combinations in the member list, and divides the tasks across the threads.

The FIXPARALLEL method can be advantageous in the following cases:

•          If you need to use temporary variables during parallel calculation
•          If you need to use the DATACOPY, DATAEXPORT, or CLEARBLOCK commands
•          In conjunction with the @XREF or @XWRITE functions (You can now also use these with CALCPARALLEL; see SET FORCEPARALLELCALC)
•          If you need to export regions of the database in parallel. See the Example in this topic.
•          In cases where CALCPARALLEL is not meeting performance requirements, and your outline generates many empty tasks, or contains many task groupings with fewer tasks than threads made available to the calculation. See also “Task Selection Comparison of FIXPARALLEL and CALCPARALLEL.”

When considering converting FIX statements to FIXPARALLEL within a calculation script, follow these guidelines:

•          Focus on FIX statements that do not meet your performance needs using CALCPARALLEL.
•          Focus on FIX statements that require a substantial amount of work. Parallelizing a FIX statement requires some overhead, so trying to parallelize calculation passes with light workloads may not be beneficial. Heavier workloads, such as AGG and CALC DIM, are good candidates for FIXPARALLEL.
•          First, try parallelism with a single large sparse dimension, or by restricting mbrList to one or more hierarchies with a limited stored member count. You may continue adding dimensions to the member list to see if the calculation time continues to improve.

Note that when “parallel” calculation of tasks occurs, it means that the tasks are divided and executed concurrently in any order. In other words, there is no guarantee that any task will be executed before any other tasks. This is why the regions you specify must not have any data or calculation dependencies. For example, assume there are two parallel threads, and there is a division of work into tasks A, B, C, and D.

The possible sequence of calculation might be:

Thread #1 executes A and then C.

Thread #2 executes B and then D.

Or,

Thread #1 executes A.

Thread #2 executes B, then C, then D.

Or,

Thread #1 executes C and then A.

Thread #2 executes D and then B.

 

For the optimized performance of these functions on aggregate storage databases, include in your query the following elements:

•          Any of the following functions, used within the named set and/or as an argument to this function: Intersect, CurrentMember, Distinct, CrossJoin, PeriodsToDate. The use of any other functions (such as Members) disables the optimization.
•          The second parameter, accounts_member, must be included for optimal performance.

 

Error java.lang.OutOfMemoryError: getNewTla using Oracle EPM products

APPLIES TO:
Oracle EPM 11.1.2.x

GOAL
Fix the problem:
Error java.lang.OutOfMemoryError: getNewTla

FIX
Go to

1. HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\<Instance>\<Service>
2. Add the new string value with the name JVMOption<xx> (add one more value)
3. Edit the value of JVMOption with value:
   -XXtlasize:min=8k,preferred=128k
4. Increase the number in JVMOptionCount
5. Restart the service.

---

How To Restore a Folder Which Has Been Deleted from EPM Workspace.

APPLIES TO:

Hyperion BI+ – Version 9.0.0.0.00 to 11.1.2.2.000 [Release 9.0 to 11.1]

GOAL

Restore a file or folder which has been deleted from Enterprise Performance Management

FIX

All items published/created in Workspace (folders, reports, other files) have their information spread in two locations:

The actual item (for instance, the report itself) is being stored in the %HYPERION_HOME%\BIPlus\data\RM1_folder
The meta-data (its actual name, its last modification date, other properties, …) is stored in the BI repository.
Therefore if you wish to restore a folder or file which has been deleted from Workspace, it will be necessary to restore the environment using backups of both the server’s file system AND the BI repository taken before the folder has been deleted.

This implies restoring:
The server’s file system
The BI repository

Please note that any configuration detail inherent to the BI platform is stored in both the server’s file system AND the BI repository.

This implies that when restoring the environment, it is necessary to restore both the server’s file system and the BI repository using backups which have been taken AT THE SAME TIME from the same backup.

Not doing so (i.e. having the BI repository in out-of-synchronization with the server’s file system) will result in inconsistent behaviors in Workspace.

Essbase Server does not start

Applies to:
Hyperion Essbase – Version: 11.1.2.0.00 or later

Symptoms
When try start Essbase running “opmnctl startall” receive the message

Starting opnm and all managed proccess...
opmnctl startall: opmn failed to start.


In opmn.log have

[opmn][TRACE:1][][OPMN]Failed to open wallet (file:E:\Oracle\Middleware\user_projects\epmsystem\config\OPMN\opmn\wallet) [default password] (28759)


Solution
Copy the file cwallet.sso from E:\Oracle\Middleware\user_projects\epmsystem\EssbaseServer\essbaseserver1\bin\wallet to E:\Oracle\Middleware\user_projects\epmsystem\config\OPMN\opmn\wallet

Upload Error: the request was rejected because its size (xxxx) exceeds the configured maximum (104857600)

Problem
When try upload a file in workspace receive the message:

 Upload Error: the request was rejected because its size (xxxxx) exceeds the configured maximum (104857600)
 Recommended Action: Increase the upload max file size or choose a smaller sized file

Solution
In the Workspace, Navigate -> Administer -> Reporting and Analysis -> Web Applications -> Reporting and Analysis Framework Web-Applications -> Internal tab
Change the parameter, Max File Size Allowed For Publish (MB).

Need Restart Hyperion Planning to update the Changes in Business Rules or New Business Rules

Applies to:
Hyperion Planning – Version: 11.1.1.0.00 to 11.1.2.1.00

Symptoms
New Business Rules or changes to existing rules are not visible on Planning web until the Planning Web service is restarted

Solution

When the database server and web application server are in different time zones, the HBRCacheEvents will be deleted the moment entries
(new change events) are written to it. Planning also has a HBR engine that keeps polling HBRCacheEvents table for new events and delete old events to update the cache on the fly.
A Planning Web service restart will force the cache to be refreshed and thus the changes to be visible after this restart.
To solve this, you will need to either move one of the servers to be in same timezone as the other, or to anticipate the changes by scheduling restarts more frequently

Change the number of HRPrinter

To change a number of HRPrinter:

– Need the Financial Reporting Printer Service Configured
– Edit the file <FinancialReportingStudio>\products\financialreporting\bin\HRCreatePrinters.ini
– Change the parameter StopNum (default 5)
– Execute  <FinancialReportingStudio>\products\financialreporting\bin\HRCreatePrinters.exe

Time delay to update the definitions of a group in Shared Services

Hi.

When updating the group/members that belongs to a group in Shared Services, you might face a time delay to get this group definition refreshed.

To reduce this delay for update the Groups definition, you must update the “Groups Cache Refresh Interval” option.
To do it follow the below instructions:

-Log in to the Shared Services;
-Open de option “Administration\Configure User Directories”;
-Select the “Security Options” tab;
-Change the “Group Cache Refresh Interval” option.

The default refresh time is 60 minutes, and as we usually don’t explore these options, I think that is relevant to post this tip here!

Regards,
Igor.

cwallet.sso (Access is denied)

Applies to:

Oracle Universal Content Management – Version: 11.1.1.3.0 and later [Release: 11g and later ]
Information in this document applies to any platform.

When attempting to start the web server, startup fails and the following error occurs.

\Oracle\Middleware\user_projects\domains\\config\fmwconfig\bootstrap\cwallet.sso

Cause

This issue is caused by a permissions problem with the cwallet.sso file

Solution

Go to \Oracle\Middleware\user_projects\domains\\config\fmwconfig\bootstrap\cwallet.sso
and give acces to everyone to read the file

Cannot load application [%s] with error number [1052003]

Applies to:

Hyperion Essbase – Version: 9.3 and later
Information in this document applies to Linux Platform

Goal:

After applying the essbase patch, when trying to initialize any application receive the error:

Cannot load application [%s] with error number [1052003]

Solution

• Go to folder:
  /Middleware/EPMSystem11R1/products/Essbase/EssbaseServer/bin/
• type the commands:

chmod +x ESSSVR
chmod +x ESSCMD
chmod +x OPMNPing
chmod +x ESSUTF8
chmod +x essmsh
chmod +x essrehost
chmod +x essstage