Designing Cube

This section details the basics of extracting data from different data sources, designing multidimensional objects called cubes, and preparing your data for crosstab, graphs, GeoMap, KPI, tabular, and dashboards. ElegantJ BI supports both real-time and cache cube architecture. There is also an option for aggregation in cache cubes, and user can choose if user wants to perform aggregation for cache cubes at cube level or not. Cache cubes will store indexed, pre-aggregated data along with metadata in the cubes. MDX and Real-time cubes will store only metadata information and will not store any data in the cubes.

Max # records for a cube
Is there any limitation on the maximum number of records for generating a cube? Viz., Maximum size of the cube by design? Ther...
Mon, 19 Sep, 2016 at 9:28 PM
Cube using Different DB servers
Creating Cube using Databases on Different DB Servers :    We can create a DB remote link (or Linked Server) to access DB from one database server ...
Tue, 10 Nov, 2020 at 4:58 PM
Error when rebuilding cube with comments in the cube query
Error when rebuilding cube with comments in the cube query Issue: While rebuilding a cube with comments in the cube query is throwing the below error of ‘...
Mon, 13 Jun, 2022 at 8:01 PM