Sunday, October 29, 2017

Hyperion Planning Forms Column Setting of Size to Fit

AUTOSIZE DOES NOT WORK IN IE11 BUT DOES IN FIREFOX

1. If you can use only IE and not Firefox, Turn off 'Size to Fit' to see the data properly.
2. Use Firefox instead of IE 11 which supports 'Size to Fit'.

Steps to check in Webform
1. Login to Planning as an Administrator.
2. Edit a form and for column properties to include 'Size to fit'.
3. Once done, open the Form in Firefox. Size to fit works as expected.
4. Open the same in IE11, Data is getting truncated with "...".

Tuesday, September 12, 2017

Hyperion HFM copy app from 11.1.2.2 to 11.1.2.4 and migration steps

We recently upgraded to Hyperion 11.1.2.4 and updated our HFM servers in Dev/QA/Prod to 11.1.2.4.205 patch level.

In order to bring my HFM application from 11.1.2.2 to 11.1.2.4, below are the steps we followed:

1- Run app copy on Dev 2.4 server using UDL from HFM 2.2 as source and Target HFM 2.4 UDL
2- Then run EPM system configuration on HFM 2.4 Dev server and select the option "Upgrade Applications from Earlier Release"
3- Then open the HFM 2.4 Dev Consolidations screen, register the app, provision the user and then the user can login
4- Run the app copy from Dev 2.4 to QA 2.4 and then QA 2.4 to Prod 2.4, since the app that was copied from 2.2 release is now in 2.4 format

Essbase Cloud and ESSCLI utility

http://docs.oracle.com/en/cloud/paas/analytics-cloud/essug/cli-command-reference.html

For all Essbase Cloud related commands and how to use the new utility.

Monday, September 4, 2017

Hyperion Smart View and Diagnostics toolbar

With the new Smart View 11.1.2.5.x release, there is a new Diagnostics toolbar functionality introduced to gather user input and view errors faced during Smart view functions.

To enable the functionality goto;
SmartviewàOptionsàAdvancedàShow Diagnostics Group on Smart View Ribbon


You will notice the Start/Stop Diagnostics buttons get enabled


You have various options to Mask Data or Members, and what you should send as errors…..



Log files are saved in this folder  C:\Users\username.domain\AppData\Roaming\Oracle\SmartView\Diagnostics
Once done, then click on Stop Diagnostics and click on Clear Diagnostics Folder to clear the data logs.


Wednesday, June 28, 2017

Essbase Release 11.1.2.4.000 Patch Set Update (PSU): 11.1.2.4.018

Essbase Features No Longer Supported in this Release

Delayed freespace recovery is no longer supported:
·        MaxL statement: alter database recover freespace
·        Oracle recommends using the alter database force restructure statement.
·        Configuration setting: DELAYEDRECOVERY

DRM Hyperion 11.2.x release updates from Kscope17

VERSION                     SUPPORTED UNTIL

11.1.2.3.x                       Mar 2018

DRM 11.1.2.4.x             DEC 2020

DRM 11.2.x                   DEC 2030

New certifications expected in 11.2.x:

- FMW 12
- Java 8, (JDK 1.8)

Third party:
- Windows server 2016
- SQL Server 2014, 2016
- Chrome and edge browsers

Tuesday, June 13, 2017

HFM MaxNumCubesInRAM settings...now in Workspace

MaxNumCubesInRAM

This setting controls the number of cubes that are held in memory at any given time. The number of cubes in memory is checked when either of the two conditions NumMinutesBeforeCheckingLRU or NumCubesLoadedBeforeCheckingLRU is reached. Lowering this setting can alleviate high memory usage for sparse applications (applications with many entities, but relatively few records per entity). 
This setting affects all data operations including consolidations and data retrievals.
Range: 100-500,000 - Default value: 60,000
Below is a screen shot of where you can find this setting in the new release 11.1.2.4
Navigate to Administer, Consolidation Administration, then expand Admin Tasks and then Settings.