Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business scenarios and to improve performance
From the developerWorks archives
Date archived: January 10, 2017 | First published: September 10, 2009
Virtual cubes are one of the new Cubing Services features in IBM InfoSphere™ Warehouse 9.7. A virtual cube provides a way to merge different cubes together to allow a single query destination that returns merged results from the cubes that compose it. Virtual cubes can be used to drastically improve the response time of the cube server queries by using efficient data partitioning for optimum cache utilization (in some cases, over 100 times better response times). Virtual cubes also offer a solution for combining results by merging different regional cubes into a country cube. They also enable merging sales numbers with currency exchange rates to provide a global view of the business. This article explains how virtual cubes are created, how they work, and how to use them for InfoSphere Warehouse Cubing Services 9.7.
This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.