Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
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
  • 53 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
  • 243 Views
  • 0 comments
  • 0 kudos

Changing Elasticube Owner

IntroductionThis tutorial describes the steps to modify the owner of an Elasticube, a crucial task for managing your data efficiently. By following these instructions, you'll be able to transition ownership from one user to another seamlessly.Prerequ...

vsolodkyi by Sisense Team Member
  • 375 Views
  • 0 comments
  • 1 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
  • 1289 Views
  • 0 comments
  • 0 kudos

Generating a HAR file for troubleshooting Sisense

When troubleshooting complex issues in Sisense such as PDF export, widget not loading etc., it is sometimes necessary for our support team to obtain additional information about the network requests that are generated in your browser while an issue o...

intapiuser by Community Team Member
  • 4305 Views
  • 1 comments
  • 1 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
  • 1240 Views
  • 0 comments
  • 0 kudos

Exploring ElastiCube data with ODBC connection to R

Problem You want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have. Solution Installing the Sisense ODBC drive...

intapiuser by Community Team Member
  • 277 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
  • 1913 Views
  • 0 comments
  • 0 kudos

Dealing With Missing Values In Python

Python pandas offers a few different options to deal with null values. Based on your dataset, there will likely be a preferred method to account for null values that 1. accurately represents your data and 2. preserves a decent sample size for rigorou...

intapiuser by Community Team Member
  • 207 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
  • 628 Views
  • 0 comments
  • 0 kudos

Python 3 Script to Import Many ElastiCubes

Introduction The attached script is intended to loop through all ElastiCube folders in your ElastiCubeData folder and import them. Business Case This solution has a couple of possible use cases. The first is to facilitate migrating a Sisense environm...

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

Querying the Sisense Elasticube with Python

This article will cover two methods you can use to connect Python to the Elasticube. Method 1: Using ODBCMethod 2: Using the REST API Method 1: Connect to the EC with ODBC Download Sisense ODBC This method will require you to download the ODBC driver...

intapiuser by Community Team Member
  • 643 Views
  • 1 comments
  • 0 kudos

QuickBooks DESKTOP - Generating Tables For Profit & Loss Report

In order to generate a profit and loss report from the QuickBooks Desktop Connector, you will need the following tables. Account Custom Profit & Loss Detail The Account table is a standard table available with the CData connector, while the custom ta...

intapiuser by Community Team Member
  • 212 Views
  • 0 comments
  • 0 kudos
Labels
Featured Article
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: