IBM Cognos Dynamic Cubes

Chapter 6. Virtual cubes 141

6.3.3 Multiple fact tables

With virtual cubes, you can build a cube that will share dimensions between cubes, and build

reports that use facts from multiple cubes. One example is to have a virtual cube that includes

a cube with actual values and a cube with target or budget values.

Into the virtual cube You can build calculated measures that reference measures from both

source cubes. One example is a measure that calculates the variance from plan by

subtracting the budget or the target plan values from the actual values. If the remainder is a

positive number, then the variance exceeded the budget or target plan. Another example is a

measure that takes that variance and compares it to the budget of the target plan ...