This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
on - edited on by
DRay
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 logic structure of the ElastiCube model, the .dash file contains the widgets structure logic and the relation to relevant ElastiCube.
Exporting the .ecdata and .dash files will allow you to easily import the files and run your ElastiCube/Dashboard environment. Please note that security settings and users are stored on MongoDB and will not be stored within these files.
To avoid confusion between .ecdata and .ecube files please see the following post:
Steps
exporting .ecdata (.sdata for Linux)
Windows:
Step 1 - Open the ElastiCube Manager, 'Servers' and choose 'Manage Servers' to open Sisense Server Console
Step 2 - Stop the relevant ElastiCube and Choose Export
This will open a window allowing you to choose the location of the .ecdata file
Note: in case your ElastiCube is very large, export can take a while to complete. We recommend stopping your Web server (IIS / IIS Express) to avoid the ElastiCube from automatically starting during this time, as a result of incoming queries.
Linux:
Use Sisense CLI to export the .sdata file:
The command export should be used.
Example:
si elasticubes export -name MyCube -path \"/opt/path/to/NameOfCube\" -file cubeName.sdata
Another option to export - using v2 of REST API:
To get the ID of the model, use another API call:
Or to do the same from GUI:
- Open the Data page.
- For the relevant ElastiCube, select
> Export Model. - Select to export the model schema and the data.
- Click Export.
exporting .dash
It will be the same for Windows and Linux.
Open Sisense web, click the more options of the relevant dashboard and choose Export Dashboard
The dashboard will be downloaded to your local drive.
Creating a Sample Set of your ElastiCube
It will be the same for Windows and Linux.
If the .ecdata file is too large to transfer, you might want to create a smaller ElastiCube sample data.
To do so, duplicate the model in order to not to impact your dashboards:
And build the duplicated model with a limited amount of rows:
