1 Reply Latest reply: Sep 24, 2012 3:47 PM by Vinay Bangari RSS

    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?

        • Re: Multiple Facts and Different Dimensions
          Vinay Bangari

          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.