__mash-up-2-image-unique-image-unique

__mash-up

<h4>To install the JAQLine add-on:</h4>
<ol>
<li>Download the attachment.</li>
<li>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 Files\Sisense\PrismWeb\plugins 
For V7.2 and later: C:\Program Files\Sisense\app\plugins 
Note: If you just created the plugins folder, you may have to restart the web server after unzipping the files.</li>
<li>To activate the JAQLine add-on, click on the menu of the widget, and then click Analyze Widget JAQL. 
<img loading="lazy" decoding="async" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/jaqline2_thumb_0_300-370x178.png" alt="" width="370" height="178" /></li>
<li>A pop up window will display the query visualization. Click outside the window to close it. 
<img loading="lazy" decoding="async" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/jaqline3_thumb_0_300-370x183.png" alt="" width="370" height="183" /></li>
</ol>

widget_jaql_1-image-unique

widget_JAQL_1

widget_jaql_2-image-unique

widget_JAQL_2

HIPAA

JAQL

metadata

query

visualization

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&#8217;t support this plugin. For More information visit https://documentation.sisense.com/docs/analytical-engine-overview

Leave Feedback