asked on

how to access Hyperion database and retrieve the data?

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!!!

Yurich

it doesn't say anything in the manual?

Yurich

usually, you would create an odbc data source, provide all credentials, then you would use it from your application

ewang1205

ASKER

Yurich:

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

Thanks.

ASKER CERTIFIED SOLUTION

Yurich

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ewang1205

ASKER

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

Yurich

I'm sorry, you lost me... How is it related to you not being able to log in into your Hyperion application?

Yurich

I think sufficient help was provided.

Regards,
Yurich

ewang1205

ASKER

Yurich:
Do you know how to extract using HFM API? After some research, I am sure that is the way to go. Thanks.

Yurich

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