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

View previous topic View next topic Go down

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

Post  bw2000 on Tue Mar 31, 2015 9:47 am

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!

bw2000

Posts : 1
Join date : 2014-02-17

View user profile

Back to top Go down

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

Post  BoxesAndLines on Tue Mar 31, 2015 1:48 pm

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum