Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Live Analytical Reporting through OBIEE/BIP

Received Response
121
Views
9
Comments
User_92LR5
User_92LR5 Rank 3 - Community Apprentice
edited August 13 in Oracle Analytics Cloud and Server

How to do Live reporting from OBIEE(12c) or BIP(12c) where the data source is Oracle or Microsoft SQL Server DB?

Abid

Tagged:

Answers

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    If you have a specific question, then please be more precise.

    If you want to learn OBI here are the trainings: https://education.oracle.com/business-analytics/analytics-cloud/product_709

    If you want a consultant to do this for you, hire one.

    A forum isn't there to teach you basic concepts from the ground up.

  • User_92LR5
    User_92LR5 Rank 3 - Community Apprentice

    Hi Christian,

    I am not asking about the basic reports which are built on top of any data source but I am asking about the live/online reporting through OBIEE or BIP.(having no effect on the source system DB)

    How it can be done in BI enterprise ? It will be helpful if you can reply to my query.

    Abid

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3703061 wrote:I am not asking about the basic reports which are built on top of any data source but I am asking about the live/online reporting through OBIEE or BIP.

    What is the difference between a "basic report" and a "live/online report" for you?

    It sounds like you call "live/online report" something special, but there isn't a unique thing universally known with that name.

    Every analysis not being a PDF/Excel/<other format> file you receive by email is "live" (and let's not go into cache on this one to keep it simple).

    Any kind of report has an effect on the source DB, mainly because it must run a query at some point or your analysis is just static text (which is useless).

    Please define better what you are after, over explain it, so that we can better focus what your question is about.

  • User_92LR5
    User_92LR5 Rank 3 - Community Apprentice

    Hi Gianni,

    By live, I mean directly hitting the source DB instead of waiting for the ETL to load data into BI DWH.

    There is a specific requirement from the client where they want to see the status of a particular job on BI Dashboard which should refresh with the latest data as per source within 1 or 2 mins of time gap.They dont want the old or historical data from BI DWH instead they want live status as per source system.

    I hope I have made the requirement clear.

    Abid

  • Gianni Ceresa
    Gianni Ceresa Mod

    Both OBIEE 12c or BIP 12c can do that : the tool doesn't care what your source is.

    If you connect to a DWH loaded by ETL the tool will show you "old" data, if you connect to a live application DB the tool will show you what it founds at the time it executed the query (when you open the analysis/report or based on the caching your setup).

    So the answer to "How to do..." is simply: connect to the right database, the tool doesn't care and nothing change on that side.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru 
    3703061 wrote:By live, I mean directly hitting the source DB instead of waiting for the ETL to load data into BI DWH.

    So...basically what the analytics tool does anyways?

    The analysis engine doesn't care about ETL. Data laoding has noting to do with it. You can load a 20TB data vault and analyze it or just slap a csv somewhere and analyze it. Data is data. It's there. You read it. If it's there late becasue of an ETL then the issue is there and not in analytics.

  • User_92LR5
    User_92LR5 Rank 3 - Community Apprentice

    Hitting source DB always to get live data will not effect the source system or lock the tables?

    This is the only fear I have that creating BI report on top of direct source DB should not impact the source DB.

  • Gianni Ceresa
    Gianni Ceresa Mod

    A SELECT isn't supposed to lock anything.

    As a query is happening it will add an extra activity which wasn't there before. It's impossible to say that it will have no impact: it depends on what kind of queries you will execute and your DB itself etc.

    You have to try to see what happen based on your environment and needed analysis.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru 
    3703061 wrote:Hitting source DB always to get live data will not effect the source system or lock the tables?This is the only fear I have that creating BI report on top of direct source DB should not impact the source DB.

    In your place I'd be more worried about performance instead of locks. In 2 decades I have never ever seen a single lock issue. Queries read, don't write.

    Performance issues however? About 50 per badly designed system and badly written query.