Need Input to fetch info on salary changes for an employee

Question

We have to prepare one report to showcase employee details along with his/her salary modification info like "when salary got updated is that insert /updated " so we are using the logic as

when "Salary Details"."Salary Last Update Date" = "Salary Details"."Salary Creation Date" then 'New' ELSE 'Updated' END

can we add something more granular logic into it to get further insides for the same !!

JohnW-Oracle · Accepted Answer

Hi @User_FVGJ0 ,

It depends on your Data Source and what type of granularity you want, but you can augment/customize the data warehouse with additional tables/attributes from the source. If a query in the data source returns the detail you want, you could customize the warehouse to bring that in.

The Customization guidelines are here:

https://docs.oracle.com/en/applications/business-intelligence-applications/103/etl-guide/customizing-oracle-business-analytics-warehouse.html#GUID-C9E7D7FD-3C17-4247-962B-56DD9E8A2B6B

If you find this reply to your question useful, others might as well. By clicking the “Yes” button for “Did this answer the question?” below, you’ll be able to help the community members who might have a similar concern find the answer easier.

Regards,

John