Dimension Merge

Sat, 21 Mar 2015 15:07:18 GMT

Hi all,

i have 3 different fact table and 3 dimensions, one for each fact table, that contains same data type. How can i merge this 3 dimensions in one only dimension as calculated dimension?

Thanks a lot

Re: Dimension Merge

marcus_sommer — Sat, 21 Mar 2015 17:06:58 GMT

If the dimension-tables contain nearly the same they could be relative easy concatenated:

dimAll:

Load * From dim1;

concatenate

Load * From dim2;

concatenate

Load * From dim3;

But to handle 3 different fact-tables within a single datamodel isn't quite easy. Maybe these links are helpful:

Fact Table with Mixed Granularity

Data Modelling: Clarity vs. Speed

Concatenate vs Link Table

Merging Data from Multiple Sources

- Marcus

topic Re: Dimension Merge in QlikView

Dimension Merge

Re: Dimension Merge