JAQLine Plugin - Visualize Widget’s Queries

March 27, 2017 06:28

*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\PrismWeb\plugins\ folder. 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.

Comments

21 comments

Mark Busuttil March 27, 2017 10:49

I added the plugin and re-started the service, however when I click on Analyze Widget JAQL I get a blank page with only the description on the top left.

Anyone experiencing the same issue?

0

Permalink
Gideon B March 27, 2017 10:54

Hi Mark,

What version of Sisense are you using?

0

Permalink
Stuart Gaston March 27, 2017 12:38

Hello,

I'm experiencing a similar result on V6.4.0.30091

We'll be rolling on to 6.5 soon, is this something that relies on the newer versions?

Thanks

0

Permalink
Stuart Gaston March 27, 2017 12:45

Hi Gideon,

Just noticed the version disclaimer at the top - we'll look to upgrade asap!

Thanks for the plugin

1

Permalink
Malinda Jepsen April 25, 2017 19:53

Is there a way to remove this functionality for plain users and only be available for designers and admins?

0

Permalink
Arik May 17, 2017 16:57

Thanks for bringing this up Malinda, I will check.

Best,

Arik

0

Permalink
Malinda Jepsen May 17, 2017 18:06

And, I should add... it's very cool!

0

Permalink
Ahuva Hazan-Fuchs May 22, 2017 10:30 (Edited May 22, 2017 10:31)

The plugin was updated. The plugin functionality is now hidden for viewer users.

0

Permalink
Malinda Jepsen May 22, 2017 19:31

Thanks Ahuva!

0

Permalink
Wendy Adams July 20, 2017 15:22

I'm a bit confused by your image (in the ids/linkages between Patients, Divisions, Rooms and Admissions). Are there just a couple of 'line crossovers' (i.e. should the Patient linkage be shown in the upper right quadrant to avoid this), or is there some kind of 'indirect' relationship stuff going on there, or what?

0

Permalink
Dean Shub July 27, 2017 06:55

Hi Wendy,

you're absolutely right, it does seem like there is a connection between them, but there is no real connection it is just line crossover.

When you activate JAQLine, the graph is interactive, so you can move around the nodes to see if there is a real connection or not :)

1

Permalink
Alice Summers August 30, 2017 11:53

I've just learned about this plugin on the 6.7 Release webinar - I'm new to BI and it's going to be so useful!

Is there an article with more details around what to look out for?

0

Permalink
Sam Ovenshine September 07, 2017 18:06

Hi Alice,

Unfortunately, there's not much more in the way of documentation on this plugin. A many side of a relationship is represented with the infinity symbol. You'll want to look for joins between tables where both sides have the many symbol to help detect a many-to-many relationship. More generally, you can use the plugin to see what tables/fields are involved in a widget. But for most of our customers, the plugin is primarily used as a many-to-many detection tool.

Sam

0

Permalink
Andy Chan September 27, 2017 16:37 (Edited September 27, 2017 19:53)

This has been working fine for the last 2 weeks, but now we have the blank window showing for this, but we are on v6.6.

I have restarted the Sisense app pool and IIS, but the problem is still there.

Any ideas what the issue might be?

Update:
Works ok in Chrome, but IE shows the blank page. It may be a setting - I allowed pop-ups but it wasn't that. Will use Chrome anyway.

0

Permalink
Nouman bhatti October 12, 2017 00:27

I'm not able to see the option in the dropdown menu .

It worked fine for few days but after that I don't know what happened

0

Permalink
Michael Sutton January 18, 2018 16:40

I got Sisense 7.0. and it stopped working for me.

Any ideas what's wrong here?

0

Permalink
Oxana Noa Umansky January 23, 2018 14:53

Hi all,

We'll look into the compatibility of the plugin with version 7.0 and get back to you with an update.

Also, if you are still experiencing issues with this plugin, not related to the latest version, please let us know in the comments below.

Thanks,

Oxana

0

Permalink
David Hertzberg January 26, 2018 09:25

Hi, great plugin !

But it looks like it is blocking the treillis widget to work : when JAQLine is activated, the treillis widget does not appear in the drop down list when creating a widget. It is back when I deactivate the JAQLine.

Best,

David.

0

Permalink
Oxana Noa Umansky January 30, 2018 20:13

Hi David,

Are you using the latest version of the plugin?

0

Permalink
David Hertzberg January 31, 2018 17:29

Hi Oxana,

thanks, you were right, version was not the lastest one ...

You know everything ! next time I'll be more carefull ...

Best, David.

0

Permalink
Oxana Noa Umansky January 31, 2018 20:20

Glad I could help 😊

0

Permalink

Please sign in to leave a comment.

Comments

Didn't find what you were looking for?