When a user queries an ElastiCube that is part of an ElastiCube Set, Sisense routes the query to a single ElastiCube with the latest ElastiCube build. By default, ElastiCube Sets operate in active-passive mode. In active-passive mode, one ElastiCube, by default the ElastiCube with the latest build, handles incoming queries. This ElastiCube is active while the remaining ElastiCubes are on standby in passive mode.

Sisense also supports active-active mode where queries are spread across available ElastiCubes within an ElastiCube Set. In active-active mode, each ElastiCube that is not currently building can handle queries.

You can modify how queries are routed to ElastiCubes within ElastiCube Sets by selecting one of the following routing strategies:

Single: (Default). ElastiCubes operate in active-passive mode where the ElastiCube with the freshest data receives all the queries while the remaining ElastiCubes are on standby.

Multiple ElastiCubes – Latest Data: ElastiCubes operate in active-active mode where queries are spread across all ElastiCubes with the latest data.

Multiple ElastiCubes – Optimized Performance: ElastiCubes operate in active-active mode where queries are spread across the largest group of ElastiCubes with identical data.

To set a query routing strategy:

  1. Click Admin in the upper-right corner and select the ELASTICUBES tab on the left.
  2. In the ElastiCube Set table, click pencil  for the relevant ElastiCube Set.
    ecsroute
  3. From the Routing Strategy list, select the relevant strategy.
  4. Click Save.