Hyperion Essbase 11.1.2.4 and Shared Services MSAD Support Groups flag

Good day,

Forgot to post in Jan 2017, busy with year end stuff. 

Here is something I stumbled upon recently.  Trying to connect to Planning or Essbase and the Workspace(For Planning) or EAS(For Essbase) console would be hung up.

After troubleshooting and Oracle support help, we discovered that the MSAD Support Groups flag was checked during Shared Services configuration.  Once that was un-checked and services restarted, things start back to work again.

Version 11.1.2.4

Login into Shared Services
Then Administration
Then Configure Directories
Then pick your AD directory
Then click on MSAD Group Configuration
Uncheck the Support Groups and then restart your entire environment

Good Luck.

Thanks,

Azmat Bhatti

FDM load into HFM and find out the user id ?

We had an issue where a user loaded a wrong file via FDM into HFM and the audit log mentioned the id "Admin".

After doing some research with Oracle support, this is what i was told

"When users load data from Financial Data Quality Management (FDM) to Hyperion Financial Management (HFM) using any user ID, it shows that data has been loaded using admin ID only in HFM task audit log file. Unified Logon method has been selected in the Integration settings."

In order to fix the problem, we had to remove the "Admin" credentials from the Machine Profile and make sure the Logon method is set to Unified in the Integration settings.

We are on version 11.1.2.2 for FDM and HFM.

Hyperion Planning application migration using LCM for older releases

Good Day,

During my LCM migration from 11.1.2.2 to 11.1.2.4, i came across some interesting links.  Sharing it below.

This is for Classic application in Planning.

Release	Migrating Oracle Hyperion Planning Applications	Migrating Oracle Hyperion Planning Applications - Data (Note: Downloads a Zip file)
11.1.2.4	http://docs.oracle.com/cd/E57185_01/EPMMP/epm_migrate_planning_app.html	http://docs.oracle.com/cd/E57185_01/epm_migrate_planning_app_data.zip
11.1.2.3	http://docs.oracle.com/cd/E40248_01/epm.1112/epm_migrate_planning_app/epm_migrate_planning_app.html	http://docs.oracle.com/cd/E40248_01/epm.1112/epm_migrate_planning_app_data.zip
11.1.2.2	http://docs.oracle.com/cd/E17236_01/epm.1112/epm_migrate_planning_app/epm_migrate_planning_app.html	http://docs.oracle.com/cd/E17236_01/epm.1112/epm_migrate_planning_app_data.zip

HFM 11.1.2.4 and patch set level

Ever wonder where to look for the product/patch level for Hyperion installed products...there is a file on the Foundation server which can tell you this.

Navigate to your Oracle Home folder, like below.  We are looking at HFM here and once you navigate to the common folder, you will see the product_version.xml file

Below is a snapshot of HFM version/patch set level

Smartview and Private Connections - On Premise vs Cloud

Below is a list of Smartview private connections for On-Premise vs Cloud options.  Servername:Port will be your server, setup by your IT or Consulting partner.

On-Premises:

• Financial Management:
  • Financial Management 11.1.2.4.x and later:

    http(s)://servername:port/hfmadf/../hfmadf/officeprovider

  • Financial Management 11.1.2.3.x and earlier:

    http(s)://servername:port/hfmofficeprovider/hfmofficeprovider.aspx

• Hyperion Enterprise:

  http://servername:port/heofficeprovider/heofficeprovider.aspx

• Planning:

  http(s)://servername:port/HyperionPlanning/SmartView

• Essbase:

  http(s)://servername:port/aps/SmartView

• Reporting and Analysis:

  http(s)://servername:port/raframework/browse/listXML

• Financial Close Management:

  http://servername:port/fcc/servlets/smartview/fcmsvservlet

• Oracle Hyperion Strategic Finance:

  http://servername:port/StrategicPlanning/SmartView

• Oracle BI EE:

  http://servername:port/analytics/jbips

Cloud

• Planning for Oracle Planning and Budgeting Cloud Service

  http(s)://servername:port/HyperionPlanning/SmartView

• Reporting Settings

  http(s)://servername:port/raframework/browse/listXML

• Enterprise Performance Reporting

  http(s)://servername:port/epm/SmartView

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

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