1. How do I connect to data?
Connecting to data with Elasticube Manager is very easy, and it supports many data source types: Excel files, databases, and even web services hosted in the cloud. Take a look at the left menu in the link below to choose the data source that you want to connect to, and be aware that you don’t need to settle with one data source type, since with SiSense Prism you can mash up data from different sources seamlessly.
2. What is a build?
A build is a process that pulls the data from the sources and prepares it to be used in your dashboards. Before you use the data for the first time and every time that the data changes or you update the Elasticube structure, you need to run a build. See the link below to learn how to import data and build an Elasticube:
3. How do I keep my elasticube updated if my source data changes frequently?
If your data changes frequently, you don’t need to run a build manually to update it, but you can actually automate the process by scheduling the build settings. See the link below to learn how to do so.
4. What if my source data structure changes after a build?
If your source data changes (for example you have a new field or a new table), your current Elasticube will remain unaffected from those changes as long as you don’t make another build. If you want them to impact the Elasticube, you will have to take care of those new fields or tables by adding them to the Elasticube by following the steps in the link below.
5. What is the difference between the Elasticube Manager, the Elasticube Server, and the Elasticube Server Console?
The Elasticube Manager is component of the Prism suite that helps you design the Elasticube (connect to tables, build relationships, etc.), while the Elasticube Server is a component that you will normally not see, and that keeps the Elasticube up and running. If for some reason you need to restart the Elasticube Server, or delete an Elasticube, you can do so with the Elasticube Server Console.
To start the Elasticube Manager, you can do so by clicking on start> all programs> sisense> Prism ElastiCube Manager
To start the Elasticube Server Console, you can do so by clicking on start> all programs> sisense> Prism Server Console
6. What is the difference between .ecdata and .ecube data files?
The Elasticube Manager stores the design of the data schema in a .ecube file. It is not the data itself, but actually a “blueprint” of your data structure and source definitions. The .ecube is the data itself already in the Elasticube. You can notice that .ecube files are very small (a few KBs), whereas .ecube files are sensitively larger (may reach GBs depending on your data).
7. How can I manipulate and organize data in the Elasticube?
You can create custom tables and custom fields using Elasticube. Doing so will allow you to manipulate data and customize it according to your needs without having to touch your source data. The links below explain how to create a full custom table and to add a custom field to existing tables.
8. Can someone access an ElastiCube from another machine?
Yes, you can design an Elasticube that is residing in and deploy it into another machine. To choose the target server, in Elasticube Manager click on Build and then choose the server from the dropdown reading “Build the ElastiCube on”.