Oracle Transactional Business Intelligence

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

How to access PVO Queries?

Received Response
56
Views
1
Comments

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

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    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 …