Analytics Software

Hi All
My customer currently has a custom built warehouse and is using obiee as the reporting tool.

I am busy implementing 7.9.6.2 apps for them from their EBS 12.1.1 instance.

They have a burning issue which is that in their source system, the users do not always capture the fields required for their compliance reports, so their headcounts are not correct, then the users correct the data and the BI headcounts historically are not correct.

I have suggested that this problem must be dealt with in the source system, but they want to find out if the pre built apps will offer any relief.

The question is how does the BAW change capture work surrounding this scenario?

I have said that from what I have experienced the change capture works with the refresh dates in the DAC and that any changes will be picked up by the last updated date and an update will be effected to change the data.

This is unless there is SCD type logic built in where the snapshots will reflect the history as it was and perhaps only the aggregates will be effected.

I have been checking the employee headcount in the rpd and following the process back to the SDE_ORA_PersistedStage_WorkforceEvent_HeadCount_Full where the data is extracted from the source and there is a lot of headcount logic built in but I cannot work out for sure how the net changes will be handled.

Is there anyone who has had experience with HR Head count snapshots and aggregations being affected by back dated source system changes?
Regards
Nick