Two aggregate measures from different tables

[system]

It worked!
Thanks a lot for your help!

FYI – If anyone is interested I also found this post that talks about “multiple sql statement for each measure” checkbox in the universe:

120×120 10.4 KB

Thanks Susanne. Yes it is clear and I have done an enormous amount of testing the last couple of days and came to a similar conclusion. If you want multiple SQL statements is best to have multiple contexts. What I found on the multiple SQL per measures was similar. If you included a dimension from the lower table in the query it will still join on all tables in the separate SQL. The bottom line is that you must understand exactly how all this works and tailor each universe to get the correct res…

---

vkamins (BOB member since 2007-10-19)