Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Google Analytics CDATA Connector

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...

antonvolov_0-1669830884902.png antonvolov_1-1669830884870.png antonvolov_2-1669830884859.png slosada_0-1669833737749.png
antonvolov by Sisense Team Member
  • 26 Views
  • 0 comments
  • 1 kudos

Sisense Data Pipeline Best Practices

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...

Darwin_0-1665171822475.jpeg
Darwin by Sisense Team Member
  • 148 Views
  • 0 comments
  • 1 kudos

Resolving JVM Heap Errors During A Cube Build

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...

HunterB_0-1663165954241.png HunterB_1-1663165954157.png
HunterB by Sisense Team Member
  • 87 Views
  • 0 comments
  • 0 kudos

How To Troubleshoot Build Failures (Linux OS)

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...

Krutika_0-1659023295057.png Krutika_1-1659023295088.png Krutika_2-1659023295249.png
Krutika by Sisense Team Member
  • 1054 Views
  • 8 comments
  • 4 kudos

Many-to-Many Relationships - Knowing and Avoiding Them

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 ...

Ophir_Buchman_0-1644955176043.png Ophir_Buchman_2-1644955319311.png Ophir_Buchman_3-1644955380874.png Ophir_Buchman_0-1645470915372.png

Planning, Executing, and Monitoring your Dashboard

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...

Ophir_0-1643098274233.png Ophir_1-1643098337878.png Ophir_2-1643098738509.png Ophir_0-1643099067104.png

Choosing the Right Data Model

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

Modelling Aggregate Facts

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 ...

Community_Admin_2-1634724930802.jpeg Community_Admin_3-1634724930845.jpeg

Build A Flattened Hierarchy From 2 Levels

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...

Community_Admin_0-1634724811074.jpeg Community_Admin_1-1634724811153.jpeg

Calculate Average Time Between Transactions

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...

Calculating Values For The Most Recent Date

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...

Community_Admin_0-1634681408782.png Community_Admin_1-1634681408855.png Community_Admin_2-1634681408858.png Community_Admin_3-1634681408852.png

Elasticube Modeling With Data Security: Best Practices

Adding Data Security to an existing Elasticube Model can have little to great effect on the performance of the system. It is important to already have planned the Elasticube Model with the intention to apply Data Security in the future. This article ...

Community_Admin_0-1634680887043.png Community_Admin_1-1634680887154.png Community_Admin_2-1634680887021.png Community_Admin_3-1634680886944.png