Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Modeling Multiple Facts and Dimensions


I loaded my data into Qlikview and got the following table view.

The AWBs and the AWBsHistory tables are Facts and the rest are dimensions.

I had synthetic keys  and solved them by renaming the columns that caused them.

Is it ok for the fact table to have more than one relation? or should I use the Link table as the granularity and columns aren't the same in the 2 facts I have?

Appreciate your comments and input

2 Replies
Valued Contributor III

Re: Modeling Multiple Facts and Dimensions

Join PIMapping and AWB's History

Valued Contributor

Re: Modeling Multiple Facts and Dimensions

Each datamodel has it's specific needs. To enhance your knowledge I recommend to read a book from Kimball.