This content has been marked as final. Show 4 replies
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?