create analysis from direct db query

new.bi

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.

Ramesh Nakka

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

Please update the required setup for the above question.

Vijaya Kumar-70229

Hi ,

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

New >> Data Model 

Regards,

Vijay S

Vijaya Kumar-70229

Hi ,

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

Regards,

Vijay S

Nick McHenry-Grobel

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

Hi All,

 

Please refer below idea before putting in efforts into this.

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

 

Regards,

Ashish

Jason McWatts-22341

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

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

Nick McHenry-Grobel

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