Consolidated Jump To Dashboard Plugin
*This plugin is officially supported by Sisense. You can find the latest version of this plugin on the Sisense Add-Ons page.
Introduction
The following article describes the steps needed to jump into a target dashboard (via new tab / popup window) from a selected widget with applied scope.
Clarifications:
-
This plugin unites all previous plugins published (drillToDashbaord /drillToPopUpDashbaord):
https://support.sisense.com/entries/60285470-Drill-to-Pop-Up-Dashboard
https://support.sisense.com/entries/57530174-Jump-to-sheet-with-applied-scope
https://support.sisense.com/entries/61485854-Drill-to-Dashboard
-
This plugin supports charts, pivots and indicators
-
In order to jump to the related dashboard: Right click on the widget, and choose the option "Jump to ..."
-
Supported filters that transferred to target dashboard
-
Pivots: dashboard filters, widget filters, measured values
-
Charts / Indicators : dashboard filters, widget filters
- Changing widget type looses the jump definition, needs to be reconfigured
- When importing a dashboard to another environment Jump needs to be reconfigured
- If you are using an older version of the Image Plugin it will cause the new image indicator smear - image plugin was updated, replace it with the old file
Business Case
An effective business intelligence dashboard should tell the user key things s/he needs to know about the business, in a flash, and still enable the user to drill down into data. This plugin enables the user to present additional information about specific series on demand (=by jumping into a target dashboard from a widget), without the need to present all the data in one dashboard.
Example
Jump to Pop-Up Dashboard:
Steps
Step 1 - Download and extract the enclosed folder into the plugins folder:
C:\Program Files\Sisense\PrismWeb\plugins\jumpToDashboard, if the "plugins" folder is not there, create it
***Please rename the folder name to "jumpToDashboard"
***If you have previous Jump/Drill plugins, remove them
Step 2 - Creating your target dashboards
Create the target dashboards, use the “_drill_” prefix to indicate this is a target dashboard (default setting define that target dashboards won't appear to the users in the dashboards list, and are accessible only when jumping to them)
Step 3 - Defining the target dashboard in a widget
Enter the editing mode of the desired widget, click on the settings icon, and choose the target dashboard from the possible target dashboards created. Click apply to save the changes.
Step 4 - Jumping to target dashboard
Once a target dashboard is defined, right click on a point/cell and choose "jump to dashboard"
Indication icon is added to the “Jumpable” widgets:
Additional configurations
The default settings of the JumpToDashbaord plugin, doesn't requires any JS configuration. However, you can change the settings per widget by editing the widget’s script. Inside a widget’s edit mode, click on edit script, paste the below code (after editing the required parameters), click save, refresh the widget and click apply.
JS code:
prism.jumpToDashboard(widget, { <parameter> :<Value>});
When changing few parameters, the below syntax should be used:
prism.jumpToDashboard(widget, { <parameter> :<Value>,<parameter>
:<Value>,<parameter> :<Value>});
To remove all setting defined (erasing the script will still keep the previous settings):
prism.jumpToDashboard(widget, { });
Default settings can be changed by editing the config file located in the plugin folder:
C:\Program Files\Sisense\PrismWeb\plugins\jumpToDashboard\js\config.js
Configurable parameters :
Examples:
-
To change jump type into pop-up mode, and hide panels:
prism.jumpToDashboard(widget, {drilledDashboardDisplayType:2,
displayFilterPane:false, displayDashboardsPane:dispfal
se, layToolbarRow:false, displayHeaderRow:false });
- To exclude country and brand filters when jumping to target dashboards:
prism.jumpToDashboard(widget, { excludeFilterDims
: "[country.Country],[brand.Brand]"});
***Note - Ad blocking programs might disable the plugin functionality
***Plugin update history is now included in an attached .txt file
*** Might experience jumping issues with shared users in version 6.2.0, solved in version 6.2.1
Update on November 28th, 2016 - jump to dashboard link covered all widget including the header - fixed.
Added Pop-up Resizer(can be enabled from config or from Widget script)
Update on May 16, 2017 - fix for text widget mouse pointer indicating clickable state
Update on May 25, 2017 - fix for resize window icon for v.6.6.1
Update on August 24, 2017 - fix for the Richtexteditor edit issue with installed JTD plugin
Update on December 28, 2017 - We added a new parameter to the parameters which is:
- name: showJTDIcon
- description: Rather to show an icon for widgets that has JTD in the widget title
- type: boolean
- default: true
Update on January 24, 2018 - the plugin was fixed to work with version 7.0
Update on June 06, 2018 - bug fixes
-
I ran into this recently so let me know if you have already tried this. Go into Developer Tools (F12) if you are on Chrome > Next go to the Network and click CRTL + R to record > Next go into the Preview tab and look for the JAQL statements that contains your time dimension > Once you have found your value open up the metadata drop down and it should give you the exact phrase to use. For example in my screen shot it would be "[DimTime.DateforG/L (Calendar)]" which is weird because it does not follow the same structure as other dimensions. Hopefully this helps
-Andrew
Capture.PNG -
New version works nicely, seems to solve the intermittent issue I had!
Wondering though if there is a way to not have all the column highlighted as a link in a pivot click through. Customers think that what they are clicking through on is what they will see. Any chance I could specify the column number I'd like to see highlighted? Especially in very wide pivots having 12 columns all highlighted is a bit confusing to the end user.
Thanks!
-
I have been noticing that the overwrite in a dashboard script occasionally gets ignored after you do something wrong, like some bad syntax or including a filter that does not exist. It will then revert back to the default setting and it is hard to make it pickup the script overwrite again. IISReset doesn't do it, the only fool proof way I have found is to reboot the server, but that is a bit overkill I would assume. Any ideas?
-
ISSUE: The latest version introduced an issue with IncludeFilterDims. If the the Filter is a Hierarchy it will not longer respect the includedFilterDims. If you split the filters into two separate filters however it works fine. This used to work in the older version and got introduced in one of the last two.
-
Has anyone experienced a problem w/ this NOT working in Internet Explorer (v 11.0.9600) but DOES work in Chrome? If so, how did you fix it? Have tried troubleshooting w/ Sisense but so far no luck. Quite possible that it's a corporate-controlled setting in IE but we don't know where to start. Thanks for any help!
-
I am still getting odd behavior where it will open many new tabs when I click o a cell in a pivot table. It basicvally opens as many tab as you change filters. I.e. you make 5 changes to 5 filters it will open 5 tabs.
The only way around it is if you refresh after setting the filters or unselect the update every time box.
See Ticket 24482 for a video illustrating the behavior
-
@Mike - Thanks for bringing this to our attention. Our developers are working on fixing this issue.
@Michal - There was a problem with one of the settings in the config file that caused this. The "drilledDashboardPrefix" property was set to an empty space thus causing all dashboards to show up only for their owners. I've modified the file to include this setting with the default value of "_drill". So you could either change the settings back to the default or download the newer version. Thanks!
-
My cubes are getting a big large and I want to split it into a few smaller ones. I do however want to maintain the ability to jump to dashboard between them. Support told me about a trick to remove some code from the plugin but that display all the dashboards across all my cube which is a bit overwhelming especially with cubes belonging to different customers.
I tried the syntax to hardcode the dashboardid but that doesn't seem to work
Any suggestions?
See Ticket 25565 for more details
-
I am having trouble getting the jump to dashboard to be usable for other users.
For me (the Dashboard Owner) I can just left-click and it will jump to the other dashboard just fine with active filter etc.
But after I have published both the main dash and every _drill_... dash, the end users do not see any way to jump to the dashboard. If they left click, nothing. If they right click (as in the directions) they also see nothing. I am pretty certain the plugin is installed correctly (as it works for me) but its seems like a permission thing.
-
Hi,
I'm facing the same issue,
was it resolved for Todd?
Desktop.zip -
Hi Eyal,
In order to see the jumping option it is essential that you will have a dashboard with a prefix named _drill_ and that the new dashboard you are creating is associated to the same ElastiCube that the _drill_ dashboard is related to. If this is not the case, please do open a support ticket so we can better understand the scenario.
General note to add, the issue Dana reported on is resolved in Sisense version 6.2.1
-
Hi,
I was sent here by Nir as a solution to my request, namely, to be able to have a superdashboard which shows KPI's for other dashboards so that you can open this dashboard and see where your attention is needed. If something is going wrong, you can click the widget to go to a more detailed dashboard to show you what's happening exactly. Unfortunately, this doesn't really seem to be a solution to this request.
The thing is that our superdashboard contains widgets running on different Elasticubes (using the Copy Widget functionality introduced in Sisense 6.2). It seems that this plugin only allows for adding jumps to dashboards running on the same Elasticube as the widget you're clicking on. I've tried it using the UI to create links and using the Edit Script functionality for a widget. The UI only lists the dashboards running on the same cube and using the Edit Script thingy doesn't do anything at all.
Is there a way around this as this plugin is now only partly usable for us.
Thanks
Tim
-
Hi,
Running Sisense 6.2.0.336 and the attached jumpToDashboard_may_22_2016.rar file. I've set the prefix to "" so I can link to all dashboards. This works for the user that's the owner of the dashboards, but for other users it hides all the dashboards! When I set the prefix to the default "_drill_", the dashboards are visible again, but the linking functionality doesn't work (although the indicator is shown in the widget header).
How to fix this?
Thanks
Tim
-
@Tim - hideDrilledDashboards - this the parameter which hides all dashboards for non-owners when you specify an empty prefix(you can find config.js file in plugin folder/js folder and edit it there globally). By default it is set to true, set it to false and all of them should be visible for non-owners as well.
Regards,
Michał
Please sign in to leave a comment.
Comments
132 comments