Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Data Relationships: Many-to-Many Relationship Resolutions

For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-Many Data Relationships: Check Type of relationship Data Relationships: O...

intapiuser by Community Team Member
  • 3098 Views
  • 0 comments
  • 0 kudos

Conditional Lookups

Analytical Need Using the lookup function to import data from one table to enhance another, based on specific conditions or filters. This might be required if we wish to import attributes from a table which is not unique. For example, a transposed di...

intapiuser by Community Team Member
  • 815 Views
  • 0 comments
  • 0 kudos

Linux | ElastiCube Local Files System

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

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
  • 1114 Views
  • 0 comments
  • 2 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
  • 1197 Views
  • 0 comments
  • 5 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 tempora...

HunterB_0-1663165954241.png HunterB_1-1663165954157.png
Anonymous by Not applicable
  • 650 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
  • 5354 Views
  • 15 comments
  • 5 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

This post has become outdated. You can find guidance on choosing a data model on our documentation site here. https://docs.sisense.com/main/SisenseLinux/choosing-the-right-data-model.htm Introduction Customers often run into the question of which dat...

83227784_3726975083979609_8570336295451099136_n[1].jpg

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
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: