Hi All,
I am creating a cube with two category count measures based on ordid and itemid. Data source is a single .iqd file:
#Orders
#Items
Here are two sample reports:
Measure Selected : #Items
TYPE1 TYPE2 ITEM_TYPE
2000 4 4 8
2001 2 3 5
************************************
If Measure Selected : # Orders
TYPE1 TYPE2 ITEM_TYPE
2000 3 2 3
2001 4 6 7
The report is correct because there might be multiple TYPE1 items ordered on a single ORDER. Although it looks confusing as the summary column is not the exact sum.
The same thing happens if the cross-tab is shown between any dimension specific to details but the measure selected is #Orders.
Is it possible to make #Orders measure UNAVAILABLE for whole ITEM_TYPE dimension. Client is not interested in two separate cubes.
Regards
I am creating a cube with two category count measures based on ordid and itemid. Data source is a single .iqd file:
#Orders
#Items
Here are two sample reports:
Measure Selected : #Items
TYPE1 TYPE2 ITEM_TYPE
2000 4 4 8
2001 2 3 5
************************************
If Measure Selected : # Orders
TYPE1 TYPE2 ITEM_TYPE
2000 3 2 3
2001 4 6 7
The report is correct because there might be multiple TYPE1 items ordered on a single ORDER. Although it looks confusing as the summary column is not the exact sum.
The same thing happens if the cross-tab is shown between any dimension specific to details but the measure selected is #Orders.
Is it possible to make #Orders measure UNAVAILABLE for whole ITEM_TYPE dimension. Client is not interested in two separate cubes.
Regards