Need Help

[NavinReddy]

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

[sujeetsingh]

niranjan it should have all details regarding the keys and dependies

[NavinReddy]

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

[NavinReddy]

Hi Guys,

Any idea share with me

Regards

Niranjan

[#5]

Niranjan,

You need to use linktable logic..

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

It may help you

[NavinReddy]

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

[#7]

Niranjan,

Check below post..

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

More examples are available on community

Karthik

[NavinReddy]

Hi Karthiks,

Thanks a lot Karthiks

if you have any new secnarios LinkTable share with me

Regards

Niranjan

[hic]

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

[NavinReddy]

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