Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business scenarios and to improve performance

From the developerWorks archives

Adrian Mitrea

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.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management, Big data and analytics
ArticleID=427186
ArticleTitle=Using virtual cubes in IBM InfoSphere Warehouse 9.7 to combine business scenarios and to improve performance
publish-date=09102009