JAQLine Plugin - Visualize Widget’s Queries
*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
Purpose/Benefits
Note: This plugin requires Sisense V6.6 and later.
This plugin 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.
Steps
Step 1 - Add the Plugin
Download the attachment and unzip the contents into your C:\Program Files\Sisense\app\plugins\. If the plugins folder doesn't exist, create it.
Note that If you just created the plugins folder, you may have to restart the web server after unzipping the files.
Step 2 - Activate the Plugin
The JAQLine plugin is available for use by Administrator or Designer users. It will not be visible to Viewers.
In order to activate the Jaqline plugin, 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.
-
After upgrading to 7.2.1 this plugin breaks emailing any dashboard/widget scheduled or manually. We tested it with it being the only plugin installed and it broke email. It does not matter what type of objects are on the dashboard. It can be just a table or just an indicator. If jaqline is enabled we get the "could not connect to the ElastiCube" error. So I don't think this is an interaction with another plugin.
Very disappointing, we get a lot of value from this plugin due to the complexity of some of our cubes.
I do have a support ticket open about this.
-
The plugin was working fine with Sisense 7.3 but after upgrading to version 7.4 the plugin is showing a blank page with the following error in the console:
TypeError: Cannot read property 'forEach' of undefined
at o (/systemPlugins/main.74c5dc2a839a100f4fe8.js:20)
at r (/systemPlugins/main.74c5dc2a839a100f4fe8.js:20)
at /systemPlugins/main.74c5dc2a839a100f4fe8.js:20 -
Hi
Wondering if anyone has a work around to this problem -
We are experiencing a weird issue with this plugin conflicting with our dashboards on the recently upgraded 7.4 version. There is a 'Year' dashboard level filter which is Date type in the Elasticube. When an EDT time zone designer publishes the dashboard with 2019 pre-selected in this Year filter it is loading with 2018 selected for the CDT time zone users.
We have identified below code in the .dash file as the problem . The dashboards are publishing with the Designer's time zone and 2019-01-01 date , and since CDT is an hour behind they are seeing 2018 in the Year.
With Plugin
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2019-01-01T00:00:00Z"
]
}Without Plugin
"filter": {
"explicit": true,
"multiSelection": true,
"members": [
"2019-01-01T00:00:00"
]
}An
Please sign in to leave a comment.
Comments
42 comments