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...
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 sets...
What is Data Validation Testing?In addition to QA and UAT Testing, Data validation testing is a critical step to ensure you are going into production with dashboards containing accurate and complete information.This guide describes how to use a sampl...
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...
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 Challenge We will need to import a date table, which will act as a reference for all time...
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...
Analytical NeedMarket 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.One...
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...
The ProblemDate information from the source is represented as a text string, with the format YYYYMMDD. We need the information to be represented as a date-time data type in Sisense.The SolutionThis will utilize a custom field to convert the value. Th...
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...
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 community@sisense.com
