Knowledge
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Export of large cubes

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...

vsolodkyi_0-1705532406180.png vsolodkyi_1-1705532406119.png
vsolodkyi by Sisense Team Member
  • 110 Views
  • 0 comments
  • 0 kudos

Restoring missing connector

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 a...

vsolodkyi_0-1698425692352.png vsolodkyi_1-1698425692154.png
vsolodkyi by Sisense Team Member
  • 300 Views
  • 0 comments
  • 0 kudos

How to Update Live Model Dataset Configuration Through API Call

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 Da...

jcordell_0-1683646134853.png jcordell_1-1683646164761.png jcordell_2-1683646225605.png
ashprukh by Sisense Team Member
  • 415 Views
  • 0 comments
  • 0 kudos

Reading Multiple Excel Files into Sisense Data Model

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 fold...

Vicki19_1-1682719869772.png
Vicki19 by Sisense Team Member
  • 225 Views
  • 0 comments
  • 0 kudos

Elasticube Modeling With Data Security: Best Practices

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 ...

intapiuser by Community Team Member
  • 1466 Views
  • 0 comments
  • 0 kudos

Key Table: Store data relationships between primary key values

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...

intapiuser by Community Team Member
  • 1390 Views
  • 0 comments
  • 0 kudos

Data Denormalization for Faster Dashboard Query Response

Introduction This post will explain how to denormalize your ElastiCube schema in order to get faster query response in SiSense Web. Purpose/Benefit Denormalization of data is used to reduce the query response time in SiSense Web. It is most useful fo...

intapiuser by Community Team Member
  • 403 Views
  • 0 comments
  • 0 kudos

Data Transpose Guide

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...

intapiuser by Community Team Member
  • 2018 Views
  • 0 comments
  • 0 kudos

Export Tables To CSV Post Plugin

Download Zip: ExportTablesToCSVPostPlugin Files included: ectools.zip ectools_sisense_ver<6.4.zip - (only for versions 6.4 and below) python-2.7.11.amd64.msi config_example.txt EC_export.dll This post explains how to install and configure the post pl...

intapiuser by Community Team Member
  • 671 Views
  • 0 comments
  • 0 kudos

What is the difference between .ecdata and .ecube data files?

Both .ecdata and .ecube files are used to make backups of data and transfer data between ElastiCube Servers. Your data model or schema is saved in an ecube file. ecube files contain the schema and the data connection settings required for building yo...

intapiuser by Community Team Member
  • 257 Views
  • 0 comments
  • 0 kudos

Alert on a M2M Risk

Introduction This article describes how to enable an alert* when there is a risk of Many-To-Many relationship (M2M) between two or more tables. * This implementation involve the use of Pulse and it's supported in Sisense v6.5 and above. Motivation Al...

intapiuser by Community Team Member
  • 359 Views
  • 0 comments
  • 0 kudos

Not all dimensions relate to all facts

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 a v...

intapiuser by Community Team Member
  • 817 Views
  • 0 comments
  • 0 kudos

How To Create Elasticube Using Api

Question: Which api should i use to create my elasticube? Solution: At the moment, REST API for creating Datamodels is only available on Sisense for Linux, starting from version L8.0.2. This capability should become available on the Windows version a...

intapiuser by Community Team Member
  • 354 Views
  • 0 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: