Need Input to fetch info on salary changes for an employee

User_FVGJ0

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

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

SteveF-Oracle

@User_FVGJ0

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!