Hyperion Essbase Cube Access via ODBC through MS Access

[verd14]

I recently started working on a project that required me to interact with Hyperion Essbase and I was wondering if there was a way around the "top-to-bottom" retreival process that the Excel Essbase add-in function utilizes. I would prefer to create an ODBC and just connect to the tables on the server via MS Access. Is it possible? The servers are Linux based. I believe the Essbase version is 7 and my access version is 2003. As much details as possible would be appreciated.

Verd14

 

[EagleKeeper]

Much would depend if they provide an ODBC driver

 

[verd14]

Who's they? the server adminstrator? or the hyperion software?

Is there a simple way of knowing which driver you need?

 

[KLin]

Sounds like you need to go to oracle's website and do some research.

 

[EagleKeeper]

Originally posted by: verd14
Who's they? the server adminstrator? or the hyperion software?

Is there a simple way of knowing which driver you need?

The vendor would normally supply drivers to interface with the S/W.

Follow KLin suggestion above

 

[verd14]

Dang. I was worried about that. I will try and find something. Thanks for the help anyways. I'll post if successful.

 

[imported_Dhaval00]

Are you limited to using Excel? Have you looked at ADOMD.NET and XML/A?

 

[verd14]

Well I am not familiar with ADOMD.NET and XML/A, but I wanted to use access so I could work from the bottom up and build a relational model, rather than drill down from the essbase cubes.