This post will outline the different files used to create ElastiCube data, and the data flow resulting from these files.
Understanding the underlying data elements of SiSense can help a user import, export, and migrate SiSense elasticubes, as well as diagnose basic data availability issues.
An ecube file is used by ElastiCube Manager, and defines the tables and relationships (the schema) of an elasticube, along with the connection information for the data source.
Using .ecube Files
When you open an ecube file in ElasticubeManager, you won’t be able to preview any of the data, because the ecube file does not contain any of the actual data, so the ElastiCube will have to be built in order to see the data. An ecube that hasn't been built will have the following icon at the top:
After a successful build, the icon at the top of the page changes to this:
After a build, you can preview the data in the ElastiCube Manager, but the ecube file still only contains schema information. When the ElastiCube is built, data is populated into the ElastiCubeData folder.
Creating .ecube Files
From within the ElastiCube Manager, click File->Save Elasticube as... .
This is a folder that contains the data, schema, and configuration information for an Elasticube. This is the data that powers the dashboard. A user will not directly edit any of the information contained in the folder. The data in this folder is only changed during a build. With the default installation, each ElastiCube will have a folder here:
(Note- ProgramData is normally a hidden folder).
A folder will exist for each ElastiCube that’s been created. The initial installation of SiSense comes with 3 sample ElastiCubes- Sample ECommerce, Sample Healthcare, and Sample Lead Generation. Each of these ElastiCubes will have their own folder in the ElastiCubeData Folder.
Attach ElastiCube Folder
In the Server Console, a user can create an ElastiCube by attaching an ElastiCubeData folder. Loading an ElastiCube this way does not require any data to be transferred, since the data already exists in the folder that's being attached. To attach a folder, click the Attach ElastiCube Folder button in the upper right hand corner of the Server Console:
After the folder is attached, users can open the ElastiCube by clicking Edit, which will open it up in ElastiCube Manager.
An ecdata file is a compressed file that contains all of the information contained in an ElastiCubeData folder. It is used by the SiSense Server Console to build a new ElastiCube.
Using .ecdata Files
To import an .ecdata file and create a new ElastiCube, open the SiSense Server Console, and click the import ECDATA file button, which is in the upper right of the Server Console window:
When the ecdata file is imported a new folder is created in the ElastiCubeData folder. This contains an uncompressed version of what’s contained in the ecdata file, much like unzipping a file.
After it finishes importing, open the ElastiCube in the Server Console, and click ‘Edit’. This will open the ElastiCube Manager, and you can modify the ElastiCube from there.
Creating .ecdata Files
To create an ecdata file, open the SiSense Server Console, pick the ElastiCube, stop the ElastiCube, and click export. Essentially, the ElastiCubeData folder containing the ElastiCube you chose will be copied and compressed into an ecdata file, much like creating a zip file.
Data Flow Diagram
The following diagram shows the two different data flows for populating ElastiCubeData with the files described above.