topic Re: Sense - Multiple Fact tables... in App Development

Sense - Multiple Fact tables...

ijcornish — Wed, 20 Dec 2017 22:46:37 GMT

I've read a number of excellent articles on this site about this but am still confused... I'm working on a QlikSense project for Sales/order/budget analysis.

I have 2 Dimensions - Time (with Month & day dimensions) and also Product & Product Group (I can easily flatten these 2 into 1 dimension).

I have 4 Facts- 1) Invoiced Sales (Day level) (at Customer, Country, Product and Currency)

2) Open Orders (Day level) (ie not in the Invoiced Sales fact) (at Customer, Country, and Product)

3) Budget (Month level)(at Country, Product and Currency)

4) Forecast (Month level) (at Country, Product Group and Currency)

So, I need to create a Master table of Time (Day & Month), Product, Customer, Country, Currency with three different generated keys (for each Fact). HOW?!?!?!

My first thought was to Load the Time Dimension and Product dimension as a cartesian product from SQL (limited to current year/product). However, this sounds like "Kill the server" territory

I've looked at Mapping and ApplyMaps, but am confused by them... Can someone clarify and provide a best direction forwards?

Re: Sense - Multiple Fact tables...

luismadriz — Wed, 20 Dec 2017 23:16:22 GMT

Hi Ian,

Please see the link below on LinkTables

I hope it helps,

Link Table in QlikView – Learn QlikView

Cheers,

Luis

Re: Sense - Multiple Fact tables...

luismadriz — Wed, 20 Dec 2017 23:19:25 GMT

I've also used this one from Fabrice Aunez

I hope it helps

Cheers,

Luis

Re: Sense - Multiple Fact tables...

ijcornish — Thu, 21 Dec 2017 09:09:15 GMT

Perfect... Just what I needed!

Re: Sense - Multiple Fact tables...

Shubham_D — Thu, 08 Apr 2021 15:54:59 GMT

So can we say that link table architecture is a Star Schema ?