Forecasting using a macro trend (moving average) and seasonality (seasonal index) is a common way to forecast data into the future. The two components, seasonal index and moving average, are based on prior historical trends. They come together to for...
SYMPTOMSWhen you build an ElastiCube, the build may fail and the build log file will show an "OutOf Memory" exception. at ElastiCube.ManagementService.Process.DataTransformationService.ExecuteCopyIntoV3(ActivityBase activitiBase, TrackingItemEvent r...
Problem You want to create a Control Chart in Sisense to study how a process changes over time. A control chart always has a central line for the average, an upper line for upper control limit and a lower control limit. By comparing current data to t...
Edit the widge script. Copy and paste the code below and set the category name and color (hex format) desired.widget.on('ready', function(se, ev){ var e = element; var chart = e.data('hc'); var categoryName = "Beverages"; var data = chart.series[0].d...
Introduction This article will show how to modify the style of the legend in you widget.Steps Open you widget in Edit mode. From the Options Menu choose "Edit Script" to open the script editor.3. Copy and paste the following code into the script edit...
IntroductionThis article will demonstrate how to quantify on a date axis the availability \ unavailability of products given only the start and end date of each product's availability (See data format in "ProductData,csv" table below).Business CaseVi...
It some situations, it may be useful to be able to use IIS to host website that work with Sisense. A common example would be hosting a webpage that contains the code for an embedded dashboard. Additionally, it could be useful in scenarios when you wa...
When trying to migrate a Sisense environment from one machine to another, the installation might fail, returning the error message "Your license has exceeded its user limit":The following steps will reset the number of installations performed by a us...
IntroductionThis article explains how to create a custom field which rounds timestamps (Date-Time) up into time buckets. The buckets outlined in this article include every hour on the hour (10:00 AM, 1:00 PM), every hour on the half hour (11:30 AM, 3...
A C drive with very little or no free space can cause many issues, starting with ElastiCube build failure to service crashes, to make sure your Sisense installation runs smoothly you should make sure your C drive has sufficient free space.The biggest...
Analytical Need A key table (click the link to download a demo Data Model) is a central table that stores all the relationships between the primary key values. Modeling Challenge The main advantages of using Key Table: It helps to tidy up a schema th...
This post describes methods of importing JSON data into Sisense ElastiCubes. JSON is a file format consisting of arrays of key-value pairs wrapped in braces ("{}"). It is increasingly common with the popularity of NoSQL databases, and it is the typic...
Just after a clean (new) install of Sisense or after an upgrade, you may in rare cases run into the following error on the Data Sources page within the Web ElastiCube Manager (ECM 2.0):Unable to reach the Sisense Server, please ensure you are connect...
Problem You want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have. Solution Installing the Sisense ODBC drive...
In this post, we show the formula to calculate the shortest distance between two points using Latitude and Longitude.This calculation can be useful when trying to determine the distance for logistical purposes (ie delivery service, flights, distance ...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Share this page:
