Content
How to show the year on the widget starting from the beginning of AD till today in a Live model
06-17-2025 This article provides a solution for users who need to manage their cube file sizes in a Sisense environment by keeping the cube files while removing the data within them. This can be useful.
06-09-2025 When trying to export a data model from the Data page, if the model exceeds 2 GB in size, the export process fails. Users typically see a generic error message, and the model is not exported successf...
05-22-2025 Query caching is a common mechanism used to enhance performance by storing frequently accessed data in memory. However, in scenarios where data models are continuously updated in real-time, caching c...
03-28-2025
Reading multiple Excel files into Sisense data model
Introduction:
If you are migrating from Windows to a Sisense Linux-hosted solution, on the Sisense Windows machine you may use an SFTP clien...
11-04-2024 This article explains one of the example use cases of User Parameters laid out in User Parameters - What They Are and What They're For (Example Use Cases).
05-21-2024 User Parameters Use Case - Enforcing Data Isolation / Row-Level Security Rules from Source Database This article explains two of the example use cases of User Parameters laid out in User Parameter...
03-26-2024
Introduction
This forum post will demonstrate how to save your ElastiCube .ecdata file which contains your ElastiCube schema and data, and the .dash file of your desired dashboard.
Purpose/Be...
03-02-2023 Data accumulation is SiSense's method for building ElastiCube data without completely refreshing a table. This post describes the data accumulation functionality and gives a user the ability to custo...
03-02-2023
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
...
03-02-2023 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...
03-02-2023 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...
03-02-2023 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 ...
03-02-2023
Part of having a successful BI tool is having your data refreshed on the time you need it. To ensure your builds are working as expected, you can follow the steps provided below.
Step 1 - Set...
03-02-2023 Introduction This script exports to CSV a complete list of the front-end dependencies for each ElastiCube. It provides information about whether an ElastiCube is used for data security, hierarchie...
03-02-2023 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 ...
03-02-2023 Note: Sisense's default ElastiCube Server Console configuration is optimally tuned for ElastiCube and dashboard performance. It is generally not recommended to change these settings (except for Defau...
03-02-2023 Sisense supports floating-point numbers (IEEE 754 standard) and allows you to perform an arithmetic calculation on these numbers.
Floating-point numbers suffer from a loss of precision when represe...
03-02-2023
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 dashboa...
03-02-2023 Analytical Need There are many cases where our data comes in with different granularity levels. For instance, Actual vs. Target where the actuals are at the product level and the targets are pe...
03-02-2023