Analytical Need Attached below is a BloX template.A common request is to have a 'From To' input at the top of the dashboard to affect a calendar range selection of dates.To achieve this need we can utilize BloX's form capabilities.Picking a date rang...
Question: Sisense installation on Windows server stuck at 20% install and then the installer fails: In the %temp% install logs we saw the following errors: Error 0x80070570: Failed to extract all files from container, erf: 1:4:0 Error 0x80070570: Fai...
Question: Viewers don't have the ability to show and hide grand totals which I want them to be able to do. Is it possible to achieve with Blox functionality?Solution: The pivot widget's "style" attribute includes settings for grand totals, and you ca...
Question: How can I help the exact version and build of my Sisense environment?Solution: There are 3 easy ways to find the exact version of your environment:On the web application Open your Sisense web application On the top toolbar, click on the per...
Question: How can I access all the cubes from another server, if I installed another Sisense system on another machineSolution: In order to get the cubes from another server you can follow these steps. If the computer you're working on is a computer ...
Question: Due to security considerations I want to be able to disable TLS1.0 with a view to disabling TLS1.1Solution: Starting in Sisense 7.4, it became pretty straightforward to disable traffic on TLS 1.0 and 1.1.Setting this up involves two steps: ...
Question: When I'm trying to sign out from my existing login. It shows a warning alert "Sign out failed".Solution: This error might happen when Sisense Activation is not run with administrator privileges. To fix this error please try the following: S...
Question: I am trying to download and install Sisense but when I do, it says the license server is unavailable.Solution: If your license is up do date, please take the following steps: Within the Windows menu, search for Sisense Activation, then righ...
Analytical NeedFact tables may include a wide date range. For instance, a table can have historical dates without any transaction of the current year,The Need : filter the dashboard based on the latest year in the data Modeling Challenge We need to f...
In this article, we are going to map some of Sisense Dashboard Design Best practices related to performance. When you start developing a dashboard or when you want to simply improve its performance, take a look at the guidelines below and adjust your...
Month to Date (MTD) and Year to Date (YTD) calculations provide us results of activity in the time between the beginning of a date (can be a month or year in our example) and the beginning of the current month or year. This in turn allows data analys...
Browsing our site, speaking to our team, or reading about us in analyst reviews, you might have noticed that we dig technology here at Sisense. That’s why when clients and prospects desire to push the limits, both in terms of data complexity and quan...
Analytical Need You want to display a value for a selected member (i.e. Salesperson) vs the min/max of all non-selected members. This can be achieved using modeling techniques but this solutions describes how to do it purely in the front end. Solutio...
Analytical Need For a metric, I need to calculate the month difference between the min and max date of purchase for each brand in my dataset. I want the dates to be dynamic in respect to filtering, etc. I am using the attached .ecdata and .dash files...
This article will show how to set conditional formatting on a specific value based on another one that doesn’t directly relate to it. For example, when one wants to show a total of revenue in a specific region and set its color to green in case the m...
