Middlebury

Difference between revisions of "Hyperion"

(Installing the Interactive Reporting Web Client:)
 
(42 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  ==
  
== Common problems with Hyperion ==
+
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]].
  
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]].
+
== Install the Interactive Reporting Web Client ==
  
== Hyperion does not install under non-admin accounts<br> ==
+
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.
  
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>
+
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.
  
== Hyperion Client Installer refuses to install and reports a problem with the certificate<br>  ==
+
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]].
  
Here are the instructions for working around the certificate error.
+
== Re-Install the Interactive Reporting Web Client:  ==
  
1. Open internet explorer, click Tools - Internet Options. 2. Click the Security tab - Custom Level button.
+
#[http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting]
  
*Under ActiveX ensure the following are set to enabled
+
== Internet Explorer and Hyperion  ==
  
Run ActiveX and plug-ins - Enabled
+
Our current product version Hyperion EPM11 will run fine on Internet Explorer 8 and 9, but ''not'' on later versions.
  
Download Signed ActiveX Control - Enabled
+
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:
  
Script ActiveX controls marked as safe for scripting - Enabled
+
*add *.middlebury.edu to the trusted sites
 +
*add *.middlebury.edu to the list of allowed pop-ups
  
*Set the following to "Prompt"
+
See [[Making Internet Explorer more compatible with Hyperion]] for details.
  
Download unsigned ActiveX Control - Prompt
+
== Hyperion troubleshooting &amp; common problems  ==
  
Initialize and script ActiveX controls not mark as safe - Prompt 3.
+
Most problems with Hyperion can be resolved by uninstalling and reinstalling the Hyperion Client.
  
Click OK and Apply and OK. Restart the browser. You should now be able to install Hyperion from the website (go/hyperion). <br>
+
To uninstall:
  
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).
+
#Control Panel -&gt; Add/Remove Programs
 +
#uninstall the Hyperion Intelligence Client
  
Also see [[Older Hyperion Troubleshooting Notes|older hyperion troubleshooting notes]]
+
To reinstall:
  
== Making Internet Explorer more compatible with Hyperion ==
+
Step-by-step reinstall instructions are available at [http://mediawiki.middlebury.edu/wikis/LIS/images/2/2e/Hyperion9installation.pdf Installing Hyperion Reporting (pdf)].
  
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.  
+
=== 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 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.
+
===Hyperion client re-installs every time I log in ====
  
Cause: Most likely Internet Explorer 7 and Hyperion 9 are conflicting in some way.
+
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:
  
Solution:
+
#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.
  
#Uninstall&nbsp;hyperion from Add/Remove programs.
+
=== Hyperion does not install under non-admin accounts  ===
#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  ==
+
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.
  
*[[Scheduled Distribution of Hyperion Reports with NO Output]]
+
=== Hyperion Client refuses to install: problem with certificate  ===
  
[[Category:Specific_applications]]
+
You can work around the certificate error by ensuring that Internet Explorer's settings are configured correctly:
  
== Re-Installing the Interactive Reporting Web Client: ==
+
#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).
  
1. Open Control Panel -&gt; Add or Remove Programs
+
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'').
  
2. Uninstall the entry for “Hyperion Interactive Reporting Web Client”
+
=== Hyperion Runs But Reports Open in a Blank Grey Screen  ===
  
3. Once completed select No to restart the machine
+
If Hyperion was just installed, close the web browser and restart. If this does not resolve the issue then proceed to the following.
  
4. Delete the following files from the C:\WINDOWS directory:
+
Cause: You may be trying to run Hyperion EMP11 with a higher version of Internet Explorer than is currently supported.
  
&nbsp;&nbsp; a. Bqformat.ini
+
Solution:  You will need to drop back to the highest supported version of Internet Explorer.
  
&nbsp;&nbsp; b. Bqformat_ev.ini
+
=== Other troubleshooting tips  ===
  
* 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")
+
If Hyperion still won't work, here are some things to try.
  
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)
+
*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").
  
&nbsp;&nbsp; a. Check for a Hyperion folder under C:\Documents and Settings\*userprofile*\
 
  
&nbsp;&nbsp; b. Check for Hyperion or Brio folders on the root of C:\ or in C:\Program Files
 
  
6. Once all files and folders have been removed restart the machine
+
== Hyperion Tech Notes  ==
  
7. Run the installer from the Hyperion menu Tools -&gt; Install -&gt; Interactive Reporting Web Client
+
*[[Scheduled Distribution of Hyperion Reports with NO Output]]
 
 
<br>
 
 
 
== Installing the Interactive Reporting Web Client:  ==
 
 
 
[file://hottub/installirwc/install.bat hottub/installirwc/install.bat]
 
 
 
[[Category:Hyperion]]
 

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