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...
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...
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...
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...
The names of the ECs are often accompanied by mysterious letters that make them hard to read.If you have a need to create a list of ECs with their clear names and the dates when they were last queried, you may follow the following steps:Create a text...
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...
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’...
* 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...
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...
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...
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...
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...
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...
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...
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...
Recommended quick links to assist you in optimizing your community experience:
Need additional support?:
