Middlebury

Difference between revisions of "Hyperion"

 
(32 intermediate revisions by 6 users not shown)
Line 1: Line 1:
{{Stub}}
+
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!
  
== Hyperion 9  ==
+
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.
  
The College is upgrading to Hyperion 9 on Oct 27, 2008. See the [[Media:Hyperion9installation.pdf]] article for details on installing the new Hyperion.
+
== System Requirements  ==
  
== Installing the Interactive Reporting Web Client: ==
+
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]].
  
In order to run Hyperion Reports you will need to install the latest Interactive Reporting Web Client.
+
== Install the Interactive Reporting Web Client ==
  
[[File://hottub/installirwc/install.bat hottub/installirwc/]]
+
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.
  
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.
+
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.
  
== How do I access Hyperion:  ==
+
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]].
Go to the Hyperion server: http://go.middlebury.edu/hyperion?prod
 
  
== Re-Installing the Interactive Reporting Web Client:  ==
+
== Re-Install the Interactive Reporting Web Client:  ==
  
1. Open Control Panel -&gt; Add or Remove Programs
+
#[http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting]
  
2. Uninstall the entry for “Hyperion Interactive Reporting Web Client”
+
== Internet Explorer and Hyperion  ==
  
3. Once completed select No to restart the machine
+
Our current product version Hyperion EPM11 will run fine on Internet Explorer 8 and 9, but ''not'' on later versions.
  
4. Delete the following files from the C:\WINDOWS directory:
+
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:
  
&nbsp;&nbsp; a. Bqformat.ini
+
*add *.middlebury.edu to the trusted sites
 +
*add *.middlebury.edu to the list of allowed pop-ups
  
&nbsp;&nbsp; b. Bqformat_ev.ini
+
See [[Making Internet Explorer more compatible with Hyperion]] for details.
  
* Skip step 5 for those who have the desktop client tools installed&nbsp;(can check GAL for whether they are a&nbsp;member of "LIS Hyperion Explorer")
+
== Hyperion troubleshooting &amp; common problems  ==
  
5. Next remove any and all folders with Hyperion associated files (**Note: If any other products are installed such as the IR Studio skip this step)
+
Most problems with Hyperion can be resolved by uninstalling and reinstalling the Hyperion Client.
  
&nbsp;&nbsp; a. Check for a Hyperion folder under C:\Documents and Settings\*userprofile*\
+
To uninstall:
  
&nbsp;&nbsp; b. Check for Hyperion or Brio folders on the root of C:\ or in C:\Program Files
+
#Control Panel -&gt; Add/Remove Programs
 +
#uninstall the Hyperion Intelligence Client
  
6. Once all files and folders have been removed restart the machine
+
To reinstall:
  
7. Run the installer from the Hyperion menu Tools -&gt; Install -&gt; Interactive Reporting Web Client
+
Step-by-step reinstall instructions are available at [http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting (pdf)].
  
== Common problems with Hyperion ==
+
=== 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%.
  
Most problems with Hyperion can be resolved by uninstalling and reinstalling the Hyperion Client. Uninstalling: Control Panel -&gt; Add/Remove Programs, uninstall the Hyperion Intelligence Client Reinstalling: 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 instructions are available here: [[Hyperion Reinstall Steps]].
 
  
== Hyperion does not install under non-admin accounts<br> ==
+
===Hyperion client re-installs every time I log in  ====
  
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.<br>
+
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:
  
== Hyperion Client Installer refuses to install and reports a problem with the certificate<br>  ==
+
#Close any Internet Explorer windows you have open right now.
 +
#Open Internet Explorer and log on to Hyperion. '''Don't run a report yet.'''
 +
#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.
 +
#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'''.
 +
#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.
  
Here are the instructions for working around the certificate error.
+
=== Hyperion does not install under non-admin accounts  ===
  
1. Open internet explorer, click Tools - Internet Options. 2. Click the Security tab - Custom Level button.
+
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.
  
*Under ActiveX ensure the following are set to enabled
+
=== Hyperion Client refuses to install: problem with certificate  ===
  
Run ActiveX and plug-ins - Enabled
+
You can work around the certificate error by ensuring that Internet Explorer's settings are configured correctly:
  
Download Signed ActiveX Control - Enabled
+
#Open internet explorer, click Tools - Internet Options.
 +
#Click the Security tab - Custom Level button.
 +
#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'''
 +
#Click '''OK''', then '''Apply''', then '''OK'''.
 +
#Close and restart the browser. You should now be able to install Hyperion from the website (go/hyperion).
  
Script ActiveX controls marked as safe for scripting - Enabled
+
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'').
  
*Set the following to "Prompt"
+
=== Hyperion Runs But Reports Open in a Blank Grey Screen  ===
  
Download unsigned ActiveX Control - Prompt
+
If Hyperion was just installed, close the web browser and restart. If this does not resolve the issue then proceed to the following.
  
Initialize and script ActiveX controls not mark as safe - Prompt 3.
+
Cause: You may be trying to run Hyperion EMP11 with a higher version of Internet Explorer than is currently supported.
  
Click OK and Apply and OK. Restart the browser. You should now be able to install Hyperion from the website (go/hyperion). <br>
+
Solution:  You will need to drop back to the highest supported version of Internet Explorer.
  
For Helpdesk SRps, there are instructions for installing from a [https://mediawiki.middlebury.edu/wiki/hi/Installing_Hyperion_from_a_file_server direct server folder] (for SRPs).
+
=== Other troubleshooting tips  ===
  
Also see [[Older Hyperion Troubleshooting Notes|older hyperion troubleshooting notes]]
+
If Hyperion still won't work, here are some things to try.
  
== Firefox and Hyperion ==
+
*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").
  
Firefox versions 2.0 - 3.3 will work with Hyperion.  Officially, only version 2.0 is supported but it will run on 3.3.
 
  
== Making Internet Explorer more compatible with 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: add *.middlebury.edu to the trusted sites, add *.middlebury.edu to the list of allowed pop-ups. For details, see [[Making Internet Explorer more compatible with Hyperion]] for details.
 
 
== Hyperion will not run with Internet Explorer 8 ==
 
 
Oracle does not support running Hyperion on IE 8 yet.
 
 
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.
 
 
To Uninstall IE8 and revert to the previous version:
 
# Go to Start> Control Panel
 
# Add or Remove Programs
 
# Select to remove Windows Internet Explorer 8
 
# Reboot your computer.
 
 
You may still get prompted to install the update via Automatic Updates.
 
 
Stop Automatic Updates from reinstalling IE8
 
# Select Custom Install
 
# 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.
 
 
== 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: Most likely Internet Explorer 7 and Hyperion 9 are conflicting in some way.
 
 
Solution:
 
 
#Uninstall&nbsp;hyperion from Add/Remove programs.
 
#Still in Add/Remove programs scroll down to Windows Internet Explorer 7 and REMOVE / Uninstall Internet Explorer 7.
 
#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