4 Replies Latest reply: Nov 16, 2016 1:32 PM by Tomasz Ziembicki RSS

    I would like to connect two fact tables with dimension on different level of granularity

    Tomasz Ziembicki

      hello,

      I saw similar case that was disscused  by Qlick Community but in my view there is some  specyfic elements which treat that case as something different.

       

       

      My problem is related to lack of knowledge how I should connect fact table named  History Data,  where the lowest level of graduality is 1 atm, settlement date, currency with another fact table named Cash Usage,  where the lowest level of graduality is country, settlement date, currency. I would like to drill down data using hierarchies which I created in Dimension named ATM Parameters ( eg. Hierarchy by Country, etc ).At the moment I can not agregate correctly  values ( withdrawals and cash at vault ) using hierarchy Country from ATM Parameters table. why? Could you please give me a some advice?

       

       

      Capture1.PNGCapture2.PNGCapture3.PNGCapture4.PNG

      Capture5.PNG

       

      regards,

      Tomek