Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
vinay_bangari
Valued Contributor III

Re: Multiple Facts and Different Dimensions

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.

Community Browser