Skip to Main Content

MARKETPLACE

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

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:

  1. Download the attachment.
  2. 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.
  3. To activate the JAQLine add-on, click on the menu of the widget, and then click Analyze Widget JAQL.
  4. A pop up window will display the query visualization. Click outside the window to close it.

This is a free add-on. Click here to download.

Two people on discussion

Subscribe to the Sisense newsletter