Use Case My users and designers were looking for an easy way to get insights into how certain dashboards and widgets were built in terms of formulas and filters. Solution For this, I have written a Python script that takes a list of dashboard IDs...
How to hide the "Switch to view mode" button based on a role This article provides an example JavaScript snippet that could hide the "Switch to view mode" button based on the user's role. How to use it? First of all, you need to get the role name y...
Migrating Blox Custom Actions When relocating Sisense resources from one server to another, the Sisense Rest API is a possible method for transferring Sisense components and objects like dashboards, users, groups, and data sources. Similarly, Blo...
If you've ever attempted to dynamically resize your embedded iFrames in your parent application, you may have experienced a CORS conflict. Basically, since your parent application and sisense application serve from different domains, your browser re...
An offline, or air-gapped, Sisense environment provides higher security than online, connected environments. As the offline environment has no outside communication, the only method to install Sisense in this environment is by using removable media,...
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 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 ...
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 the Sisense Git Integration! In today's CI/CD ecosystems, efficient asset migration from development to production environments is crucial for delivering high-qualit...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
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 ...
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...
