Data model design

[#1]

Hi

In the attached data model I have two fact tables - PLCFacts and SLRFacts, and a dimension DIMFinancialPeriod.

I have split the fact tables as they are unrelated but both fact tables will use other common dimensions, like DIMFinancialPeriod. 

Is this valid design or can you recommend a better solution?

Thanks

[tresesco]

Better solution and a learning, download the pdf from: Re: Multiple fact tables

[fkeuroglian]

Hi, read this

good luck

Fernando

http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity

http://www.quickqlearqool.nl/?p=910

[maxgro]

if you have mixed dimensions granularity you can read here

Generic keys

or here

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity

regarding fact tables (concatenate vs link) read tresesco link or

http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/17/concatenate-vs-link-table

[#5]

thanks for the info and help. 

Based on the design i have shown what is the option i should be going for - is it concatenate or link table? 

[fkeuroglian]

Hi, not always you have to use one or other solution, it depens of the case and depends of the realitiy you want to show in the document.

it depends on the case, you will have to use concatenation or link table

THERE IS NOT A FORMULA OR CONDITION THAT YOU HAVE TO USE ONE OR OTHER

good luck

Fernando