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 the...
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 betwee...
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 on t...
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 time...
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 database ...
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, 3...
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 schema th...
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 Da...
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...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email [email protected]
Share this page:
