How to access PVO Queries?

Question

Is there documentation or some way to access the database queries behind PVOs used in BICC?

For example, how can I see the queries behind these PVOs?

HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO

HcmTopModelAnalyticsGlobalAM.AssignmentAM.AssignmentPVO

Nathan CCC · Answer

Hi,

Yes you can query the view object the view log to see the physical sql(s) on the application database tables and views.

To do this ask you bi administrator to use page manage privileges to grant your user or a role you have or inherit privileges issue sql directly and manage sessions.

Now go to page issue sql /analytics/saw.dll?issuerawsql

query the vo

select View Log to go to page manage sessions. Read the sql.

For example

select all t.* from EXTERNAL('ADF','"oracle.apps.hcm.model.analytics.applicationModule.HcmTopModelAnalyticsGlobalAM_HcmTopModelGlobalAMLocal"."Connection Pool"').'HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO' t fetch first 7 rows only

as you can see from the physical SQL in the log this is the data source for this particular VO

select … FROM PER_USERS V507356280, PER_USER_HISTORY UserHistoryPEO WHERE …