
Chapter 10. Accessing DB2 dimensional data using Integration Server Bridge 437
In the cube model there is a calculated measure called
Profit
. It is defined in DB2
Cube Views as in Example 10-1.
Example 10-1 Profit: calculated measure
@Column(STAR.CONSUMER_SALES.TRXN_SALE_AMT) -
@Column(STAR.CONSUMER_SALES.TRXN_COST_AMT)
When this is mapped across to Integration Server, the measure is created in the
Integration Server model in the
Accounts
dimension with a transformation rule,
as is shown in Figure 10-13.
Figure 10-13 Integration Server column properties
For other measures, the Integration Server bridge will attempt to build a measure
hierarchy in ...