In Sisense we have a component called recycler which holds queries and data on the cache in order to give results faster on something which already been queried.
This plugin will perform a navigation to specific dashboards right after the build is finished (in a post plugin) and will warm the recycler so next time when a real user will access the dashboard, it will be loaded faster.
1. SSO must be enabled as the plugin navigates to the dashboards.
2. Make sure all dashboards you want to navigate to, are shared with the user you're about to log in with
Download the attached .rar file.
Extract all DLL's files from the 'Post Plugin' directory to the following path: "...\Prism\Server\Plugins". If plugins folder does not exist please create it.
** Recommended way to to this is- extracting the files to another location and then do step 2 (some of the computers are not applying well when doing step 2 on the files in the plugins folder)
Extract the entire directory called "CacheWarmerPageLoaded" from the 'Front-End Plugin' directory to the following path: "...\PrismWeb\Plugins". If plugins folder does not exist please create it.
Ensure that the DLLs in "...\Prism\Server\Plugins" can run
2.1. Right click on each of the DLL files and choose properties.
2.2. In the General pane, if a button with an unblock caption exists, click on it (after clicking - windows will allow executing of this DLL)
Restart the ElastiCubeManagementService from the Services window. Sisense needs to be
restarted, in order to pick up the new DLL files.
Once in the ElastiCube Manager, open ElastiCube ==> Pre & Post Execution Plugins.
Add to the post plugin section a new plugin called "CacheWarmer"
Click on Add to configure how the plugin will behave - see Configuration section
Run build. In the build's finalizing step, the plugin execution will appear in the ElastiCube manager log window.
If there was no error, plugin ran successfully.
You should see the cube's memory raising in the Task Manager.
Once you extract the plugin and added the post plugin name to the Pre & Post Execution Plugins, you should configure all details relevant for the plugin
to work properly.
Here is an example:
dashboardsIDs="Dashboard ID1, dashboard ID 2"
phantomPath - a path to the Phantom.exe folder - plugin need to use the phantom in order to perform navigation (Phantom exists in Sisense folder)
dashboardsIDs - All dashboards' IDs you want to navigate to with comma separated.
baseUrl - base url for access sisense - default is "http://localhost:8081"
userName - The user you want to log in to Sisense and navigate to the dashboards (make sure the dashboards are shared with the user - viewer permissions are enough)
sharedKey - a key for creating the JWT token for the SSO process (can obtain via: navigate to sisense home page --> Admin --> Single Sign On and copy token.
timeout - time in seconds. Defines how much time to wait for page to be loaded.
The plugin is useful for loading heavy dashboards which include many values then loaded to the RAM. However, it won't be useful when using a dashboard with different data security filtering, as it's a different query with different results and it can't save every queried scenario.
Please sign in to leave a comment.