Rules To Live By When Designing An Elasticube A list of recommendations which should be considered when developing an elasticube. Start Small Build your ElastiCube incrementally. Start with only two tables, create an appropriate relationship betw...
This article demonstrates two methods to count the number of days that passed from one event to the other for a specific category (i.e number of days passed between one sale to another by sale code). The preferred way to do this calculation is in a c...
**Please refer to the following article for extended functionality: Performing a Front End Left Join ** This article presents a data modeling based solution that may allow you to create a simple Left join within one certain widget. Custom SQL Table...
ProblemAdvanced formulas can sometimes return wrong results (or no results at all) when combining dimension-affiliated calculations** with dashboard or widget filters based on a second dimension.Certain calculations may include backstage joins betwe...
Analytical NeedThis dimension table keeps every change that has been made. The user wishes to see historical data per the dimension and not just the current state.Example: Transactions per organizational hierarchies, price list, historical currency ...
Analytical Need Often times, you would have the need to support user across the globe that are digesting data from your dashboards. At these scenarios, the timestamp that was recorded and stored in the DB could be different for the users based on...
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...
Analytical Need You have an international user base, some who use the Metric system and others who use the Imperial (US) system. You want to display dashboard values and calculations in the units that the user wants, or perhaps pre-defined based o...
Analytical Need There are many cases when we will want to measure a metric by a different angle or definition. For example, in some cases you would like to allow your end users to analyze average duration of a resource utilization in a different t...
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 customize and optimize their ElastiCube build process.Th...
This document describes how to use a linked SQL Server to execute commands to external data sources (in this case - Netsuite), and create accumulated Transactions Tables with SQL JOBS. Before you Begin Make sure to install the ODBC for your databas...
Forecasting using a macro trend (moving average) and seasonality (seasonal index) is a common way to forecast data into the future. The two components, seasonal index and moving average, are based on prior historical trends. They come together to for...
IntroductionThis article will demonstrate how to quantify on a date axis the availability \ unavailability of products given only the start and end date of each product's availability (See data format in "ProductData,csv" table below).Business CaseVi...
IntroductionThis article explains how to create a custom field which rounds timestamps (Date-Time) up into time buckets. The buckets outlined in this article include every hour on the hour (10:00 AM, 1:00 PM), every hour on the half hour (11:30 AM, ...
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 ...
In this post, we show the formula to calculate the shortest distance between two points using Latitude and Longitude.This calculation can be useful when trying to determine the distance for logistical purposes (ie delivery service, flights, distance ...
IntroductionThis Post Explains how to create a widget hierarchy that includes ‘week of’ as a member of the hierarchy. (Calculates first day of that week)Business CaseAs a business Analyst, I would like to drill down in a Bar Chart with Dated Sales ...
Trend analysis enables users to compare actual totals against measures derived from the data. This will enable users to compare actual results against derived amounts, and even project those amounts into the future. This example will use a simple ave...
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...
Analytical Need There are cases where you wish to know for a certain point in time, how much you have accumulated up until now.This is called Running Sum.Although it is possible to use this in the dashboard, we may need to have the running sum on ea...
Recommended Quick Links
Developers:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
