We are migrating Our BI application from one of BI tool to Tableau. And our main data source engine is Essbase and Oracle.
In our Previous Tool we have advantage of switching over multiple cluster of data source from Essbase. I.e. For Example. Consider there are six clusters in Essbase Engine. We can dynamically switch/fetch data from any of cluster for our reports. Switching & Fetching over cube/cluster from essbase is highly possible in our Previous tool. So upon migrating our Application to tableau i need to know whether this functionality (Switch/fetch between multiple cube/cluster in Essbase) also supported by Tableau or looking forward for other inputs. Please feel free to revert if my question is unclear. I will explain further if needed.
If I understand correcrtly you want to be able to specify the sever in the cluster that the query(from Tableau Desktop) will be sent.
There might be a possibility to achieve this with an initial SQL statement.
Hope this helps!