Legacy warning – This add-on is available for customer use but is no longer actively supported or maintained by Sisense.
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 only on ElastiCube models with the old translator active. The Analytical Engine doesn’t support this plugin and instead uses the new Query Plan Analyzer. 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.