I was just wondering if there was anyway to choose the order in which tables are built.
I am currently looking to hold 7 days worth of daily backups for some data. Using the append I have not found a way to delete the old data on the 8th day so the backups become huge, containing redundant data.
I thought of having 7 tables which draw from the source table but ultimately copy from the last table during the daily build for example
7 <- 6 <- 5 <- 4 <- 3 <- 2 <- 1 <- Source
Step 1 2 3 4 5 6 7
These would then feed together and be grouped.
Currently it builds in the opposite order I want.
The only other way I can think of doing this is having separate cubes from each table and then schedule the build to be staggered so 7 copies 6 at 10:00 and then 6 copies 5 at 10:05, etc.
Has anyone had any success in this area,
Please sign in to leave a comment.