topic Re: Need Help on FactTables in QlikView

Need Help

NavinReddy — Thu, 04 Jul 2013 09:52:30 GMT

Hi Guys,

I have 6 Facts tables Each fact table having 10 Dimensions

Could some one help me how to develope DataModel

Thanks in Advance

Niranjan

Re: Need Help on FactTables

sujeetsingh — Thu, 04 Jul 2013 09:56:35 GMT

niranjan it should have all details regarding the keys and dependies

Re: Need Help on FactTables

NavinReddy — Thu, 04 Jul 2013 10:02:19 GMT

Hi,

They are Lots of common keys in Fact Vs Dimention

Facts are(Template ,Sales,Profit,Product)

Dimension (common for same as Facts )

Regards

Niranjan

Re: Need Help on FactTables

NavinReddy — Thu, 04 Jul 2013 10:39:07 GMT

Hi Guys,

Any idea share with me

Regards

Niranjan

Re: Need Help on FactTables

Thu, 04 Jul 2013 10:43:33 GMT

Niranjan,

You need to use linktable logic..

here i attached linktable sample which we created for some one on community..

It may help you

Re: Need Help on FactTables

NavinReddy — Thu, 04 Jul 2013 10:48:59 GMT

Hi Karthiks,

I Need to be submit Paper Document if you have any Word Documents or Powerpoint

Send to me its helpfull

Thanks & Regards

Niranjan

Re: Need Help on FactTables

Thu, 04 Jul 2013 11:02:09 GMT

Niranjan,

Check below post..

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

More examples are available on community

Karthik

Re: Need Help on FactTables

NavinReddy — Thu, 04 Jul 2013 11:16:14 GMT

Hi Karthiks,

Thanks a lot Karthiks

if you have any new secnarios LinkTable share with me

Regards

Niranjan

Re: Need Help on FactTables

hic — Thu, 04 Jul 2013 13:27:57 GMT

A link table works, but I would probably avoid that since it is slower than the alternative.

Instead I would concatenate all fact tables into one and have them share the dimension keys. If you have a mixed granularity (e.g. one fact table with product groups and another with products) I would use generic keys to fix it.

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

HIC

Re: Need Help on FactTables

NavinReddy — Fri, 05 Jul 2013 01:44:40 GMT

Hi Henric,

Thanks for your reply

I know about link table, i am not much aware of mixed granularity,don't know exactly when we are useing generic keys,and how to use generic keys

Could please explain me

Thanks a lot

Niranjan

Re: Need Help on FactTables

hic — Fri, 05 Jul 2013 05:59:53 GMT

It is not sure that you need generic keys.

Just concatenate the different fact tables, making sure that as many fields as possible are named consistently. If you then encounter a problem where the same key is used slightly differently in two fact tables, you may need generic keys. Then, see more in http://community.qlik.com/docs/DOC-3451

HIC

Re: Need Help on FactTables

NavinReddy — Fri, 05 Jul 2013 07:01:43 GMT

Hi Henric,

it was nice explanation i am thank full toyou

But could you please explain me What is mixed granularity

Thanks & Regards

Niranjan

Re: Need Help on FactTables

hic — Fri, 05 Jul 2013 08:05:10 GMT

Mixed granularity is simply if two fact tables have dimensional keys on different levels. The best example is if you have actual numbers compared to budget: The actual numbers use Date as calendar key and ProductID as product key. But the budget uses Month as calendar key and ProductGroupID as product key.

HIC

Re: Need Help on FactTables

NavinReddy — Fri, 05 Jul 2013 08:31:46 GMT

Hi Henric,

Thank you so much for your nice explanation

if you have any exampls plz send me

Thanks & Regards

rohith