Oracle Transactional Business Intelligence

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

Categories

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

create analysis from direct db query

141
Views
9
Comments
new.bi
new.bi Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Summary

how to created direct db query

Content

Hi 

Is there a way to create an analysis from direct database query. I tried the option but cannot get it to work. is there any additional set that is required for this? please advise.

direct db.png

Comments

  • Ramesh Nakka
    Ramesh Nakka Rank 4 - Community Specialist

    Hi,

    We can create the report in OBIEE by using advanced SQL..

    New - Analysis- Create Analysis from simple logical SQL

    OR

    You can click on Advanced tab and can create your own custom Query.

     

    Regards,

    Ramesh

     

    Ramesh

     

  • User_AEMC1
    User_AEMC1 Rank 2 - Community Beginner

    Please update the required setup for the above question.

  • Vijaya Kumar-70229
    Vijaya Kumar-70229 Rank 2 - Community Beginner

    Hi ,

    You can create direct db query by using Data model and create a report.

    New >> Data Model 

    Regards,

    Vijay S

  • Vijaya Kumar-70229
    Vijaya Kumar-70229 Rank 2 - Community Beginner

    Hi ,

    PFA , This is the way to create direct db query.

    Regards,

    Vijay S

    Capture1.JPG

  • Nick McHenry-Grobel
    Nick McHenry-Grobel Rank 1 - Community Starter

    Not sure of the setup required for permission but a big hurdle to overcome is understanding the delivered connection pool names in order to access the data. I am by no means an expert, but the following connection pool names work in my testing environment 

     

    CRM DATA: "CRM_OLTP"."CONNECTION POOL"

    HCM DATA: "HCM_OLTP"."CONNECTION POOL"

    FSCM DATA: "FSCM_OLTP"."CONNECTION POOL"

  • Ashish Shah-Oracle
    Ashish Shah-Oracle Rank 2 - Community Beginner

    Hi All,

     

    Please refer below idea before putting in efforts into this.

    https://cloudcustomerconnect.oracle.com/posts/51c4d1c58e

     

    Regards,

    Ashish

  • Jason McWatts-22341
    Jason McWatts-22341 Rank 1 - Community Starter

    Have just upvoted your idea. We are being told DDB queries are being deprecated at some point during the R13 cycle which is very disappointing news as we were looking to make a lot of use of this functionality.

    Jason

  • Nick McHenry-Grobel
    Nick McHenry-Grobel Rank 1 - Community Starter

    Can confirm. This functionality is already removed from all of my pods. Unfortunate. Have up voted your Idea as well.

  • Nick McHenry-Grobel
    Nick McHenry-Grobel Rank 1 - Community Starter

    Can confirm. This functionality is already removed from all of my pods. Unfortunate. Have up voted your Idea as well.