Skip to Content
0
Former Member
Nov 15, 2005 at 12:56 AM

Archiving influence -- Cube Design

20 Views

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