Middlebury

Difference between revisions of "Hyperion"

(Hyperion will not run with Internet Explorer 8)
 
(21 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Hyperion can be found and installed on the Hyperion server: http://go.middlebury.edu/hyperion?prod
+
Hyperion can be found and installed best from Middfiles.  Previously circulated instructions to force-load Hyperion by running a query (report) from Hyperion's Workspace should be avoided, as it typically takes 20 minutes to load using that method!
  
See the [[Media:Hyperion9installation.pdf]] article for details on installing the new Hyperion.
+
Instead, see the [http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting] article for details on installing the currently used version of Hyperion.
  
== Install the Interactive Reporting Web Client ==
+
== System Requirements  ==
  
In order to run Hyperion Reports you will need to install the latest Interactive Reporting Web Client. It can be found on Hottub server at <code>//hottub/installirwc/install.bat hottub/installirwc/</code>.
+
Hyperion is very picky about the version of Internet Explorer installed (it's a Windows-only program that needs Internet Explorer). <span style="color:red">As of 9/14/15, Internet Explorer version 11 is supported.</span> Visit this page for further information about system requirements for the Hyperion Client:&nbsp;[[Reporting_&_Business_Intelligence|Reporting_&amp;_Business_Intelligence]].
  
NOTE: If you are accessing Hyperion from anywhere other than ON CAMPUS, you MUST use a VPN client (Virtual Private Network) to create a secure connection. If you do not have a VPN client on your computer, contact the Helpdesk at x2200.
+
== Install the Interactive Reporting Web Client ==
  
== Re-Install the Interactive Reporting Web Client:  ==
+
In order to run Hyperion Reports you will need to install the latest Interactive Reporting Web Client (aka Hyperion Client). The Hyperion Client is built-into the standard Middlebury College image, therefore, normally it does not need to be installed (it's already there!). If a new version is available, it is distributed automatically. See the system requirements section above before attempting to install Hyperion manually.
  
# Open Control Panel -&gt; Add or Remove Programs
+
Hyperion can be manually installed by following these instructions: [http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting]. If you find that you have popup blockers in place, you will need to enable popups.
# Uninstall the entry for “Hyperion Interactive Reporting Web Client”
 
# Once completed select No to restart the machine
 
# Delete the following files from the C:\WINDOWS directory:
 
#* Bqformat.ini
 
#* Bqformat_ev.ini
 
# Next remove any and all folders with Hyperion associated files.<br> ('''Note:''' If desktop client tools or any other products are installed, such as the IR Studio, '''skip this step.''' You can check GAL to see whether you are a member of "LIS Hyperion Explorer".)
 
#* Check for a Hyperion folder under C:\Documents and Settings\*userprofile*\
 
#* Check for Hyperion or Brio folders on the root of C:\ or in C:\Program Files
 
# Once all files and folders have been removed restart the machine
 
# Run the installer from the Hyperion menu Tools -&gt; Install -&gt; Interactive Reporting Web Client
 
  
== Hyperion browser compatibility ==
+
NOTE: If you are accessing Hyperion from anywhere other than ON CAMPUS, you MUST use a VPN client (Virtual Private Network) to create a secure connection. If you do not have a VPN client on your computer, please see [[VPN_Setup_on_Windows,_Mac_and_Linux]].
  
==== Firefox and Hyperion ====
+
== Re-Install the Interactive Reporting Web Client:  ==
  
Firefox versions 2.0 - 3.3 will work with Hyperion. Officially, only version 2.0 is supported but it will run on 3.3.
+
#[http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting]
  
==== Enable pop-ups in Internet Explorer to ensure Hyperion compatibility ====
+
== Internet Explorer and Hyperion ==
  
Hyperion needs to open certain screens in a pop-up window, so you need to configure your browser to allow pop-ups for Hyperion. In brief:
+
Our current product version Hyperion EPM11 will run fine on Internet Explorer 8 and 9, but ''not'' on later versions.
* add *.middlebury.edu to the trusted sites
 
* add *.middlebury.edu to the list of allowed pop-ups
 
  
See [[Making Internet Explorer more compatible with Hyperion]] for details.
+
Enable pop-ups in Internet Explorer to ensure Hyperion compatibility.  Hyperion needs to open certain screens in a pop-up window, so you need to configure your browser to allow pop-ups for Hyperion. In brief:
  
==== Hyperion and Internet Explorer 8  ====
+
*add *.middlebury.edu to the trusted sites
 +
*add *.middlebury.edu to the list of allowed pop-ups
  
Internet Explorer 8 will only work with Hyperion 9.3.3 Service Pack.&nbsp; This service pack was implemented here at Middlebury on 11/9/2010.&nbsp; Versions of Hyperion prior to this service pack will not run.&nbsp; If you need to roll-back IE8 to IE7 then perform the following steps:
+
See [[Making Internet Explorer more compatible with Hyperion]] for details.
  
 +
== Hyperion troubleshooting &amp; common problems  ==
  
 +
Most problems with Hyperion can be resolved by uninstalling and reinstalling the Hyperion Client.
  
Oracle does not support running Hyperion on IE 8 yet.
+
To uninstall:
  
If you installed the IE8 update via Automatic Updates, you can roll back to IE7. If you need assistance with these steps, please contact the helpdesk.
+
#Control Panel -&gt; Add/Remove Programs
 +
#uninstall the Hyperion Intelligence Client
  
To Uninstall IE8 and revert to the previous version:  
+
To reinstall:
  
#Go to Start&gt; Control Panel
+
Step-by-step reinstall instructions are available at [http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting (pdf)].
#Add or Remove Programs
 
#Select to remove Windows Internet Explorer 8
 
#Reboot your computer
 
#Open Internet Explorer 7
 
#Go to Tools &gt; Internet Options &gt; Security &gt; Reset all zones to default level
 
#Go to Tools &gt; Internet Options &gt; Advanced &gt; Restore advanced settings &gt; Reset
 
#Restart IE
 
  
You may still get prompted to install the update via Automatic Updates.  
+
=== When I click to open a Hyperion report folder using IE 11, a different folder is opened ===
 +
This issue can be resolved by restoring Internet Explorer 11's zoom setting to 100%.  To do this, click the gear icon at the top right, then trace to Zoom and select 100%.
  
Stop Automatic Updates from reinstalling IE8
 
  
#Select Custom Install
+
===Hyperion client re-installs every time I log in ====
#Uncheck Internet Explorer 8 for Windows XP
 
#Check Don’t notify me about these updates again if you do not want to be prompted again to install IE8.
 
 
 
[[Category:Hyperion]]
 
 
 
== Hyperion troubleshooting & common problems ==
 
 
 
Most problems with Hyperion can be resolved by uninstalling and reinstalling the Hyperion Client.
 
 
 
To uninstall:
 
# Control Panel -&gt; Add/Remove Programs
 
# uninstall the Hyperion Intelligence Client
 
 
 
To reinstall:
 
# Go to the Hyperion server: http://go.middlebury.edu/hyperion?prod
 
# navigate to a report (will have a BQY extension)
 
# you will be prompted to install the client.
 
# If you have a pop-up blocker on your web browser, it will block the client installation.
 
 
 
Step-by-step reinstall instructions are available at [[Hyperion Reinstall Steps]].
 
 
 
==== Hyperion client re-installs every time I log in ====
 
  
 
In some cases, Internet Explorer won't "remember" the Interactive Web Reporting Client. As soon as you close Internet Explorer, the install will be erased and you'll have to wait a minute while the client re-installs next time you open Hyperion. While this is just an annoyance, the time involved can add up. To solve this problem:
 
In some cases, Internet Explorer won't "remember" the Interactive Web Reporting Client. As soon as you close Internet Explorer, the install will be erased and you'll have to wait a minute while the client re-installs next time you open Hyperion. While this is just an annoyance, the time involved can add up. To solve this problem:
  
# Close any Internet Explorer windows you have open right now.
+
#Close any Internet Explorer windows you have open right now.
# Open Internet Explorer and log on to Hyperion. '''Don't run a report yet.'''
+
#Open Internet Explorer and log on to Hyperion. '''Don't run a report yet.'''
# In the Hyperion menu bar, go to '''Tools''' -> '''Install''' -> Interactive Web Reporting Client.
+
#In the Hyperion menu bar, go to '''Tools''' -&gt; '''Install''' -&gt; Interactive Web Reporting Client.
# The Hyperion client installer should appear in a small pop-up window. Ignore it for the moment.
+
#The Hyperion client installer should appear in a small pop-up window. Ignore it for the moment.
# Look carefully in the Internet Explorer window behind it, at the top, for a yellow bar that says something like "Internet Explorer has blocked an ActiveX control...". Click on this bar, then click on '''Run ActiveX control'''.
+
#Look carefully in the Internet Explorer window behind it, at the top, for a yellow bar that says something like "Internet Explorer has blocked an ActiveX control...". Click on this bar, then click on '''Run ActiveX control'''.
# IE will ask you if you are sure you want to run the installer. Click '''Run'''.  
+
#IE will ask you if you are sure you want to run the installer. Click '''Run'''.
# Follow through with any other open dialog boxes, then you should be redirected back to the Hyperion login page.  
+
#Follow through with any other open dialog boxes, then you should be redirected back to the Hyperion login page.
# Log in again, and try running a report. If all works correctly, the installer won't appear and you'll be good to go.
+
#Log in again, and try running a report. If all works correctly, the installer won't appear and you'll be good to go.
  
==== Hyperion does not install under non-admin accounts ====
+
=== Hyperion does not install under non-admin accounts ===
  
 
During the install process, Hyperion does not ask for admin rights; there's no indication that it needs them, the installer page just stays on "checking status". Temporarily granting admin privileges to the account resolves the problem. I had to install Hyperion under the account in question, while I could install it from our usual admin account, the account in question would not see the installation.
 
During the install process, Hyperion does not ask for admin rights; there's no indication that it needs them, the installer page just stays on "checking status". Temporarily granting admin privileges to the account resolves the problem. I had to install Hyperion under the account in question, while I could install it from our usual admin account, the account in question would not see the installation.
  
==== Hyperion Client refuses to install: problem with certificate ====
+
=== Hyperion Client refuses to install: problem with certificate ===
  
 
You can work around the certificate error by ensuring that Internet Explorer's settings are configured correctly:
 
You can work around the certificate error by ensuring that Internet Explorer's settings are configured correctly:
# Open internet explorer, click Tools - Internet Options.
+
 
# Click the Security tab - Custom Level button.
+
#Open internet explorer, click Tools - Internet Options.
# Under ActiveX options, ensure the following settings are set as follows:
+
#Click the Security tab - Custom Level button.
#* Run ActiveX and plug-ins - '''Enabled'''
+
#Under ActiveX options, ensure the following settings are set as follows:
#* Download Signed ActiveX Control - '''Enabled'''
+
#*Run ActiveX and plug-ins - '''Enabled'''
#* Script ActiveX controls marked as safe for scripting - '''Enabled'''
+
#*Download Signed ActiveX Control - '''Enabled'''
#* Download unsigned ActiveX Control - '''Prompt'''
+
#*Script ActiveX controls marked as safe for scripting - '''Enabled'''
#* Initialize and script ActiveX controls not mark as safe - '''Prompt'''
+
#*Download unsigned ActiveX Control - '''Prompt'''
# Click '''OK''', then '''Apply''', then '''OK'''.
+
#*Initialize and script ActiveX controls not mark as safe - '''Prompt'''
# Close and restart the browser. You should now be able to install Hyperion from the website (go/hyperion).
+
#Click '''OK''', then '''Apply''', then '''OK'''.
 +
#Close and restart the browser. You should now be able to install Hyperion from the website (go/hyperion).
  
 
For Helpdesk staff, there are instructions for [https://mediawiki.middlebury.edu/wiki/hi/Installing_Hyperion_from_a_file_server installing from a direct server folder] (''for SRPs only'').
 
For Helpdesk staff, there are instructions for [https://mediawiki.middlebury.edu/wiki/hi/Installing_Hyperion_from_a_file_server installing from a direct server folder] (''for SRPs only'').
  
==== Other troubleshooting tips ====
+
=== Hyperion Runs But Reports Open in a Blank Grey Screen  ===
  
If Hyperion still won't work, here are some things to try.
+
If Hyperion was just installed, close the web browser and restart. If this does not resolve the issue then proceed to the following.
 +
 
 +
Cause: You may be trying to run Hyperion EMP11 with a higher version of Internet Explorer than is currently supported.
  
* Clear the SSL cache in Internet Explorer (Internet Explorer => Tools => Internet Options => click on the Content tab, then click "Clear SSL state").
+
Solution: You will need to drop back to the highest supported version of Internet Explorer.
* Check the date on the computer. If the date is incorrect, the computer may think that the certificate has expired. Correct the date and try again.
 
* Visit http://update.microsoft.com and review the optional updates. There may be a "root certificates" update that has not been installed. Reboot after installing that and try again.
 
* Clear temp files (Internet Explorer => Tools => Internet Options => on the main/general tab click "Delete Files" or "Delete" (when prompted put a checkmark next to "all files").
 
  
==== Hyperion Runs But Reports Open in a Blank Grey Screen ====
+
=== Other troubleshooting tips ===
  
If Hyperion was just installed, close the web browser and restart. If this does not resolve the issue then proceed to the following.  
+
If Hyperion still won't work, here are some things to try.
  
Cause: Most likely Internet Explorer 7 and Hyperion 9 are conflicting in some way.  
+
*Clear the SSL cache in Internet Explorer (Internet Explorer =&gt; Tools =&gt; Internet Options =&gt; click on the Content tab, then click "Clear SSL state").
 +
*Check the date on the computer. If the date is incorrect, the computer may think that the certificate has expired. Correct the date and try again.
 +
*Visit http://update.microsoft.com and review the optional updates. There may be a "root certificates" update that has not been installed. Reboot after installing that and try again.
 +
*Clear temp files (Internet Explorer =&gt; Tools =&gt; Internet Options =&gt; on the main/general tab click "Delete Files" or "Delete" (when prompted put a checkmark next to "all files").
  
Solution:
 
  
#Uninstall hyperion from Add/Remove programs.
 
#Reboot.
 
#Install&nbsp;Hyperion.
 
  
 
== Hyperion Tech Notes  ==
 
== Hyperion Tech Notes  ==
  
* [[Scheduled Distribution of Hyperion Reports with NO Output]]
+
*[[Scheduled Distribution of Hyperion Reports with NO Output]]

Latest revision as of 12:50, 22 March 2018

Hyperion can be found and installed best from Middfiles. Previously circulated instructions to force-load Hyperion by running a query (report) from Hyperion's Workspace should be avoided, as it typically takes 20 minutes to load using that method!

Instead, see the Installing Hyperion Reporting article for details on installing the currently used version of Hyperion.

System Requirements

Hyperion is very picky about the version of Internet Explorer installed (it's a Windows-only program that needs Internet Explorer). As of 9/14/15, Internet Explorer version 11 is supported. Visit this page for further information about system requirements for the Hyperion Client: Reporting_&_Business_Intelligence.

Install the Interactive Reporting Web Client

In order to run Hyperion Reports you will need to install the latest Interactive Reporting Web Client (aka Hyperion Client). The Hyperion Client is built-into the standard Middlebury College image, therefore, normally it does not need to be installed (it's already there!). If a new version is available, it is distributed automatically. See the system requirements section above before attempting to install Hyperion manually.

Hyperion can be manually installed by following these instructions: Installing Hyperion Reporting. If you find that you have popup blockers in place, you will need to enable popups.

NOTE: If you are accessing Hyperion from anywhere other than ON CAMPUS, you MUST use a VPN client (Virtual Private Network) to create a secure connection. If you do not have a VPN client on your computer, please see VPN_Setup_on_Windows,_Mac_and_Linux.

Re-Install the Interactive Reporting Web Client:

  1. Installing Hyperion Reporting

Internet Explorer and Hyperion

Our current product version Hyperion EPM11 will run fine on Internet Explorer 8 and 9, but not on later versions.

Enable pop-ups in Internet Explorer to ensure Hyperion compatibility. Hyperion needs to open certain screens in a pop-up window, so you need to configure your browser to allow pop-ups for Hyperion. In brief:

  • add *.middlebury.edu to the trusted sites
  • add *.middlebury.edu to the list of allowed pop-ups

See Making Internet Explorer more compatible with Hyperion for details.

Hyperion troubleshooting & common problems

Most problems with Hyperion can be resolved by uninstalling and reinstalling the Hyperion Client.

To uninstall:

  1. Control Panel -> Add/Remove Programs
  2. uninstall the Hyperion Intelligence Client

To reinstall:

Step-by-step reinstall instructions are available at Installing Hyperion Reporting (pdf).

When I click to open a Hyperion report folder using IE 11, a different folder is opened

This issue can be resolved by restoring Internet Explorer 11's zoom setting to 100%. To do this, click the gear icon at the top right, then trace to Zoom and select 100%.


Hyperion client re-installs every time I log in =

In some cases, Internet Explorer won't "remember" the Interactive Web Reporting Client. As soon as you close Internet Explorer, the install will be erased and you'll have to wait a minute while the client re-installs next time you open Hyperion. While this is just an annoyance, the time involved can add up. To solve this problem:

  1. Close any Internet Explorer windows you have open right now.
  2. Open Internet Explorer and log on to Hyperion. Don't run a report yet.
  3. In the Hyperion menu bar, go to Tools -> Install -> Interactive Web Reporting Client.
  4. The Hyperion client installer should appear in a small pop-up window. Ignore it for the moment.
  5. Look carefully in the Internet Explorer window behind it, at the top, for a yellow bar that says something like "Internet Explorer has blocked an ActiveX control...". Click on this bar, then click on Run ActiveX control.
  6. IE will ask you if you are sure you want to run the installer. Click Run.
  7. Follow through with any other open dialog boxes, then you should be redirected back to the Hyperion login page.
  8. Log in again, and try running a report. If all works correctly, the installer won't appear and you'll be good to go.

Hyperion does not install under non-admin accounts

During the install process, Hyperion does not ask for admin rights; there's no indication that it needs them, the installer page just stays on "checking status". Temporarily granting admin privileges to the account resolves the problem. I had to install Hyperion under the account in question, while I could install it from our usual admin account, the account in question would not see the installation.

Hyperion Client refuses to install: problem with certificate

You can work around the certificate error by ensuring that Internet Explorer's settings are configured correctly:

  1. Open internet explorer, click Tools - Internet Options.
  2. Click the Security tab - Custom Level button.
  3. Under ActiveX options, ensure the following settings are set as follows:
    • Run ActiveX and plug-ins - Enabled
    • Download Signed ActiveX Control - Enabled
    • Script ActiveX controls marked as safe for scripting - Enabled
    • Download unsigned ActiveX Control - Prompt
    • Initialize and script ActiveX controls not mark as safe - Prompt
  4. Click OK, then Apply, then OK.
  5. Close and restart the browser. You should now be able to install Hyperion from the website (go/hyperion).

For Helpdesk staff, there are instructions for installing from a direct server folder (for SRPs only).

Hyperion Runs But Reports Open in a Blank Grey Screen

If Hyperion was just installed, close the web browser and restart. If this does not resolve the issue then proceed to the following.

Cause: You may be trying to run Hyperion EMP11 with a higher version of Internet Explorer than is currently supported.

Solution: You will need to drop back to the highest supported version of Internet Explorer.

Other troubleshooting tips

If Hyperion still won't work, here are some things to try.

  • Clear the SSL cache in Internet Explorer (Internet Explorer => Tools => Internet Options => click on the Content tab, then click "Clear SSL state").
  • Check the date on the computer. If the date is incorrect, the computer may think that the certificate has expired. Correct the date and try again.
  • Visit http://update.microsoft.com and review the optional updates. There may be a "root certificates" update that has not been installed. Reboot after installing that and try again.
  • Clear temp files (Internet Explorer => Tools => Internet Options => on the main/general tab click "Delete Files" or "Delete" (when prompted put a checkmark next to "all files").


Hyperion Tech Notes

Powered by MediaWiki