This topic has been locked.
2 replies Latest Post - 2011-06-24T00:23:13Z by vmcburney
Pinned topic What is the best way to load a Cubing Services data cache?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
We have an overnight batch loaded Data Warehouse. We use MQTs and Cubing Services to provide OLAP to Cognos. Our problem is that first thing in the morning it is taking up to a minute for the first Cognos report to run as the Cubing Services data cache is reloaded. Is there an easier way to make sure the Cubing Services Cache is pre-loaded at the start of each day before reporting users start to use it? We are looking at under 10 second response times normally for Cubing Services reports so the one minute wait is painful.
Updated on 2011-06-24T00:23:13Z at 2011-06-24T00:23:13Z by vmcburney
warrenpettit 12000090CV8 Posts
vmcburney 110000MJQJ7 PostsACCEPTED ANSWER
Re: What is the best way to load a Cubing Services data cache?2011-06-24T00:23:13Z in response to warrenpettitAnd what should I use for a seed query? Is any query against the cube going to reload the entire data cache or does it need to retrieve data from all of the dimensions in the cube?