Sisense has the capability to share a local file (excel, word, pdf etc.) with dashboard users. Note: The file must be saved on the server in the following path: %programfiles%\Sisense\PrismWeb. You can create a new folder or save it under 'Resour...
Problem There are many data sources (connectors), such as web service APIs where we not familiar with their tables/fields like Facebook, Twitter, Youtube etc. Before importing your data from a web service, you should know the data in advance. This l...
Question: The purpose of this post is to demonstrate how to connect to a Sisense Elasticube from Microsoft Excel. Solution: Begin by installing the Sisense ODBC driver. https://www.sisense.com/data-connectors/odbc/ Once it is installed, go to ODB...
Introduction Many times we'd like to analyze our data according to top/bottom ranking positions, for this we have out-of-the-box ranking filters. At other times, we'd like to see certain ranges, such as the ranking range between certain ranks, i.e. p...
Question: As of version 7.3, If you're using Outlook365 (not on-prem) as your SMTP server, you might encounter the following error when sending batch emails: 432 4.3.2 STOREDRV.ClientSubmit; sender thread limit exceeded Essentially, this error is th...
Question: MongoDB logs keep growing and lead to no available space on Drive. Solution: Need to Enable Log Rotation In MongoDB. The following properties, located in "C:\Program Files\Sisense\Infra\MongoDB\mongodbconfig.conf", enable the log rotatio...
Question: When an elasticube is created in desktop version of elasticube manager, only a .ecube file gets created, where as when an elasticube is created in web version of elasticube manager, a folder with the elasticube name is created that contain...
Question: Sisense Service hangs and I try to start them in Windows Services, but the usual net stop & net start will not restart them. net stop /y will stop all dependencies. Solution: Follow the instructions below to force start a Sisense Servi...
Intro One may want to delete the connection credentials entered in ElastiCube Manager. This to prevent other users who have access to the server, being able to connect to the data source on their own - and getting access to sensitive data. steps: ...
In some cases, we'd like to be able to customize the Slack notification footer to include our own company name. By default, Sisense sends the alert with the footer "Sisense Alerts" as can be seen in the screenshot below: How do I customize the footer...
Reducing Windows Memory Pressure by Removing unused JVM Connectors A simple technique can reduce memory pressure on Windows Sisense versions by inactivating unused JM connectors. To do this you should search for the Sisense JVM Connectors Configura...
Symptoms Starting from the W2022.3 version, Sisense uses a non-default authentication user while connecting from any microservices to Sisense RabbitMQ (Sisense.Broker service). In some cases, you may need to manually re-provision the RabbitMQ user. ...
Download: GitHub Link Version: 1.0.0 Introduction: This article explains how to install the plug-in and how to interact with the js and configuration file. Purpose/Benefits: This plug-in will add or change change the current script applied to widget...
Overview: Keeping your Sisense environment healthy and up to date is essential to a successful Sisense instance. This article contains general information about Sisense deployment and maintenance. Please reference the linked articles for additional ...
There is an option to get an activation key using an API GET call to the Sisense licensing server rather than needing to log into the Sisense site to obtain this information. Use case: This method helps generating license keys in a batch when yo...
If you need to color columns in a column chart based on a different formula you will need to use the following solution. For this example, we will color the columns that calculate [Total Cost] for the [City] by another value, that is calculated by t...
Question: I am trying to download and install Sisense but when I do, it says the license server is unavailable. Answer: If your license is up do date, please take the following steps: Within the Windows menu, search for Sisense Activation, then ri...
Question Is there a way to add pre-processing (python script) to the data that will be uploaded from a custom API connector? Or should I run the script locally on a fixed schedule and use the Sisense API to upload after the data is processed? Answ...
Question I would like to be able to track memory consumption of my ElastiCubes, but I can't find an easy way to link the process ID of my ElastiCube to the cube name. Answer If you open the Task Manager, go to the Details tab and right-click on o...
Question: Sometimes your server might run out of space on because the SVI (System Volume Information) is eating up all memory. The system volume information is used in windows in order to save information related to system restore which is used wh...
