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
vmcburney 110000MJQJ7 Posts
Re: What is the best way to load a Cubing Services data cache?2011-06-24T00:23:13ZThis is the accepted answer. This is the accepted answer.
- warrenpettit 12000090CV