Can you combine an accumulating and periodic snapshot into a single accumulating periodic snapshot table?!

Hi,

Similar (luckily!) to the accumulating snapshot example in the TDWToolkit 2nd ed book on p.245, I have a requirement for tracking a student admissions pipeline, however my accumulating snapshot would be at a lower grain than the example as each prospective student can apply for multiple courses (although as part of the pipeline they will only ever enrol on a single course) and can apply for the next or future enrolment years.

As well as slicing by dimensions joined to the accumulating snapshot table, business needs also require some time based analysis.  e.g:
1. see trends over time of accumulating snapshot facts.  e.g. "Admitted Quantity" by day for a given enrolment year.
2. year on year comparisons for any particular day.  e.g. how does our pipeline today for the next enrolment year compare to the equivalent day for previous years.

The only way I can think of doing this is by creating an accumulating snapshot and then taking a daily snapshot of it.  This then turns it into a accumulating periodic snapshot?!  Is there another (or correct) approach I should be following?


Thanks!

Accumulating snapshots are nearly always sourced from an accompanying transaction fact table. I would think your transaction fact, or an aggregation of that fact would provide your answers.