Blog

Relational Connection

STEP1: In Work Flow Select CONNECTIONS > RELATIONAL.   Relational Connection STEP 2: Click on : New… SELECT SUBTYPE : ORACLE STEP3: Create a SOURCE Connection. Provide a name to the source connection i.e., OLAP_INFRA Enter USER NAME i.e., INFRATRAIN(schema name) Enter CONNECT STRING : used database name Enter PASSWORD (schema password) Select CODE PAGE 

Read More

HR Analytics Domain Values SQL for BI Apps 7.9.6.4

domainValues_AbsenceEvent_Status_oraVersion.csv ============================================================= SELECT DISTINCT APPROVAL_STATUS FROM PER_ABSENCE_ATTENDANCES   No Data Returned   domainValues_Employment_Cat_oraVersion.csv ============================================================= SELECT DISTINCT SYSTEM_PERSON_TYPE, USER_PERSON_TYPE FROM PER_PERSON_TYPES WHERE SYSTEM_PERSON_TYPE IN (‘EMP’,’CWK’,’OTHER’,’EMP_APL’,’EX_EMP’,’EX_EMP_ APL’,’RETIREE’,’PRTN’) ORDER BY 1,2   No Data Returned   domainValues_Employee_Ethnic_Group_Code_oraVersion.csv ============================================================ SELECT DISTINCT PER_INFORMATION1 FROM PER_ALL_PEOPLE_F WHERE PER_INFORMATION1 in (‘1′,’2′,’3′,’4′,’5′,’6′,’7′,’8′,’9′,’10’,’11’,’12’,’13’,’BA’,’BC’,’BO’,’C’,’I’ ,’O’,’P’,’W’) ORDER BY 1   domainValues_Employment_Full_Time_Flg_oraVersion.csv ============================================================ SELECT DISTINCT EMPLOYMENT_CATEGORY FROM

Read More