Hello Experts,
What effect does the archiving strategy have the effect on the ODS / Cube / Report design.
1) We are contemplating on the issue of having the calculations done in the front end vs in the cube and its effect on archiving.
2) Snapshot data vs non-cumulative data
Wondering anyone could please explain the effect of archving strategy on the above items. We are planning to archive data older than 5 years going forward.
Thanks,
BWer