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

fact table with multiple units of meassure

2 posters

Go down

fact table with multiple units of meassure Empty fact table with multiple units of meassure

Post  dim67 Wed Jun 06, 2012 4:56 pm

Hi,

I have to report on total usage in my fac table. the challenge is that the unit of measure can be expressed
in kwh,kw,kvarh etc. what would be the best way of modeling this?
Total Usage
Unit_Of meassure

or

Total Usage
KWH
KW
KVARh

as columns in the fact?

thanks,

dim67

Posts : 15
Join date : 2012-05-05

Back to top Go down

fact table with multiple units of meassure Empty Re: fact table with multiple units of meassure

Post  ngalemmo Wed Jun 06, 2012 5:22 pm

Is not KWH the consumption unit? KW is not a consumption unit, it is a measure of power at that moment. You really can't convert between them. If you are actually receiving multiple measures in different units, for example one would expect a KWH consumption value and a Peak KW value for the reading period, then these are not the same thing and it would make sense to store them as separate measures. Talk to people at your office, find a SME, they should be able to explain to you what the numbers represent. They are not equivalent measures.

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