Planning and Smartview connection issue - Invalid User and Password message is misleading

We had a situation where users were unable to use Smartview with Planning and getting error message that Invalid User ID/Password. 

Once we asked the users to use Workspace, they got a message that "Application is in Maintenance Mode and no connections are allowed".  We asked the HP admin to make the application available to users.  This resolved the issue.

The Smartview message was misleading and it caused many users to lockout their AD accounts.

Supported Versions of Oracle RDB for Enterprise Performance Management (EPM) / Hyperion 11.1.2.4.x

https://blogs.oracle.com/proactivesupportepm/supported-versions-of-oracle-rdb-for-enterprise-performance-management-epm-hyperion-11124x

According to the document:

• Oracle DB version 12.2.0.2 was rebranded as Oracle DB version 18 and is certified with 11.1.2.4.x releases of EPM.
• DB version 12.2 was rebranded as Oracle DB version 19 and it, too, is certified with 11.1.2.4.x releases of EPM.

Hyperion DRM Query record limit

Recently we had an issue while running various queries in DRM, we would only get 5000 records.  While looking at System Preferences, this was discovered.
You can go into Administer, System Preferences and then WarnHL.
Default limit is 5000 records.  You can change this limit to a higher number, save the changes and re-run your queries.

Hyperion Calculation Manager Issues With Hyperion Planning

 Tuning considerations

• In the calcMgrConfig.properties file you may want to increase the HBR.timeout to 60000 and remove the comment # from this row
• In addition to traditional java settings of Xms and Xms you may want to consider increasing the default stack size as well –Xss
• Oracle recommends rules that take longer than one hour to be run in batch, not on the web but if you have some that take longer, consider increasing the session timeout on the web application server

11.1.2.x

Most issues with calculation manager will be captured in one of the following logs by default:

\\Oracle\Middleware\user_projects\domains\EPMSystem\servers\CalcMgr0\logs

Hyperion On-Premise 11.2 Features

On-Premises Release: 11.2 

• Scheduled for mid 2019
• Uplift to FMW 12g release
• Repository Simplification
 – Replacing of Foundation services with a simpler RDBMS repository
 – Content migration for FR/Workspace to RDBMS repository
• 3rd party certifications including:
 – OS: Linux 7, AIX 7.2, Windows 2016
 – RDBMS: Oracle 12.2, SQL Server 2016,
 – Browser: Edge, Chrome, Firefox
 – JDK 1.8
• Technical upgrade – out of place install
• Followed by a series of feature bearing PSUs
 – Modelled on the 11.1.2.4.20x series

Hyperion Financial Management 

 – Autonomous Consolidations 

 – Web based Metadata Editor 

 – Archiving\Deleting unwanted data 

 – Performance improvements 

SmartView

 – DB batch processing, etc.

Hyperion Planning 

 – Smart Push 

 – Dimension Editor SV extension 

 – Extended Attribute support 

 – Valid Intersections 

Data Relationship Management 

 – Scheduled Import, Exports & Books 

 – DRG Mass Approvals

Hyperion Financial Management Reports Migration to EPM Cloud

New Tool introduced for HFM Reports migration to EPM Cloud

https://cloudmarketplace.oracle.com/marketplace/en_US/listing/50393071

Hyperion Calculation Manager Performance Issue - Expanding Planning/Essbase node takes 5 Minutes

While attempting to Expand the Planing/Essbase node in Calculation Manager,  the user is observing it takes more than 5 minutes to display the contents.

STEPS
-----------------------
1. Login to calculation manager 
2. Expand the Planning/Essbase Tree (node)
3. Takes close to 5 minutes for the Tree to expand and display the contents

In order to resolve this, try this out on the server where Calc Manager is installed:

• Verify that the Dimension service is started and is up and running
• Start the Dimension server service if it is in the shut-down status
• Wait 2-3 minutes for the service to become stable
• Try to login into Calc Manager and expand the node