Using the "desc" Description Parameter of a Sisense Dashboard via the REST API and the Dashboard Javascript Object The description parameter ("desc") of the Sisense dashboard object is notable for its somewhat unique characteristic – it's not access...
Localization in Sisense, or How to Control Date and Numbers FormatIn Sisense, the format of data displayed, such as date and numbers in widgets or filters, is managed by localization. By default, localization is set to be automatically detected based...
You will learn about common scenarios where we may need to copy or apply a new list of sharings for dashboards within this article. We need to export some dashboard corruption, remove them from the instance, and import them back. Copy the share lis...
Description Shifting between external sources that are based on different scripting languages is not an easy task. When there is a requirement to query a secured widget's data to an external source (Such as JQuery, JavaScript,HTTP etc.), you will ne...
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 ...
How to Update Live Model Dataset Configuration Through API Call In this article, we'll discuss how we can update Live Model query settings through API calls. Dataset resource represents a single data source of your Datamodel - for example, if your D...
On article Uploading Files Locally Using Rest (Linux) we saw examples of how to automate the upload of files to File Management. This article describe methods to automate the management of files on File Manager. Compatible with Linux Version <= L...
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...
Disclaimer: This is not a documented endpoint and thus might be changed in future versions. If this does not work, do not bother filing a support ticket. This is unsupported behavior. This API overview was generated based on L8.2.1. Your mileage may ...
To remove the connection from the Quick Access, please, use REST API.You need to do the following. For Windows: 1. Go to Admin - REST API - 1.0 2. Use 1.0 GET /users specifying username/first name/last name to get the _id parameter of the user 3. ...
In Sisense Linux distribution you are able to upload files to the Sisense environment via the file management Interface. This article describes few ways for uploading files programmatically using bash, Powershell and python.Powershell Script for uplo...
Though there is no direct API endpoint to get the number of rows in an elasticube, there is an endpoint to run SQL directly against a cube. Using PySense, it is straightforward to iterate through all your elasticubes, run SELECT COUNT(*) from each ta...
IntroductionThis step-by-step article explains how to change the color palette so that you can use custom colors for elements of the Sisense dashboards. (This will work in V5.7.5 and higher). How to get your existing palettes1. Go to v0.9 GET / pal...
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...
Creating an embed URL is a multistep process that can easily be botched along the way. Finding where the mistake was made can be tricky, and the generation of multiple embed URLs can be a painful process to repeat. With a simple python script we can ...
The Render API is perfect if you want to download a nicely formatted and dynamic PDF image of an entire dashboard. The Render API is an add-on feature in Sisense for Cloud Data Teams. Here is the official documentation on the Render API. This post wi...
Download: Post Message Introduction The following forum post explains how to log your users out of Sisense from your native application. Purpose Single sign-on (SSO) systems enable your users to authenticate themselves in your online services and th...
Sharing a dashboard by using the REST API is very useful in case you need to automate the sharing process.However, in order to do so more than one API call is required, and not using them all in the right order will result in an unsuccessful share.Sh...
This script creates a word-document of the given dashboard IDs. This document includes dashboard name and Widget name,description and image. Config settings.yml Edit settings.yml with your information ! Be carefull running this script. It searche...
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:...
