Extracting Usage Analytics Data

You can run SQL queries to extract data from ElastiCubes, including the Usage Analytics ElastiCube. This data is collected and stored in a CSV file. You can download this CSV file with the SQL Runner with the following call:

http://localhost:8081/api/datasources/LocalHost/Usage%20Analytics%20Model/sql?query=select%20*%20from%20usage&format=csv

In this example, LocalHost is the name of the server where the Usage Analytics ElastiCube is located. If you are connecting remotely, change this to the IP address or name of the server as defined in the Data Sources table in the Admin page of Sisense.

customizing-user-roles

Note:

Following security enhancements made in Sisense V7.0 and later, this feature is only available to Administrators. You can allow additional user roles to access it by Customizing User Roles.

For more information, see SQL Runner.