Managing ElastiCubes

ElastiCubes are a cornerstone of Sisense’s analytics platform, providing a high‑performance, in‑memory data model that enables fast querying and dashboard responsiveness. Proper management of ElastiCubes ensures data accuracy, optimal performance, and flexibility for business users while maintaining security and consistency across the analytics environment. The following topics describe the key tasks, workflows, and best practices for working with ElastiCubes and associated data models:

• Working with ElastiCubes — an overview of creating, refreshing, and querying ElastiCubes; understanding their structure, storage, and caching behavior.

• Importing Data with Custom Queries — how to bring in data using SQL queries or other customized extraction methods for more precise control over data ingestion.

• Using the Model Editor — editing data models directly in the Model Editor, including adding tables, defining relationships, and configuring calculated fields.

• Attaching and Detaching ElastiCube Directories — managing physical storage locations for ElastiCubes to optimize disk usage or migrate data.

• Direct Relations and Hierarchies — defining relationships between tables and handling ragged or unbalanced hierarchies for accurate drill‑down and aggregation in dashboards.

• Duplicating and Exporting Models — how to copy, export, and import models to replicate work, share configurations, or migrate between environments.

• Deleting ElastiCubes and Live Models — safely removing outdated or unused data models while preserving dependent dashboards or assets.

• Changing Connectivity Settings — modifying source connections (database credentials, endpoints, query options) to maintain up-to-date and reliable data access.

• Pre‑ and Post‑Build Plugins — using plugins to customize operations during the build process, such as data validation, transformation, or auditing.

• Creating Data Dictionaries — documenting the contents, metrics, and business logic of your ElastiCubes for governance and user reference.

• Changing the Default Culture — configuring locale, date, and number formatting to match organizational or regional preferences.

• Uploading CSV and Excel Files — adding flat-file data sources to your ElastiCubes for integration with structured datasets.

By mastering these topics, administrators and developers can ensure that ElastiCubes are accurate, performant, and aligned with business requirements — providing end users with reliable and high-speed access to actionable insights. Proper management also lays the foundation for scalability, maintainability, and governance across your Sisense environment.