Measures Additive Over Some Dimensions

View previous topic View next topic Go down

Measures Additive Over Some Dimensions

Post  rossm on Wed Sep 05, 2012 2:39 pm

In the DWTk2Ed, figure 11.2 - Trip-level flight activity schema, two of the measures are Gross Segment Revenue and Segment Miles Flown. The grain of the table is part of a passenger itinerary. Clearly Miles refers to frequent flier miles, which would be additive, but what if I wanted to use them to determine the distance of a Trip, or the distance an Aircraft flies?

If I sum up the Revenue I get a reasonable answer for any dimension, but summing Miles will overstate how far the Aircraft has flown or the length of the complete Trip. If I first take the average or maximum Miles value for a given Origin-Departure Time combination, things should work. Are there techniques to handle this or are we really talking about a different grain - and different fact here?

rossm

Posts : 1
Join date : 2012-09-04

View user profile

Back to top Go down

Re: Measures Additive Over Some Dimensions

Post  ngalemmo on Wed Sep 05, 2012 6:55 pm

It's a semi-additive measure. A universal solution would be to store them in a different fact table with the appropriate grain so they are fully additive. Or you can rely on the functionality (or lack thereof) of your query tool and supply adequate training for the end users.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum