Knowledge Base

How to use a widget.transformPivot function to change the background color of the entire row

This article provides an example JavaScript code snippet on how to use a widget.transformPivot function to change the background color of the entire row based on a value within that row. Please refer to the Sisense developer's documentation to learn...

BloX Write Back Form to a Source Database

BloX Write Back Form to a Source Database Sisense BloX Database Writeback This guide demonstrates setting up a simple BloX widget to enable front-end users to write data back to the database. While this guide specifically uses AWS lambda to execute ...

Querying the Sisense Elasticube with Python

This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC ...

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...

Schedule Download Of SQL API Queries To CSV

Introduction With the Python script below and the Window Scheduler, you can automate the download of csv files based on queries of the SQL API to the elasticube. This type of process comes in handy when a user needs to download information regularly...

REST API - Adding Data Level Security

When building code to automate the process of adding users (or groups), it may be beneficial to add security around those users. Follow the steps below to learn how to add data level security through the REST API: Step 1 From your SiSense home pag...

Rolling Averages Using Window Functions

Want to show a rolling average for your data, but not the granular breakdown? We can use the average window function to run this calculation. First, I created a CTE that contains the number of new users per day on a fictional gaming platform. I...

Introduction To Hyperparameter Optimization - Machine Learning

There are lots of knobs (a.k.a hyperparameters) we can turn when coming up with a Machine Learning model. in the script below, we take the well-known iris dataset, and play around with different hyperparameters. First, a few notes: In machine lear...

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:...

Resend Invitations to Inactive Users in Bulk

Steps: 1) Download Python and install it on your PC or the Sisense machine (make sure to add python to the PATH to easily initiate installation of directories). 2) Run CMD and type the following commands to add libraries used as part of our solution...

Python 3 Script to Import Many ElastiCubes

Introduction The attached script is intended to loop through all ElastiCube folders in your ElastiCubeData folder and import them. Business Case This solution has a couple of possible use cases. The first is to facilitate migrating a Sisense environ...

Sample Code for Sharing Dashboards Using the REST API in .NET

Introduction A sample code to demonstrate adding shares using the Sisense API in .NET. The programs flow is a follows: Retrieve the authentication token using:Retrieve userID using:Retrieve the current shares for the dashboard using:Share the dashb...

How To Order A Stacked Column Chart Using A BreakBy

Introduction When adding a break by field to an ordered column chart, the order does not exist anymore.We have created this post in order to workaround this problem. StepsIn order to use the script, you need to follow the next steps: 1. Edit the...

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 ...

Resizing And Scaling Charts In R Python

You have you have an R or Python chart but it renders very small. How can you resize it? The Functions to Resize the Canvas These functions will set the max size that the image is capable of rendering. For R, you can append the following line befo...

Prepping A Dataframe To Hold Your Training And Testing Data - Machine Learning

Once you have optimized your hyperparameters, it may be nice to create a dataframe that has some of your testing and training data to train your model. Here, we are going to use a KNN model with n_neighbors = 6 and "distance" weights on the iris dat...

Is it possible to enable/disable a plugin with REST API?

Question: Is it possible to enable/disable a plugin with REST API? Answer: Option 1 It is possible with the /api/plugins endpoint. Here is the script we use for a single enable/disable of a plugin; For enabling set isEnabled to True For disabling ...

How To Create Elasticube Using Api

Question: Which api should i use to create my elasticube? Solution: At the moment, REST API for creating Datamodels is only available on Sisense for Linux, starting from version L8.0.2. This capability should become available on the Windows version ...

REST Connector troubleshooting

Sometimes a user can experience difficulties while defining a REST connector. This guide will help to troubleshoot these connectors. Topics: REST connector prerequisites Timeout issue Logs to review Rest Connector Prerequisites: Below are the pr...

How to install new kernel or update existing one in Ubuntu

Some OS related issues could be fixed by installing a different Linux Kernel. In this article we will review how to install a new kernel and make it bootable by default.Installing a new kernelDisplay version of currently running Kernel: uname -r Exam...

Sisense Community

Ensuring Accurate PDF Export Headers When Programmatically Modifying Dashboard Filters in Sisense

Knowledge Base Articles