Hello,
I'm looking at using the new scripting functionality for doing post Fusion SaaS ETL transforms. Essentially I want to add a subject area with type 2 SDC some attributes for AR and AP transactions, i.e. the ability to look at invoices as if they were at a point in time (at least at a day level granularity).
The question which I am looking at is, if I use scripting to generate the new tables from the existing AR/AP data sets, does this automatically schedule based on a dependency to only run after ETL the main incremental/can I control the timing/is it always a fixed time,e.g. start of normal schedule/is it just in the hands of scheduler randomness?
The aim is that we want to do KPIs across all business units but being able to stay "KPI as of this period end" then be able to do month on month knowing things like invoice hold status, collections information is the values baked at that point in time for all users.
