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

Knowledge Base Articles

How to export .ecdata and .dash files

Introduction This forum post will demonstrate how to save your ElastiCube .ecdata file which contains your ElastiCube schema and data, and the .dash file of your desired dashboard. Purpose/Benefits The .ecdata file contains both the data and the logi...

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

Get number of rows in elasticubes

Though there is no direct API endpoint to get the number of rows in an elasticube, there is an endpoint to run SQL directly against a cube. Using PySense, it is straightforward to iterate through all your elasticubes, run SELECT COUNT(*) from each ta...

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

How to connect to mongodb with a password protected user

Introduction If attempting to connect to MongoDB with a user protected password, but you aren't able to connect to the database through the Simba DSN or the connection string and getting the following error: Unable to establish a connection with data...

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

Duplicate Drill Hierarchies for Another ElastiCube

Introduction This article will demonstrate one way to create duplicates of your hierarchies that use a different ElastiCubes. This could be useful if you have several ElastiCubes with the same schema, and you don't want to manually re-create the hier...

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

Some Causes Of Build Failures

One common reason your dashboards may not be working as intended is that your ElastiCube builds are not designed properly. This isn’t a catch-all problem, and though there are multiple reasons why it can occur, the outcome is the same: insights aren’...

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

Export a table from the elasticube to a CSV

* Disclaimer: This works for Windows only. It will work in future with Linux versions as well. Once it does, I will update the post. Sometimes, we need to export a table from the Elasticube to a CSV file. We can then import it to the next build, to s...

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

Schedule Download Of SQL API Queries To CSV

Introduction With the Python script below and the Window Scheduler, you can automate the download of csv files based on queries of the SQL API to the elasticube. This type of process comes in handy when a user needs to download information regularly ...

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

Monitoring Your Builds

Part of having a successful BI tool is having your data refreshed on the time you need it. To ensure your builds are working as expected, you can follow the steps provided below. Step 1 - Setting Up a Build Alert Follow the documentation of Sisense P...

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

Get CSV of ElastiCube Dependencies

IntroductionThis script exports to CSV a complete list of the front-end dependencies for each ElastiCube. It provides information about whether an ElastiCube is used for data security, hierarchies, build alerts, pulse KPIs, or starred formulas. It al...

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

Server Console Preferences & Configuration

Note: Sisense's default ElastiCube Server Console configuration is optimally tuned for ElastiCube and dashboard performance. It is generally not recommended to change these settings (except for Default server data folder and Rserve).This article iden...

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

Floating Precision Limitations

Sisense supports floating-point numbers (IEEE 754 standard) and allows you to perform an arithmetic calculation on these numbers. Floating-point numbers suffer from a loss of precision when represented with a fixed number of bits (e.g., 32-bit or 64-...

intapiuser by Community Team Member
  • 2108 Views
  • 0 comments
  • 1 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: