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

[hic · Accepted solution]

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

[NavinReddy]

Hi Henric,

it was nice explanation i am thank full toyou

But could you please explain me What is mixed granularity

Thanks & Regards

Niranjan

[hic]

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

[NavinReddy]

Hi Henric,

Thank you so much for your nice explanation

if you have any exampls plz send me

Thanks & Regards

rohith