HSF Application growth and clean-up steps

Since Hyperion Strategic Finance (HSF) is a flat file system, many logs, archive files and deleted files can take up tons of space on the HSF Server. An HSF Administrator should implement these procedures on a monthly basis:

Below are some steps that can be taken to alleviate space issues.

1. Delete old log files '.LOG'
2. Delete old transaction files '.TRN'
   These are located on the HSF Server folder HSFData/Logs/_Finished directory
3. Clean out files that are sitting in the  ADB/_Delete folder
   Once these files are removed, they can no longer be retracted (***Note to take***)
4. Run archive repair on a regular basis to maintain a minimum number of archive files per entity. 
   This is especially important for companies with many entities and customers who create archive files often via the check in/check out process.

Smartview 11.1.2.5.620 and OBIEE plugin compatibility matrix

Recently came across this article and Smartview during our upgrade to the new release and thought of sharing it.......

Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support? 

	Smart View 11.1.2.5.620 and Later Compatible OBIEE Server Release
Smart View Release	11.1.1.9.0	12.2.1.0.0	12.2.1.1.0	12.2.1.2
11.1.2.5.600	Yes	Yes	No	No
11.1.2.5.610	Yes	Yes	Yes	Yes
11.1.2.5.620	Yes	Yes	Yes	Yes

Essbase Server Log file location for 11.1.2.x

Recently i came across this article and thought would share it here for folks looking for log file locations for Essbase releases 11.1.2.x

Essbase Server Log Files
v11.1.2.x	\Oracle\Middleware\user_projects\epmsystem1\ diagnostics\logs\essbase (essbase_0): Essbase.log Essbase_ODL.log SharedServices_Security_Client.log \Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\OPMN\opmn: console~Essbase1~EssbaseAgent~AGENT~1 EssbasePing.log Opmn.log Opmn.out

Planning Task List - View as Pie or Gantt Chart

We recently went to 11.1.2.4 for one of our Planning applications.  We rely on Task Lists, and one question that a user asked was.....How to manage Task Lists ?

In the new release, you can open the Task List and click on the View drop down on far right side. This will change your mode from Pie Chart to Project Gantt Chart view.

See attached screen shot:

Gantt Chart View

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