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

How to export .ecdata and .dash files

IntroductionThis 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/BenefitsThe .ecdata file contains both the data and the logic s...

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

How to connect to mongodb with a password protected user

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

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

Duplicate Drill Hierarchies for Another ElastiCube

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

intapiuser by Community Team Member
  • 90 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
  • 108 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
  • 613 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 sen...

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

Schedule Download Of SQL API Queries To CSV

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

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

Change The Location Of The ElastiCube Data Folders

Introduction This article explains how to change the location of the ElastiCube data folder. By default, ElastiCubes will be stored in C:\ProgramData\Sisense\PrismServer\ElastiCubeData. Many customers prefer to use a secondary drive to store ElastiCu...

intapiuser by Community Team Member
  • 305 Views
  • 2 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 Pu...

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

Alert on a M2M Risk

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

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

Managing Customers with Varying Fiscal Year Start Dates

Analytical Need If a dataset contains customer data for various customers and we want to compare quarterly data across or within customers, we can use the time functions within Sisense. If a fiscal calendar is the same for the entire set of customers...

intapiuser by Community Team Member
  • 114 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 community@sisense.com