How to querying on build sisense elastic cube?

Question

I am new in Sisense tool. I have created elastic cube in Sisense and built this cube successfully. Now the elastic cube result does not match the source database result.

So is there any way to execute a query on Sisense built elastic cube to validate the cube data?

Answer 1

There's a web based tool that lets you write sql against your cube. It was called SqlRunner, and is now SqlEditor

https://developers.sisense.com/display/API2/SQL+Runner

An example command line which I've tested is

http://localhost:8081/app/sqleditor#/datasource=YourCubeNameHere&query=select%20*%20from%20%5Bdbo.Customer%5D%20&format=csv

Note that outputs the results as CSV, which you can then cut/paste to Excel