Visualize Queries

By Sisense

Add-on Version 1.0.4

OS Support

Windows

Linux

Supported Sisense Versions (Linux) 7.4.3 - Latest

Last Updated January 2, 2024

Tags

HIPAA

JAQL

Metadata

Query

Visualization

Sisense Marketplace Terms and Conditions

Download

Leave feedback

The Jaqline plugin is not supported by the Analytical Engine. To explore the generated query, use Query Plan Analyzer.

The JAQLine add-on provides a visualization of the queries a widget performs towards an ElastiCube so you can understand which tables participate in the query, and which relationships between the columns of the tables are in-use by the widgets queries.

This plugin can help you troubleshoot your widget by displaying many-to-many relationships, and identify possible causes of slow query performance.

Note: The JAQLine add-on requires Sisense V6.6 or later and works on ElastiCube models only. The Analytical Engine doesn’t support this plugin. For More information visit https://documentation.sisense.com/docs/analytical-engine-overview

To install the JAQLine add-on:

Download the attachment.
Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.
For V7.1 and earlier: C:Program FilesSisensePrismWebplugins
For V7.2 and later: C:Program FilesSisenseappplugins
Note: If you just created the plugins folder, you may have to restart the web server after unzipping the files.
To activate the JAQLine add-on, click on the menu of the widget, and then click Analyze Widget JAQL.
A pop up window will display the query visualization. Click outside the window to close it.