how to get marital status change date field in OTBI analysis

Question

RVohra · Answer

Please share which subject area you are using, if it is coming from Person Real time, then can you try:

"Person"."Marital Status Change Date" = TIMESTAMPADD(SQL_TSI_DAY, -1, CURRENT_DATE)

Nancy Pollard · Answer

I am creating a daily scheduled agent report in OTBI to bring in Marital status updates from the previous day, but am having trouble with the formula to use in the last updated column to bring in just Marital status changes.  I was able to create one for last updated address changes, but having trouble with marital status changes.   Anyone have any suggestions?

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/26126/how-to-get-marital-status-change-date-field-in-otbi-analysis

Hi @Anup Karmankar,

Welcome to the Oracle Analytics Community.

Can you please check the 'Person Legislative Information' folder under 'Workforce Management - Person Real Time' Subject Area? Here's a screenshot highlighted in Yellow.

Hope this help.

Thank you.