Analytical Need In a dashboard, we wish to analyze how our entities (sales, inventory, tickets etc.) behave and break them by several categories. However, not all entities share the same categories. We wish to avoid a situation in which selecting...
In order to generate a profit and loss report from the QuickBooks Desktop Connector, you will need the following tables. AccountCustom Profit & Loss Detail The Account table is a standard table available with the CData connector, while the custom ta...
DescriptionA common visualization is a comparison between personal KPIs and the rest of the team KPI averages. The main challenge is when applying a security configuration, the other users’ data is filtered out Example A typical Elasticube for sales ...
Data is a beautiful mess. As data heroes, we spot the mess and get rid of it to highlight the beauty. Here are a couple useful tricks to detect incorrect data. We will assume a table that describes the number of meows made by each cat in each box, o...
Question: When an elasticube is created in desktop version of elasticube manager, only a .ecube file gets created, where as when an elasticube is created in web version of elasticube manager, a folder with the elasticube name is created that contain...
Question: In instances where tables within SQL Server contain JSON objects within a column you can use the import sql query editor feature in Sisense to flatten these objects into individual fields. For example: Can be turned into: Solution: T...
Question: A relatively common database design strategy is to have a tag column with an arbitrary number of tagsHere is an example in which we look at numbers between 1 and 10 and tag them as even, odd, perfect, or parts of the Fibonacci sequence:Now ...
Question: For a specific industry, like Education, even though the number of days is roughly the same every year, each academic year can start and end on different dates. The usual way of calculating YTD wouldn't work for this requirements because s...
Question: When using "Accumulate By" builds (see below), Sisense will only import "new" records based on a selected INT or DATETIME index field - if values in the source DB exceed the maximum value of that index as of the previous ElastiCube build, t...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-Many Data Relationships: Check Type of relationshipData Relationships: ...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-ManyData Relationships: Check Type of relationshipData Relationships: O...
The Problem Date information from the source is represented as an integer, with the format YYYYMMDD. We need the information to be represented as a date-time data type in Sisense. The Solution This will utilize a custom field to convert the valu...
For general information on types of data relationships, potential complications and how to resolve them, see the following articles: Data Relationships: Introduction to Many-to-ManyData Relationships: Check Type of relationship (You are here)Data R...
Analytical Need Using the lookup function to import data from one table to enhance another, based on specific conditions or filters. This might be required if we wish to import attributes from a table which is not unique. For example, a transpose...
This article outlines how to create a date table that flags whether or not a particular date is within a particular range, based off of the current date. For example, if today is the 100th day of the year, we may want to analyze information for the f...
This post has become outdated. You can find guidance on choosing a data model on our documentation site here. https://docs.sisense.com/main/SisenseLinux/choosing-the-right-data-model.htm Introduction Customers often run into the question of which d...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Linux | ElastiCube Local files systemSisense application utilizes MonetDB to write raw data into Elasticubes (commonly referred to as EC or cube). Why does this happen? This allows Sisense to query the data from itself rather than sending a query bac...
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 ...
One of the recent questions I had to answer focused on analyzing text data. How have you solved this problem in the past? I was not sure how to create an optimized solution for both efficiency and completeness. My solution I came up with used a joi...
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. ...
