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 ...
Introduction This post will explain how to denormalize your ElastiCube schema in order to get faster query response in SiSense Web. Purpose/Benefit Denormalization of data is used to reduce the query response time in SiSense Web. It is most useful f...
Source data that is flattened may require some or all of the columns of a source table to be transposed, in order to work seamlessly with SiSense’s functionality. This post will outline the cause and two possible solutions to this issue. The first so...
Download Zip: ExportTablesToCSVPostPlugin Files included: ectools.zipectools_sisense_ver<6.4.zip - (only for versions 6.4 and below)python-2.7.11.amd64.msiconfig_example.txtEC_export.dll This post explains how to install and configure the post plugi...
Both .ecdata and .ecube files are used to make backups of data and transfer data between ElastiCube Servers. Your data model or schema is saved in an ecube file. ecube files contain the schema and the data connection settings required for building yo...
Introduction This article describes how to enable an alert* when there is a risk of Many-To-Many relationship (M2M) between two or more tables. * This implementation involve the use of Pulse and it's supported in Sisense v6.5 and above. Motivation A...
Analytical Need In a dashboard, we wish to analyze how our entities (sales, inventory, tickets etc.) behave and break them by several categories. However, not all entities share the same categories. We wish to avoid a situation in which selecting...
Question: Which api should i use to create my elasticube? Solution: At the moment, REST API for creating Datamodels is only available on Sisense for Linux, starting from version L8.0.2. This capability should become available on the Windows version ...
Question: For a specific industry, like Education, even though the number of days is roughly the same every year, each academic year can start and end on different dates. The usual way of calculating YTD wouldn't work for this requirements because s...
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 relationshipData Relationships: ...
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 transpose...
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 d...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
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...
Linux | ElastiCube Local files systemSisense 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 bac...
Google Analytics CDATA Connector What You’ll Learn: In this course users will learn how to: Download a CDATA Google Analytics (GA) driverInstall a CDATA GA driverConfigure a CDATA GA driverHow to connect using a CDATA GA driver Prerequisites: Th...
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 af...
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 cha...
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 ...
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 tempo...
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 ContentsTabl...
