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

Knowledge Base Articles

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

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

intapiuser by Community Team Member
  • 2835 Views
  • 0 comments
  • 1 kudos

Data Denormalization for Faster Dashboard Query Response

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

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

Data Transpose Guide

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

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

Export Tables To CSV Post Plugin

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

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

Alert on a M2M Risk

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

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

Not all dimensions relate to all facts

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

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

How To Create Elasticube Using Api

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

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

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 relationshipData Relationships: ...

intapiuser by Community Team Member
  • 6321 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 transpose...

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

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

83227784_3726975083979609_8570336295451099136_n[1].jpg

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
  • 8062 Views
  • 15 comments
  • 6 kudos

Linux | ElastiCube Local Files System

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

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

antonvolov_0-1669830884902.png antonvolov_1-1669830884870.png antonvolov_2-1669830884859.png slosada_0-1669833737749.png
antonvolov by 7 - Data Storage
  • 1458 Views
  • 0 comments
  • 2 kudos
Labels