Hyperion Performance Suite Client 8.3.2 Service Pack 4 Installation Procedure (With a previous Brio or Hyperion installed)
1. Check Your Hard Drive Space:
You need at least 200 MB for Sybase 12, 150 MB for Hyperion Performance Suite Client. You can install on any available drive (C:, D: etc). There are five directories from this website.
1. Hyperion 8.3.2 Client
2. Hyperion 8.3.2SP4 Patch
3. Default Connection File
4. Instructional Manual
5. Sybase 12
Download each file separately, by right click and choose Save Target as .., and save it on your desktop and any location on your computer
In order to connect to the Warehouse, Sybase 12 needs to be installed in
your computer before installing a Hyperion Client 8.3.2 and you have to log on
as an Administrator of your computer. If Sybase 12 already installed your
computer skip Step2 and go directly to Step 3.
2. Install Sybase 12 if you have Windows 2000, XP
§ Detailed instruction for installing Sybase 12 is in
§ http://www.asu.edu/it/licensing/sybase
§ Log on with your ASURITEID and password and follow detailed instruction for installing Sybase 12
3. Install Hyperion Performance Suite Client Service 8.3.2
A. Download a HyperionClient83.zip file below the directory “1.Hyperion 8.3.2”, unzip it. And then double click on Setup.exe icon, which is located in the HyperionClient83/ 1.Hyperion 8.3.2\clientCD”.
B. The Install Shield Wizard starts and displays a progress bar while the JVM loads, followed by the Hyperion Performance Suite Client Tools splash screen, then by the Language dialog box.
C. Select an English as a language, then click Next. The Welcome dialog box is displayed.
D. Click Next to proceed with the installation. The Software License Agreement dialog box is displayed.
E. Read the Software License Agreement. To continue with the installation, Select the I accept the terms of the license agreement option and click Next.
F. When the License Key dialog box is displayed, enter the license key. Click OK and click Next.
(Note: If you don’t have the license key, email to , include your ASURITEID, your ASU affiliated department and justify why you need to install Hyperion Desktop Client)
G. Select Express option and then click Next.
H. Make sure to choose Destination location to change the install location. Click the Browse button and change BrioQuery to Brio8 for the destination Folder. That will allow it to install in parallel with BrioQuery or Brio6. If you have it on your computer. Click Next.
If you are prompted to create a new directory click Yes and then click Next.
I. Verify the installation choices, then click Next. Or Click Back to change any of the listed parameters.
The installer displays a progress bar while it automatically copies files into target directories.
J. If you have or had a pervious Brio installation choose one of the following to determine the default value and then click Next
· Update the default values so they point to the new INSTALL_HOME
· Leave the default values as they are, and copy the new sample OCEs and BQYs
· Leaves the default values as they are, and do not copy sample files
K. The Hyperion Performance Suite installation is completed. Uncheck the ViewLog box , and click Next.
L. Make sure you save any work open in another application and then Select Yes, restart my computer option and click Finish.
4. Update Service Pack 4
· To update a service pack 4, download brioqry.exe from below the directory “2. Hyperion 8.3.2SP4 Patch” to your desktop. Copy and paste brioqry.exe to the existing directory where the old brioqry.exe file resides, thereby replacing the old brioqry.exe with the new one (i.e. C:\ProgramFiles\Brio\Brio8\Client\Program).
5. Create or Modify an OCE (Open Catalog Extension) Connection File
Download a default.oce file from the directory “3. Default Connection File”.
Copy and paste the file default.oce to the directory
“C:\Program Files\ Brio\ Brio8\Client\Program\OpenCatalogExtension\”.
Now, modify default.oce according to preference. To do so
A. Open Hyperion Program and click on Tools, Connection, and Modify.
B. Select the default.oce file from Open Catalog Extension subdirectory and
Click open.
C. Choose Open Client and Sybase System drop down option. Click on Next.
D. Enter your Data Warehouse User ID in the User Name box and your
Data Warehouse Password in the Password box. Choose enterprise1 in Host drop down option. Enter zero in both Server Severity and API Severity boxes and click on Next .
E. Enter the desired databases separated by commas in the DB Name
box. For example “Student, Course, warehouse, Census” (without the quote marks, please!). Click on Next. (FYI: the most common DB tables are: Financial, Human_Resource, Students, and Warehouse.)
F. Make sure to Check on Exclude Brio Repository Tables. And on Allow Non-Joined Queries boxes. Click on Next.
G. Make sure to check Allow Change Database at Logon, Click on Next
H. Click on Finish.
I. Click on Yes
J. Click on Save to save it in C:\ProgramFiles\Brio\Brio8\Client\Program\OpenCatalogExtensions
Click Yes to save the default.oce or click No if you want to name something different, for example, Student.oce.
NOTE: If you do save the file with a name other than “default.oce” there will be an extra step if you exchange query files with other people. Hyperion looks for the oce file name used the last time the query was saved. If someone sends you a file that uses default.oce, when you process it the query will not be able to find default.oce. It will give you an error message and you will have to click the Select button and select an oce file of yours to use instead. The same thing will happen if you send a query to someone else.
This is the end of the process that is used to modify an oce connection file. Now when you start up Hyperion, to build a new query (when at the Welcome box) click the upper Browse button and select default.oce (or other name). It will usually be in C:\ProgramFiles\Brio\Brio8\Client\Program\OpenCatalogExtensions. Then click OK.
The login box comes up, enter your User ID and Password and click OK.
Click on the Tables icon in the bottom left frame and HAPPY QUERYING! After you browse to the default.oce once, it will stay in the oce box and you can just double click on it to bring up the login box.
1