Hi Support Team,
In our sisense console, we have the option to add data from different data sources like databases, excel files, google analytics and so on. We also have the option to add data from existing elastic cubes. As per my understanding, while we build a cube, it establishes connection with its data sources and imports all the data to its local repository. Once a cube is built, it has all the data with schema to its local server from where it serves any data request from its dashboard.
Ideally, if we add an elastic cube as data source in another cube, it must take lesser time to build as data is already available in its local repository and it has to just copy the data from one local position to another. But it is not happening in real scenario. In fact it is taking far more time than usual. Below are the screen shots
- When table is added directly from database (REPLPBCROMA)
2. When table is added from existing elastic cube (AG-CurrentData)
You can see the build time difference in these two scenarios. Please advise how we can optimize our cube performance.
Please sign in to leave a comment.