Create an OCE (Open Catalog Extension) Connection File
Create an OCE (Open Catalog Extension) connection file for Hyperion 9.2 client against Legacy Warehouse
1. Go to Start ( Control Panel (Administrative Tools
Double click on Administrative Tools icon and Double click on Data Sources (ODBC)
[pic]
2. Click on System DSN Tab, Click Add and Highlight on MERANT OEM 5.1 32-BIT Sybase Wire Protocol and Click on Finish.
[pic]
3. Enter information on your ODBC Sybase Wire Protocol Driver Setup, example:
Data Source Name: enter your data source name (i.e. E1_COURSE_ODBC)
Description: enter your ODBC description (i.e. COURSE ODBC)
Network Library Name: Winsock
Network Address: enter an ASU network and port (i.e. enterprise1.asu.edu, 2500)
And click on Test Connection
[pic]
4. Under Login ID and Password: Enter your ware house User ID and Password and click on OK
[pic]
Note: If your connection is successful, the windows will prompt as follow
Test Connect: Connection established!
Click on OK and click on OK on ODBC Sybase Wire Protocol Driver Setup
[pic]
5. Open Hyperion Program
Start ( All Programs ( Hyperion Systems 9 BI+ ( Interactive Reporting Studio
On the Menu, click on Tools ( Connection ( Create…
[pic]
6. Choose ODBC and Sybase System drop down option and Check on Show advanced options and Prompt for database name and click on Next
[pic]
7. Under User Name and Password, enter your Data Warehouse User ID in the User Name box and your Data Warehouse password in the password box. Choose an appropriate Host. (i.e. E1_COURSE_ODBC) or Name you have defined on your data sources Name on Section 3 and click on Next
[pic]
8. Enter the desired database separate by commons in the database box. For example, “course, warehouse” and click on Next (FYI: The most common DB table are Financial, Human_Resource, Students and Warehouse.)
[pic]
9. Make sure to check on Exclude Hyperion Repository Tables and on Allow Non-joined Queries boxes and click on Next
[pic]
10. Make sure to check on Allow Change Database at Logon, click on Next
[pic]
11. Click on Next
[pic]
12. Click on Finish.
[pic]
Click on Yes
[pic]
13. Click on Save to save it in C:\Hyperion\BIPlus\data\Open Catalog Extensions
This is the end of the process that uses to create an OCE connection file.
[pic]
14. Now when you start up Hyperion to build a new query (when at the welcome box) click the upper Browse button and select E1_COURSE_ODBC or Name you have defined on Section 3. It will usually be in C:\Hyperion\BIPlus\Data\Open Catalog Extensions. Then click on OK.
[pic]
15. The login box comes up, enter your User ID and Password and click on OK
[pic]
16. Click on the Tables icons at the bottom left frame and HAPPY QUERYING!
After you browse to the E1_COURSE_ODBC.oce once, it will stay in the oce box and you can just double click on it to bring up the login box.
[pic]
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- creating document headers nevada
- beginners guide to freemind martin rinehart
- desktop post load procedure
- updated accuwage user guide based on validation
- administrator tips and troubleshooting
- troubleshooting
- course content and method of instruction
- outline for tr 20 user manual usda
- edis version 2 1 2 user guide
- webvram user guide
Related searches
- aesop create an absence
- how to create an email account
- how to create an effective mission statem
- how to create an effective mission statement
- create an infinite campus account
- how do i create an email account
- how to create an array in java
- i want to create an email address
- create an outlook email account
- create an event flyer free
- how do you create an amortization schedule
- how to create an amortization schedule excel