I'll comment the situation on my client. Nowadays we have a Snapshot Cube for Stock. It takes a daily snapshot every night with all the movements from the beginning of times until the current day. Now we have a huge amount of data and it started to be antiperforming. We also have a what we calle Online Snapshot Cube, which loads hourly. The second one used to last 10 minutes to load, but now it's taking more than 30. In a near future it will last more than an hour and it will overlap therefore collapse.
At present time, the cube takes the snapshot from the beginning of times like I said. The idea is to make it take the snapshot from the snapshot of the day before, and add the new movements on it, instead of loading all the history every time.
Could anyone give me an idea of how to model/achieve this?
Any suggestion will be appreciated.
Thank you very much in advance.