Categories
How to access PVO Queries?

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
Answers
-
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 …
0