How to preload schema into mondrian caches?
I have several schema files, such as FoodMart.xml and xxx.xml. Each schema contains a cube. Mondrian will automatically store the data into caches when cubes are first accessed.
How can I preload these schema into mondrian caches even before the first access of cubes? Can this be done by setting some attributes in the mondrian.properties file?
Thanks to all.
RE: How to preload schema into mondrian cache
The only way the cache is loaded is through executing MDX against the running system. If you need constant uptime, I have seen folks keep 2 instances of Mondrian running. After new data comes into the DB, 1 instance remains up for use. On the other instance, the cache is cleared, and MDX is run so that the cache is populated with the new data. Then the old instance is taken off line, and the re-cached one is put online.
Using aggregate tables is a short cut, too. Mondrian has to do less DBMS work to get results, compared to single fact tables.