Is it possible to synchronise crosstabs using different queries ? Data sources are TM1.
I want to be able to drill down on a territory in Crosstab1 and crosstab to do the same - they are different TM1 cubes, but share common dimensions. One possibility is to create a third cube that contains all the details and the problem goes away as I don't need multiple crosstabs, but just want to exhaust all other routes before getting the TM1 architect involved.
thanks