Monday, September 26, 2016

Manage User Preferences globally in 11.1.2.4

Now you can manage user preferences globally in 11.1.2.4 Workspace settings.

Login as Admin in Workspace
Click on Navigate, Administer, Workspace Settings, Manage Preferences

Then select the user id that you want to setup the preferences for


Search for your user id and then move to the right side


Click on Next

Select your default screen that you would like to see, in my case I am going to select the Planning Vision Application



Settings are saved.  Now logout and then login to validate








Tuesday, September 6, 2016

HFM Tuning for MaxDataCacheSizeInMB

One HFM setting that i have come across during 11.1.2.4 performance testing is the MaxDataCacheSizeInMB

I had to adjust this in order to have optimal performance for my HFM applications and user experience.  The settings is now changed within Workspace.  

Navigate to Administer > Consolidation Administration > Admin Tasks > Settings

Below is what i had setup as Default settings of 4500.  Update to 30000 now.


My release level is 11.1.2.4.100

Hyperion 11.1.2.x and EPM products logging level settings

During our 11.1.2.4 config, we had to update the logging.xml file for our Hyperion products.  Some settings that we came across helped us with troubleshooting Hyperion issues.

Below is the navigation path and what each setting means:

1 - Navigate to your Oracle Home Middleware location.  In my case i have it on my E drive
E:\Oracle\Middleware\user_projects\domains\EPMSystem\config\fmwconfig\servers


Then navigate to the product that you want to apply the settings for, such as:

Shared Services and EPM Workspace -> FoundationServices
Essbase Administration Services -> EssbaseAdminServices
Provider Services -> AnalyticProviderServices
Reporting and Analysis Framework -> RaFramework
Financial Reporting -> FinancialReporting
Financial Management -> FMWebServices
Planning -> Planning
  1. Open logging.xml file in a text editor such as Notepad
  2. Scroll down to the section starting with <loggers>
  3. Change NOTIFICATION to any of the following logging levels.  NOTE, you will need to restart the services for the product that you are making changes to the settings.
Message TypeLevelDescription
INCIDENT_ERROR1A serious problem that may be caused by a bug in the product and that should be reported to Oracle Support.  Examples are errors from which you cannot recover or serious problems.
ERROR1A serious problem that requires immediate attention from the administrator and is not caused by a bug in the product.  An example is if Oracle Fusion Middleware cannot process a log file, but you can correct the problem by fixing the permissions on the document.
WARNING1A potential problem that should be reviewed by the administrator.
Examples are invalid parameter values or a specified file does not exist.
NOTIFICATION1A major lifecycle event such as the activation or deactivation of a primary sub-component or feature.  This is the default level for NOTIFICATION.
NOTIFICATION16A finer level of granularity for reporting normal events.
TRACE1Trace or debug information for events that are meaningful to administrators, such as public API entry or exit points.
TRACE16Detailed trace or debug information that can help Oracle Support diagnose problems with a particular subsystem.
TRACE32Very detailed trace or debug information that can help Oracle Support diagnose problems with a particular subsystem.