Forum Discussion
DJBrennan
5 years agoFrequent Visitor
Failing to make a relationship work
Good morning, I have a Fact table – Electricity Consumption - and a dimension table – Greenhouse Gas Emissions Conversion Factors by year. For a given year (or any month within it), I want to multip...
DJBrennan
5 years agoFrequent Visitor
Hi,
Sorry that I wasn't clear enough but, as a result (all my fault) your solution is also not clear.
Here is my model view.
DJBrennan
5 years agoFrequent Visitor
Sorry, I pressed enter too soon.... The emission factor in Emissions Factors is column Value and the consumption (confusingly and I will change this) in HHData is also "Value"