Solved

how to access Hyperion database and retrieve the data?

Posted on 2007-03-21
10
282 Views
Last Modified: 2008-02-01
I installed the Hyperion application software whick like the following: http://www.controller.iastate.edu/controller/hypdoc.pdf .

The question is how to login to the database so I can retrieve the data and automate my process.  

Thanks a lot!!!
0
Comment
Question by:ewang1205
  • 6
  • 3
10 Comments
 
LVL 21

Expert Comment

by:Yurich
ID: 18766729
it doesn't say anything in the manual?
0
 
LVL 21

Expert Comment

by:Yurich
ID: 18766734
usually, you would create an odbc data source, provide all credentials, then you would use it from your application
0
 

Author Comment

by:ewang1205
ID: 18767193
Yurich:

ODBC sounds right.  Do you have sample program?  What kind of Hyperion database is that?

Thanks.
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 21

Accepted Solution

by:
Yurich earned 500 total points
ID: 18774163
By that, I meant going to Control Panel -> Administrative Tools -> Data Sources (ODBC)

Then, adding your data source. If you have your data source driver installed, you should have it in the list of data source that appeared when you click Add.

That would register your data source on your machine and you'd be able to use it in applications.

That is quite generic infomartion applicable to any ODBC data source.

On the other hand, after quick looking at this manual, it seems to me that Hyperion is just a name of the application (not a database system) and it probably uses some kind of MS database engine... You shouldn't need in theory to log into the database at all - most what you might need is to log in to this application. If you have installed this application and don't have log in name and password, try contacting people that provided you with this software (or software manufacturer).

Good luck,
Yurich
0
 

Author Comment

by:ewang1205
ID: 18774292
I like to use a script to extract HFM data.  Right now, the HFM data is in Oracle and I am afraid that Oracle is raw data.  Maybe I need to use API call to extract the HFM data
0
 
LVL 21

Expert Comment

by:Yurich
ID: 18774498
I'm sorry, you lost me... How is it related to you not being able to log in into your Hyperion application?
0
 
LVL 21

Expert Comment

by:Yurich
ID: 18993436
I think sufficient help was provided.

Regards,
Yurich
0
 

Author Comment

by:ewang1205
ID: 18996021
Yurich:
Do you know how to extract using HFM API?  After some research, I am sure that is the way to go.  Thanks.
0
 
LVL 21

Expert Comment

by:Yurich
ID: 18998287
I don't know how to extract data using HFM API. Your initial question was about loggin into a database, and I gave you some pointers on how you could do this. If you read the manual (the one that you gave a link for), it describes how to extract data, but in the excel format. As it's in the excel format, I would suggest that the backcore of the database would be in one of the MS Jet formats used for excel and access.

Regards,
Yurich
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question