topic Same grain with some common dimensions in QlikView

Same grain with some common dimensions

markp201 — Thu, 27 Jul 2017 20:55:30 GMT

See below.

We concatenated two facts because they have a common primary key (%FactKey)

In order to concatenate do all the dimensions have to be common?

Do all measures have to be common between the fact tables?

We're only get rows for dimension2 but is there a way to dimension1 rows?

Re: Same grain with some common dimensions

effinty2112 — Thu, 27 Jul 2017 21:16:59 GMT

Hi Mark,

I know nothing about your data so take this with some healthy skepticism. Did your original fact tables share common values of %FactKey? Were the fact fields in one table different from the fact fields in the other? If the answer to both of these answers is yes then that would suggest the your new fact table should be created from a join of the original tables rather than concatenation.

Good luck

Andrew

Re: Same grain with some common dimensions

markp201 — Thu, 31 Aug 2017 00:52:43 GMT

Thanks for the reply but now the ba is asking for the other side of the coin. They're asking for measures from fact table 1 be appended to fact table 2 where the conforming dimension key matches. it doesn't seem like this is wise because any aggregation will be skewed. I'll try to add a visual later.