HFR Reports Migation - DB connections not showing up

Generally, when we do migration from existing environment to freshly installed environment, especially Reports, Database connection details for that must be there to replace details with current environment details.

For example: We have upgraded Hyperion 11.1.2.3 to 11.1.2.4 version, now migrating artifacts to new servers from Temporary server. Reports migrated using LCM and all reports migrated but while trying to reports popup with error Nested error. Because it is not connected to any DB Connection.

DB connection contains details of Name, Component type, Cluster or Server Name, user name and password and then application.

Here, we do not get existing connections. So, we can't replace connection with current one. For this kind of issue, we may try below options to get existing connections, so that you can change to your current.

1. From the Explore Repository, select the item to export.
2. Select File, and then Export.
3. Select the artifacts to export, and then click OK.

While importing Turn on User POV in user preferences and try to open report. It will ask you for DB connection. So you can change it.

Some time, just try to open reports, it will pop up with error that connection details wrong mentioned and to correct them, so that you can change them in Database connection Manager. POV must be Turn ON

Some times, Importing LCM by selecting some reports like for example one time 3-4 reports like that, after importing them you may get option to change DB connection.


Thanks,
Madhusudhan

HFM Copy of EPMA HFM application

With SQL

With Oracle

Oracle Hyperion - Weblogic Admin server as a windows service

To set Weblogic Admin server as a service, follow below steps

Go to weblogic Path: E:\Oracle\Middleware\wlserver_10.3\server\bin
Create a File named as InstallAdminService.cmd (Name would be any)

edit the same file and copy below text and save it.

SETLOCAL
SET DOMAIN_NAME=EPMSystem
SET USERDOMAIN_HOME=D:\Oracle\Middleware\user_projects\domains\EPMSystem
SET SERVER_NAME=AdminServer
set PORT=7001
set WL_HOME=D:\Oracle\Middleware\wlserver_10.3
SET PRODUCTION_MODE=true
SET MEM_ARGS=-Xms512m -Xmx1024m
SET JAVA_OPTIONS=-Dweblogic.Stdout="D:\Oracle\Middleware\user_projects\domains\EPMSystem\stdout.txt" -Dweblogic.Stderr="D:\Oracle\Middleware\user_projects\domains\EPMSystem\stderr.txt"
CALL "D:\Oracle\Middleware\user_projects\domains\EPMSystem\bin\setDomainEnv.cmd"
CALL "D:\Oracle\Middleware\wlserver_10.3\server\bin\installSvc.cmd"
ENDLOCAL

Go to installSvc.cmd file and Update Service (As per your requirement)
E:\Oracle\Middleware\wlserver_10.3\server\bin

Once updated above 2 files, run InstallAdminService.cmd file, it will create Service in Services Panel.

Change it from automatic to manual and logon if needed.

Test cases:
Check out Weblogic console is working or not
Check out Weblogic console is working or not with only port (with out console in URL)
Check out Weblogic console is starting or not using command line (using start admin server for weblogic server domain)

Thanks,
Madhusudhan

Hyperion 11.2 Updates

HYPERION ENTERPRISE PERFORMANCE MANAGEMENT (EPM) 11.2 ON-PREMISE RELEASE INFORMATION


Planned features of Hyperion EPM (On-Prem) 11.2.x include:

Hyperion Planning:

Smart Push
Dimension Editor SV extension
Extended Attribute support
Valid Intersections
Data Relationship Management
Batch scripts to ease EPMA replacement
Enhanced DRG Experience
DRG Mass Approvals
SFTP Connection

Hyperion Financial Management:

Automated Consolidations
Configurable by admin
Native Metadata Editor
Purging source tables after import
Performance improvements
SV, DB batch processing, etc.
Profitability and Cost Management
Expanded Custom Calcs for complex logic
POV Copy support for large outlines Tax Provisioning
Tax Automation Trace where the source is ICP
Enhanced Deferred Tax Classification logic
Financial Reports
Multi-Report Editing via Web Studio
Replace R&A repository
Book/Batch to output to MS Office Smart View
Chrome support for web launch (SUI)
Limited functional release for Office 365 Web/All clients

Hyperion EPM (On-Prem) Product/Features Discontinued in 11.2:

Hyperion Financial Management

Financial Management Analytics
Essbase Analytics Link for Hyperion Financial Management
Quantitative Management and Reporting for Solvency

Hyperion BI+

Interactive Reporting (IR)
Production Reporting  (SQR)
Web Analysis (WA)



Hyperion Planning:

Hyperion Strategic Finance
Crystal Ball (replaced by Predictive Planning)
Simplified User Interface (SUI)
Workforce Planning
Capital Expense Planning
Project Financial Planning
Offline Planning

Additional

EPM Architect (EPMA)
Disclosure Management
EPM Mobile



Thanks,
Madhusudhan

Hyperion 11.1.2.x Installation error: EPMINS-01098: User has to be a member of Administrators group

If you are doing installation on single or distribution environment, we may face below error.

EPMINS-01098: User has to be a member of Administrators group.

In case of below error also we can do below steps

Change below settings and restart server.

After restarting server, Try to Launch installTool.cmd file.

Thanks,

Madhusudhan

Hyperion: Excel automatically changes formula to smart view

One of the issue came across today while working with smartview, found below in Oracle Forums and Worked for us.

While copying excel sheets, "='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue is line adding up into every row of the sheet in formulas.


Symptom:

User opens a file and has the local HsTbar.xla path embedded at the front of the Smart View Function: "='C:\Oracle\SmartView\Bin\HsTbar.xla'!HsGetValue($B$8,"Scenario#"&$....). We also see this if a user opens a file directly from SharePoint, but the embedded path will have the SharePoint server URL in it. As you know, the Smart View function will not work in this state.



Corrective Action:

• In Excel, with the problem file open, go to Data > Edit Links.
• In the Edit Links dialog box, click the Change Source button.
• Browse to where Smart View is installed locally - for us it's C:\Oracle\SmartView\Bin (NOTE: you still need to follow these steps, even if the embedded path is the correct path for the HsTbar.xla).
• Select the HsTbar.xla file and Click OK.
• Click the Close button.

 At this point you should see the imbedded path is gone, allowing you to Refresh as normal. Also, you should be able to Save the file and re-open it without the embedded path from returning.



Thanks,
Madhusudhan

What if IE not supports Oracle EPM products

For example, we will take one scenario.

Internet explorer 11 is not supported with Hyperion 11.1.2.3 (Yes, it will support 11.1.2.3.500, 700+ etc with enterprise mode). That case if you open FDM web URL, you will get web application open in below format which is not accessible correctly.

Solution is simple, just go add this URL in IE 11 compatibility settings. Then you will FDM page, will looks good now.

Another scenario:
Internet explorer may not work with Hyperion 11.1.2.3.500 URLs, you can make them working by downloading IE version.

Open IE 11, then Click on F12, then go to Emulation, then select IE version 9 in the drop down settings. Now you URL will get loading page and workspace open.



Otherwise you can uninstall IE version 11, automatically IE previous version come up. So, you can go IE 9 in the same way. So that IE version will support for Hyperion 11.1.2.3.500 version.



Otherwise, you can install supported firefox version and add Remote XUL Manager to the browser. You can access Hyperion URLs without any issues in this scenario also. Firefox, you can find in support matrix.



Thanks,
Madhusudhan