How to freeze result of query (Query is based on multiprovider) and update to a new cube?
so that we can see results of particular time span during the year.