Knowledge Base

Ensuring Elasticube is in Sync with Data Source (Deletion & Updates in Accumulate Build)

Capturing accurate business transactions is imperative in understanding business operations. If data is constantly changing, such as being deleted or updated, how do you ensure your Elasticube is in sync with your data source? Depending on the use ...

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

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

Fiscal Year Adjustments

Analytical Need Customer's fiscal year does not comply with the Georgian 12-month calendar and starts on a different date than January 1st. Example: Customer’s fiscal year is from April 1st to March 31. This means that April should be flagged as...

Market Basket Analysis

Analytical Need Market Basket Analysis is a data mining technique that is widely used to identify consumer patterns, such as which items are purchased together, or how the purchase of one item affects the likelihood of another item being purchased. ...

Data Relationships: Introduction to a Many-to-Many

A relationship between tables specifies the field/s which the 2 tables have in common. In Sisense, we create relationships between tables in the ElastiCube. Poorly modeled data relationships can lead to one or more of the following: Complex data se...

Date Dimension File

Analytical NeedAnalyzing information by date can be very useful, but not every source data set provides enough information to do this kind of analysis.Modeling ChallengeWe will need to import a date table, which will act as a reference for all time q...

Calculating Business Days Difference Between Two Dates

Introduction This article demonstrates how to avoid counting weekends and holidays when calculating the difference between two dates. Example - Average Shipping Time in Business Days Steps In order to ‘subtract’ two dates and avoid counting the wee...

Days, Hours, Minutes, and Seconds Drill Down

Introduction In this post we'll learn how to create a drill down hierarchy for Days-->Hours-->Minutes-->Seconds. A general quick solution, in case you need the drill mostly for pivot table visualizations, would be to use the ElastiCube to model addi...

LAG / LEAD Functions

Question LAG & LEAD Functions are functions that give access to multiple rows within a table, without the need for a self-join. The LAG function is used to access data from a previous row, while the LEAD function is used to return data from rows fur...

Postgres vs. MongoDB for Storing JSON Data — Which Should You Choose?

In the past, the Postgres vs. MongoDB debate looked like this: you had Postgres on one side, able to handle SQL (and later NoSQL) data, but not JSON. On the other, you had purpose-built database management systems (DBMS) — like MongoDB, which was de...

Benefits of JSON support in Postgres

The promise of Postgres JSON JSON support is the most interesting new Postgres feature of the last few years. It relaxes the primary constraint of SQL databases — the rigid schema structure — by letting you store semi-structured data in your tables ...

Sisense Community

Enable/disable field suggestions in the NLQ (Simple Ask)

Knowledge Base Articles