For more information, please refer to this announcement explaining best practices for getting answers to questions.
Using two HCM/Compensation subject areas to pull needed data using OTBI, Now want to pull data from
Content
I am using two HCM/Compensation subject areas to pull needed data using OTBI, Now want to pull data from Incentive Compensation database table CN_TP_TRANSACTIONS_ALL based on person_number from HCM = Attribute10 in CN_TP_TRANSACTIONS_ALL that we store person_number. Can this be done using OTBI? Any thoughts...
Sql Issued using two subject areas:
SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1,NO_FORCE_TO_DETAIL_BIN=1;SELECT
0 s_0,
"Compensation - Salary Details Real Time"."Salary Basis"."Salary Basis Name" s_1,
"Compensation - Salary Details Real Time"."Salary Details"."Salary change date" s_2,