How to show the year on the widget starting from the beginning of AD till today in a Live model
9Views
0likes
0Comments
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.
15Views
0likes
0Comments
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...
32Views
1like
0Comments
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...
358Views
1like
0Comments
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...
420Views
1like
0Comments
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).
857Views
1like
0Comments
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...
2.6KViews
1like
0Comments
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...
2.4KViews
0likes
1Comment
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...
2.6KViews
0likes
0Comments
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
...
2.8KViews
0likes
0Comments
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...
1KViews
0likes
0Comments
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...
3.4KViews
0likes
0Comments
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 ...
891Views
0likes
0Comments
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...
1.1KViews
0likes
0Comments
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...
548Views
0likes
0Comments
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 ...
925Views
0likes
0Comments
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...
1.7KViews
0likes
0Comments
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...
4.2KViews
1like
0Comments
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...
786Views
0likes
0Comments
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...
1.8KViews
0likes
0Comments