Thank you Marfi for your solution.
The company wanted an easier solution so I could not reply so far:(
I am trying your solution. I build a combined query. Each query has one dimension and two measure objects. Two measure objects are being calculated in two different contexes. So when I try to union these two queries, I am getting the error message below:
“This combined query cannot run because one of the queries contains incompatible objects.”
Are there any solution for combining queries which involves two or more sessions?
https://bobj-board.org/t/31425
I looked at this post, as I saw it is not possible but I am not sure.
Do you have any idea?
Thanks.
user3756 (BOB member since 2012-06-01)