This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Three ways to do this

January 6 2011 at 7:36 AM
No score for this post
Cameron Lackpour 
from IP address 98.111.148.105


Response to SQL Connecting Directly into Essbase

The most simple is SQL load rules:
http://download.oracle.com/docs/cd/E17236_01/epm.1112/esb_sql_interface/launch.html

The old fashioned way is EIS:
http://download.oracle.com/docs/cd/E17236_01/epm.1112/eis_dataprep/launch.html
http://download.oracle.com/docs/cd/E17236_01/epm.1112/eis_sysadmin/launch.html

The modern way:
http://download.oracle.com/docs/cd/E17236_01/epm.1112/est_user/launch.html

These links and more are available on:
http://download.oracle.com/docs/cd/E17236_01/nav/portal_3.htm

SQL load rules are just like regular load rules except the data source is a table, not a file. And oh yes, you can do SQL manipulation via the SELECT statement, although that isn't a great place to do it.

EIS and Studio make sense in the context of a true data warehouse with a nice star schema all ready to go (or something pretty darn close).

It has been my experience that many data warehouses are "We dump all of our completely unrelated tables used for querying into schema/database X. Henceforth, schema/database X is our Data Warehouse." If that's the case, you (or someone) are going to spend a lot of time writing SQL trying to get the tables into a format that is ready for EIS/Studio. Actually, no matter what tool you use, a lot of time is likely to be spent writing SQL to get meaningful data/metadata out.

Once upon a time, Hyperion charged dearly for the SQL interface and its use was limited. Since Oracle took over, it's been included in the base Essbase license and I see it everywhere.

I'm not 100% sure of this, but I *believe* Studio/EIS are also now part of the standard install.

Regards,

Cameron Lackpour

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. SQL and Essbase - Jacques on Jan 6, 2011, 7:50 AM
    1. Re: SQL and Essbase - Javier on Jan 6, 2011, 8:06 AM
      1. Re: SQL and Essbase - Bob on Jan 6, 2011, 8:22 AM
        1. I so compeltely missed that - Cameron Lackpour on Jan 6, 2011, 9:20 AM
          1. And also so missed JExport - Cameron Lackpour on Jan 6, 2011, 9:23 AM
    2. Re: SQL and Essbase - sandeep kumar upadhyay on Jan 10, 2011, 3:16 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.