OTBI Report- Annualized Salary values not populating from the Compensation -Salary Details Real Time
we have an OTBI Report that utilizes two subject areas. It includes some absence related columns such as Periodic Accrual, Processed absences etc.. from Workforce Management - Accrual Real Time, along with annualized salary column from Compensation - Salary Details Real Time. Our requirement is to retrieve only absence amounts for transactions within a specific time period. To achieve this, we applied a filter on the "Time.Date" column to restrict the data between Jan 1,2025 and Dec 31,2025. However, this causes Annualized Salary column to appear blank unless there is a salary transaction happened within the filtered period. our goal