Oracle Transactional Business Intelligence
create analysis from direct db query
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.
Comments
-
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
-
Please update the required setup for the above question.
-
Hi ,
You can create direct db query by using Data model and create a report.
New >> Data Model
Regards,
Vijay S
-
Hi ,
PFA , This is the way to create direct db query.
Regards,
Vijay S
-
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"
-
Hi All,
Please refer below idea before putting in efforts into this.
https://cloudcustomerconnect.oracle.com/posts/51c4d1c58e
Regards,
Ashish
-
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
-
Can confirm. This functionality is already removed from all of my pods. Unfortunate. Have up voted your Idea as well.
-
Can confirm. This functionality is already removed from all of my pods. Unfortunate. Have up voted your Idea as well.