Knowledge Base

Elevate Your Data Product’s Quality with Streamlined Version Control leveraging Our Git Integration

Elevate Your Data Product’s Quality with Streamlined Version Control Leveraging the Sisense Git Integration! In today's CI/CD ecosystems, efficient asset migration from development to production environments is crucial for delivering high-qualit...

How to embed an image from an external drive in the Sisense widget (a Blox template)

This article explains how you can embed images from an external drive (Google Drive) to the Sisense widget. Note: The solution is implemented with the help of the Blox plugin and on the L2023.3 Sisense version. In order to embed an image into the Blo...

Pixel Perfect Reporting Using Crystal Reports and Open Sisense (ODBC)

While Sisense provides powerful analytics and simple report printing, if pixel perfect report printing is required, additional tools like SAP Crystal Reports must be used. Purpose/Benefit Pixel Perfect reports can be designed which use data from a Si...

Trend Analysis

Trend analysis enables users to compare actual totals against measures derived from the data. This will enable users to compare actual results against derived amounts, and even project those amounts into the future. This example will use a simple ave...

Dynamic Dimension/Value Chart

Version: 1.1 Download the plugin attached Introduction This article explains how to install and configure the Dynamic Dim/Value Chart plugin as seen below. The Dynamic Dim/Value chart allow Dashboard designers to predefine multiple dimension and/or...

Reorder pivot columns by viewers

Need A common requirement for self service BI is to enable the viewers to save their own report. This can be achievable in Sisense if you are a designer of a dashboard. However, when you are a viewer, you cannot even re-order the pivot columns as...

Python Script to Export Dashboards to CSV File

The following Python script allows exporting dashboard data to CSV files. The script will export each widget to a separate CSV file. This new version of the script uses Sisense's REST API an eliminates the direct connection to the mongodb. Important:...

Extend The Functionality Of A Dashboard

Introduction This post describes the process for creating a new plugin that extends the functionality of the dashboard user interface. There are several different aspects that you can modify, this document will focus on the most common use cases. ...

Embedding Custom Visualizations Within A Widget

Introduction This document outlines the process for overriding an existing chart with a Highcharts Donut Pie chart. For a more robust solution, it is recommended to create a custom plugin as that would allow non-technical users to create charts wi...

Conditionally Colored X-Axis Labels On Bar Chart

Introduction The code below allows you to color the x axis labels for each category of a bar chart based on the color of a secondary series. It also then hides the secondary series from being plotted. Steps STEP 1 The first step is to create a bar c...

Retrieve All Widget IDs, Titles And Types In A Dashboard

1) Open the Developers Console (press F12 in Chrome.) 2) Navigate to Console tab: 3) In the console prompt line, enter the following script and press Enter: 4) prism.activeDashboard.widgets.toArray() 5) This results in a printout of an object with ...

Embedding Twitter Widgets In Sisense Dashboards

Introduction In this post we will demonstrate how to add a twitter feed within a dashboard. Business Case Viewing the latest tweets from key people in your industry may be an enhancing capability. Example Embedded Twitter Widget that is shown below...

Design a schema with more than one fact - Multi Fact Schema

Analytical Need We have multiple sources for our measures and multiple sources to slice & dice these measures. Modeling Challenge How do we build a schema that will enable us to perform our needed analysis? We will need to connect all of our t...

Analyze Period over Period - MoM / WoW / DoD

Analytical Need There are cases where we want to analyze our measures as a comparison between periods of time. For instance, ee want to know how did our measures behave on January this year vs. previous year. This means that we have to put down in...

How To Troubleshoot Build Failures (Linux OS)

HOW TO TROUBLESHOOT BUILD FAILURES (Linux OS)Building an ElastiCube imports the data from the data source(s) that have been added. The data is stored on the Sisense instance, where future dashboard queries will be run against it. You must build an El...

BloX - A Technical Introduction

BloX - A Technical Introduction To start, download the attached file ‘BloXTutorial-Styling.dash’ file and import this into your Sisense environment. This dashboard uses the ‘Sample Ecommerce’ data model and contains all iterations of the BloX widget...

Controlling JAQL Timeout | Linux

Controlling JAQL Timeout | Linux Please note this article is for Linux users. What You’ll Learn Main Properties of a JAQL requestWhen the JaqlPool parameters for managing JAQL request timeouts are triggeredWhen to change the default values for these...

Websocket Functionality Within Sisense

Websocket Functionality Within SisenseIntroductionSisense uses the WebSocket Protocol to load dynamic content within the platform. It’s important to remember that the WebSocket Protocol is simply an upgrade of HTTP(S) traffic, relying on the same bas...

Advanced Configuration Control via API Calls

Advanced Configuration Control via API Calls Frequently, there are situations when a user is required to change some Sisense parameters when access is not available due to a wrong configuration, or it is required to automate switching of some config...

Viewing Widget JAQL Queries

Viewing Widget JAQL Queries There are a large number of reasons you may want to view the query(ies) being sent from a dashboard widget, most of which are performance or data quality related. This article explains two methods that can be used indepen...

Sisense Community

Enable/disable field suggestions in the NLQ (Simple Ask)

Knowledge Base Articles