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

HFM Extended Analytics setup 11.1.2.4

Hyperion UPK setup

FDM to FDMEE Migration White Paper

FDM to FDMEE Migration White Paper
FDM to FDMEE Migration White Paper
FDM to FDMEE Migration White Paper
FDM to FDMEE Migration White Paper


https://knowepmbi.files.wordpress.com/2015/11/fdmtofdmee_migration.pdf

22659123 - FDM CLASSIC TO FDMEE MIGRATION UTILITY V 1.1 (Patch)


Thanks,
Madhusudhan

Hyperion Log file Locations

Here, you can find log locations for Hyperion components:

Essbase Logs:

https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s12.html

Planning Logs:
https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s14s01.html

HFM Logs:
https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s14s02.html

Smartview Logs:
https://docs.oracle.com/cd/E12825_01/epm.111/epm_install_troubleshooting/frameset.htm?ch03s07s04.html

Foundation Logs:
https://docs.oracle.com/cd/E57185_01/EPMTR/ch03s10.html


Thanks,
Mady

Oracle Hyperion Issue: Port number in WebLogicCluster parameter specified in httpd.conf is not an integer less than 65535

Recently we faced one issue, which is related to weblogic cluster details on httpd.conf (mod_wl_ohs)

While doing regular maintenance activities, we have restarted all services over weekend. We have environment of 5 servers, but one of the server services not working in workspace, even services are up and running in particular. We have reporting and analysis, FR in that server, we got startup document error, no Explore button in workspace.

If we click okay, startup document error popup page. Next Internal error popup.

When i click Show details, i found below error msg.

<HTML><HEAD><TITLE>Weblogic Bridge Message</TITLE></HEAD> <BODY><H2>Failure of server APACHE bridge:</H2><P><hr><PRE>Port number in WebLogicCluster parameter specified in httpd.conf is not an integer less than 65535, or servers are not specified correctly. Cannot continue.</PRE><P>
<hr> </BODY></HTML>

Before proceeding with any changes here, please take proper backup and proceed..!!


Check out below files in Foundation server (if OHS configured along with Foundation), Otherwise in OHS server.



Solution:

When i verified httpd.conf file and mod_wl_ohs file, in mod_wl_ohs file, whatever services we have in this reporting server, that is not correct. How it got updated in that file we don't know.

Replaced that hostname with correct hostname and restarted services.

Now issues resolved..!!

Thanks,
Mady