Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Facts and Different Dimensions

QlikView Version 10 x64 Edition.

We are migrating SSRS to QlikView.

Our SSRS Report consists of data from Multiple Facts and different dimensions having different granularity. How do I make this work in QlikView?

1 Reply
Anonymous
Not applicable
Author

In Qlikview while doing the data model we should try to get the star schema so that the performance of the application is more. So if you have mulitple fact tables then try to make that as a single table either by joining or concatinating. And for dimensions based on the requirement join those dimensions individually to the fact table. hope this helps . If you have any problem while doing the data model try to post us a sample application so that we can help you with that.