Importing From Essbase

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

My client carries summary general ledger information in Essbase (I don't
know much about Essbase). Excel can import Essbase data directly into a
spreadsheet. Can Essbase data be brought directly into Access or an Access
table as well?

Thank you

Ross
 
Ross,
Essbase is not on the list of files that Access can directly import from.
Unless you can set up ODBC to the data files for Essbase, you will need to
import the data using excel as an intermediary.
Like you, I haven't come across Essbase before - we don't even know if it is
a database or a spreadsheet or something else.

Jeanette Cunningham
 
Many Thanks,

Sound like ODBC is my only hope.



Jeanette Cunningham said:
Ross,
Essbase is not on the list of files that Access can directly import from.
Unless you can set up ODBC to the data files for Essbase, you will need to
import the data using excel as an intermediary.
Like you, I haven't come across Essbase before - we don't even know if it is
a database or a spreadsheet or something else.

Jeanette Cunningham
Click to expand...
 
Essbase is a hyarchical data model. Much like databases were 30+ years ago
before relational models really began to take hold.

IMHO, it is pretty useless. It does nothing more than import relational
data and transforms it into a hyarchical model for importing into Excel.

I would suggest using Excel and an intermediary because you are going to
have to restructure the data into a relational model for Access anyway.
 
Thank you Klatuu,



Klatuu said:
Essbase is a hyarchical data model. Much like databases were 30+ years ago
before relational models really began to take hold.

IMHO, it is pretty useless. It does nothing more than import relational
data and transforms it into a hyarchical model for importing into Excel.

I would suggest using Excel and an intermediary because you are going to
have to restructure the data into a relational model for Access anyway.
Click to expand...
 
Hi Ross,

Essbase is an OLAP hierarchical / multi-dimensional database by Hyperion -
which was acquired by Oracle this past year. .

It was intended as a logical extension to the worksheet object, providing a
3rd or nth additional dimension. The cube storage when combined with XML
documents seems to be gaining marketshare, particularly in the Fortune 500
type large enterprise marketplace. OLAP is a newer approach than traditional
RDBMS, the principal advantage is storage efficiency for complex data
structures and faster query times against very large and complex data
recordsets.

Essbase may offer XML data export - if it doesn't now, it certainly will in
the future. Essbase offers an Excel Add-In that offers tight integration of
the two products. You might find that you can use Office automation and the
Excel application object to snag whatever data you wish from Essbase.

Hope this helps,
Gordon
 
Back
Top