Reading multiple Excel files into Sisense data model Introduction: If you are migrating from Windows to a Sisense Linux-hosted solution, on the Sisense Windows machine you may use an SFTP client that moves Excel files placed in a remote server's fol...
Creating a Year-Over-Year Chart in Sisense Summary This article addresses the issue of creating a year-over-year comparing chart in Sisense that shows a Key Performance Indicator (KPI) for the current calendar year against the previous calendar year...
GIT Instruction How To In order to migrate Sisense assets between environments, please follow the below steps: Step to add your assets to the GIT repository: 1. Create a project by adding a project name along with a default branch name (such as mas...
Limiting Date Range Filters in Sisense Dashboards Use Case Overview Wide date ranges in Sisense dashboards can lead to performance issues, especially when using live models or querying large datasets. For live data models, large queries increase cost...
Leveraging Sisense Notebooks with Compose SDK In today’s developer ecosystem, delivering a tailored creator experience is essential for success, especially when integrating analytics into customer-facing applications. Many existing solutions offer a...
Resolving Issues with Updating EC2EC Passwords in Elasticube Connections Summary This article addresses the issue of updating EC2EC (Elasticube to Elasticube) passwords in the context of employee off-boarding or password changes. Specifically, it c...
Connecting Sisense Git Version Control with Bitbucket Summary This article addresses common steps needed when establishing a connection between Sisense Git version control and Bitbucket. It provides step-by-step instructions on how to generate and u...
Troubleshooting "BBP Error 1551" in Sisense ElastiCube Builds Summary This article provides a comprehensive guide to troubleshooting the "BBP error 1551" that occurs during the build process of ElastiCubes in the Sisense Windows environment. The err...
Automating Dashboard Ownership Transfer in Sisense with UserReplaceTool Managing and deleting user accounts in Sisense can create manual processes when users leave an organization or change roles. A frequent issue is the reassignment of dashboar...
Advanced Pivot Widget Scripting - Combining Custom JAQL and the Pivot 2.0 API While the Pivot Table Widget Type is a highly customizable and flexible Sisense widget for representing data in tabular form, certain use cases may be best achieved through...
Network Error: Pending Operation: Update Model Layout You receive the following alert: Add data Network error: Response not successful: Received status code 400 Pending operation: Update model layout during the process of updating the table quer...
Restoring missing connector Introduction Sometimes connectors can go missing for some reason, leading to a breakdown in data connectivity. Restoring these connectors is crucial to maintaining a smooth data flow within your Sisense environment. This...
IntroductionThis tutorial describes exporting large cubes with data (*.sdata) - more than 2 GB using the Sisnese CLI Commands.PrerequisitesSometimes you need to export from Sisense large cubes - more than 2GB but you cannot do it by using the Sisense...
As Sisense currently supports daily data, in the following article we will demonstrate how to include time in Sisense Web widgets that is present in DateTime fields. In order to display time format along with date we would Represent DateTime field ...
Based on the business requirements summary you've created in the previous step, you can now design the high-level overview of your BI Solution. This step aims to translate the business strategy into operational terms and associate it with the requir...
Introduction The following article discusses a dashboard's (high-level) development cycle. It breaks the process into easy measurable steps that start from the initial KPI planning all the way to maintaining and adjusting your end product. Table of C...
Elevate Your Data Product’s Quality with Streamlined Version Control Leveraging the Sisense Git Integration! In today's CI/CD ecosystems, efficient asset migration from development to production environments is crucial for delivering high-qualit...
How to Update Live Model Dataset Configuration Through API Call In this article, we'll discuss how we can update Live Model query settings through API calls. Dataset resource represents a single data source of your Datamodel - for example, if your D...
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 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 ...
