Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Transferring EBS Data Elements into OBIEE

Received Response
22
Views
6
Comments
Oluseyi
Oluseyi Rank 1 - Community Starter
in Oracle Business Intelligence Applications

My company wants to use OBIEE to derive a few reports straight from there EBS OLTP system. I know that OBIEE is meant to be used with DW and Star Schemas, however I have to deliver what they are asking for.

DAYLY BUSINESS INTELLIGENCE, based IN ORACLE EBS;

is there a pre-build models that i could get information directly from ORACEL EBS.

Any help would be appreciated.

Answers

  • AH R
    AH R Rank 2 - Community Beginner

    There is no predefined model but as you can create connection with Oracle EBS database. Go and import EBS tables in physical layer of RPD and you need to create your model according to your requirement.

  • Gianni Ceresa
    Gianni Ceresa Mod

    As extension to AH R answer, there is actually a model but it's a different solution: OBIA (Oracle BI Applications).

    It comes with ETL and its own database warehouse model where your EBS data will be loaded by ETL and then the prebuilt RPD and analysis are based on that. Definitely not what you look for if it's just for "few reports".

    So everything you can do by hand in SQL on your EBS base can be done in OBIEE too by modelling.

    The only Oracle prebuilt model/analysis is OBIA.

  • John_K
    John_K Rank 5 - Community Champion

    BI Apps is no good for real time reporting (in the absence of GoldenGate - $$$$$). In terms of direct reporting, yes OBIEE is aimed at Star Schema design, however you can report directly off EBS by creating a connection pool to point at that instance and creating your model using direct tables. A better way would probably be to create either views or materialized views on the EBS side that ratify the data a bit. You won't get the benefit of star schemas in the same way as a warehouse environment because you won't be using bitmap indexes and star transformation, however you can get some reasonable results.

    The thing to be aware of is that you'll need to disable OBIEE caching.

    Finally, although Oracle touts OBIEE as the replacement for Discoverer, it absolutely isn't. It's built to generate analytical reports, not transactional reports. So you're kind of using the wrong tool for the job if that's your aim.

  • Gianni Ceresa
    Gianni Ceresa Mod

    The word "real time" not being mentioned but talking about "daily BI" OBIA is still a perfect match, but as said not worth the cost and work for just "few reports".

    OBIEE isn't aimed at star schema design, it is for any kind of data structure you have. Star schema sources are actually boring in OBIEE because there is nothing to do. With 3NF or datavault sources or just any kind of source it's more interesting as you can actually model things as you need them, and not as somebody decided one day to build the DWH.

    Disabling cache in OBIEE? The question is more why cache would be ON, there is no need of cache in most of the system with a correct model.

    Last but not least: if all is needed is a bunch of SQL query and output the results then Publisher will perfectly do the job: a JDBC connection to the EBS schema, enter the query, design the output and done.

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Also adding, may be BI publisher is worth taking a look.

  • John_K
    John_K Rank 5 - Community Champion

    I'd assumed the OP was already using BI Apps given that they have posted in the BI Apps forum.

    Why wouldn't you have caching on? So long as you manage it correctly between ETL's. If you have a query run 100 times in a day, why go to the database 100 times, when you can go once?