is lost as a measure when processed across the bridge. This was
added back manually in Integration Server, specifying that the percentage be
rounded to one decimal place. Figure 10-22 and Figure10-23 show how this
measure is defined in both DB2 Cube Views and Integration Server.
Figure 10-22 The measure in DB2 Cube Views
Figure 10-23 The measure in Integration Server
The Optimization Advisor was run against the cube model specifying a query
type of
Extract
. The MQT script that was generated was then run to create the
MQT. As this MQT is for extract, it is a straightforward summary table with a
simple GROUP ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.