Oracle Transactional Business Intelligence

VO for ASE tables
Content
Hi,
are there VO for ASE tables like ASE_USER_LOGIN_INFO to extract data other then using BIP
I would like to do scheduled extract to load into ADW for reporting
what are the options
please suggest
Comments
-
Hi,
for each cloud you can read the manual to track if a view object is used by the metadata repository database (RPD)
for financials clound
https://docs.oracle.com/en/cloud/saas/financials/20a/analyze-and-report.htmlreview data lineage
https://cloudcustomerconnect.oracle.com/files/caf0decefa/R13_19D_Financials_OTBI_database_mapping_with_ViewObjects.xlsx -
Hi Mawahid,
Currently, there is no VO for ASE tables. You can use below query to extract data via BI Publisher:
SELECT
per_details.GUID,
per_details.LAST_LOGIN_DATE LAST_LOGIN_DATE,
per_details.DAYS_SINCE_LAST_LOGIN,
per_details.USERNAME,
per_details.PERSON_ID,
per_details.SUSPENDED,
per_details.active_flag
from (SELECT distinct aul.USER_GUID GUID,
aul.LAST_LOGIN_DATE LAST_LOGIN_DATE,
trunc(SYSDATE)-trunc(LAST_LOGIN_DATE) AS DAYS_SINCE_LAST_LOGIN,
UserPEO.USERNAME,
UserPEO.PERSON_ID,
UserPEO.ACTIVE_FLAG,
UserPEO.SUSPENDED
FROM
ASE_USER_LOGIN_INFO aul,
PER_USERS UserPEO
WHERE
aul.USER_GUID = UserPEO.USER_GUID(+)
) per_details
ORDER BY DAYS_SINCE_LAST_LOGIN descIf you require to have this data mapped to a VO or to a Subject Area then please raise an Idea on the BI page:
https://cloudcustomerconnect.oracle.com/resources/b2df648d2a/summary
Best regards,
Robert