Lably
Skip to content

Cubes (OLAP server)

  • 7 min read
  • 5 chapters

Related on Lably

Through Open-source software, Python (programming language) and Expression (mathematics)

Lab · Class 6–12AI & Python Builds (Medha AI)Lab · Class 9–11Python SandboxLab · Class 3–12Coding in Python (Python Lab)Lab · Class 11Python for ML — NumPy, Pandas, scikit-learn

Cubes provides to an analyst or any application end-user "understandable and natural way of reporting using concept of data Cubes – multidimensional data objects".

Cubes was first publicly released in March 2011. The project was originally developed for Public Procurements of Slovakia. Cubes 1.0 was released in September 2014 and presented on the PyData Conference in New York

Features

  • OLAP and aggregated browsing (default is ROLAP)
  • logical model of OLAP cubes in JSON or provided from external sources
  • hierarchical dimensions (attributes that have hierarchical dependencies, such as category-subcategory or country-region)
  • multiple hierarchies in a dimension
  • arithmetic expressions for computing derived measures and aggregates
  • localizable metadata and data

Cubes is capable of handling large amounts of data and complex queries. According to a review by TechTarget, Cubes can handle "data volumes in the hundreds of millions of rows" and "complex queries and calculations that require multi-level aggregations and dynamic subsetting." Additionally, the review notes that Cubes is well-suited for smaller organizations or teams that don't require the complexity and scalability of enterprise-level OLAP solutions.

Sign in to keep reading

4 more chapters are free with a Lably account.

More in Computing and communication

ISBNUnique numeric book identifier since 1970X (social network)American social networking serviceWayback MachineDigital archive by the Internet ArchivePython (programming language)General-purpose programming languageMacOSOperating system for Apple computersUnicodeCharacter encoding standard