Linux | ElastiCube Local files system Sisense application utilizes MonetDB to write raw data into Elasticubes (commonly referred to as EC or cube). Why does this happen? This allows Sisense to query the data from itself rather than sending a query ba...
Google Analytics CDATA Connector What You’ll Learn: In this course users will learn how to: Download a CDATA Google Analytics (GA) driver Install a CDATA GA driver Configure a CDATA GA driver How to connect using a CDATA GA driver Prerequisites: This...
Configuration of Share Permissions for a Data Model Does Not Save the Changes Question For Data Admins and Data Designer users, there is a function available to configure share permissions for the Data Model. Sometimes it can be noticed that new chan...
Managing Linux Build Service Settings for Optimal Performance and Stability An Elasticube build is a complex process that invokes multiple services. This article explains some of the settings that are used for controlling the build service which affe...
Sisense Data Pipeline Best Practices Architecturally, It is important to understand the role of Sisense in your use case and where it will fit best in your data architecture from a high-level perspective. Sisense is an excellent visualization tool th...
Resolving JVM Heap Errors During A Cube Build Occasionally when building a cube, you may run into an “Out Of Memory Error: Java Heap Space” error, as seen below.The build logic runs inside a Java Virtual Machine, which utilizes heap space as temporar...
HOW TO TROUBLESHOOT BUILD FAILURES (Linux OS)Building an ElastiCube imports the data from the data source(s) that have been added. The data is stored on the Sisense instance, where future dashboard queries will be run against it. You must build an El...
Introduction The following article discussed "Many-to-Many" relationships - Both expected and unexpected. It focuses on how they occur and the best practices which one can implement to avoid them. Table of Contents IntroductionTable of ContentsTable ...
Capturing accurate business transactions is imperative in understanding business operations. If data is constantly changing, such as being deleted or updated, how do you ensure your Elasticube is in sync with your data source? Depending on the use ca...
Introduction The following article discusses a dashboard's (high-level) development cycle. It breaks the process into easy measurable steps that start from the initial KPI planning all the way to maintaining and adjusting your end product. Table of C...
Introduction Customers often run into the question of which data model they should use (an ElastiCube, a Live model, or a Build-to-Destination). The following article presents some of the aspects you should consider when choosing between them. Sisens...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Analytical Need There are cases where our data arrives in aggregate form, like in Google Analytics (where the lowest granularity level is daily). If we wish to free up clutter in the dashboard and prevent the user from figuring out which field comes ...
Analytical Need In many cases a hierarchy appears in the data structured as 2 levels - A parent and a child. The business user would like to see the entire hierarchy and analyze the data according to the different levels, but can't do that since they...
Introduction Calculating transaction frequency for a given dimension is a common requirement across many verticals. e.g. Average Time Between Purchases by a Customer. Average Time between support tickets etc. While this can be calculated in SQL it ca...
The point of this article is to provide a method to a value associated with the most recent data in a date selection. Implementation Step 1: in the Elasticube, create a field transforming the date field into an integer using the formula below. Then r...
