Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Measures Additive Over Some Dimensions

2 posters

Go down

Measures Additive Over Some Dimensions Empty Measures Additive Over Some Dimensions

Post  rossm 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

Back to top Go down

Measures Additive Over Some Dimensions Empty Re: Measures Additive Over Some Dimensions

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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