How We Make BI Work on Big Data

A Modern Architecture for Business Intelligence

The Atscale Intelligence Platform is designed from the ground up to support key requirements of modern big data analytics.

We support hybrid data access to the most common big data platforms and provide open data interfaces (SQL, MDX, or API) to virtually any analytics front-end.  AtScale’s self-tuning optimization engine ensures interactive performance for data consumers on even the largest data sets.

Designed for semantic model management AtScale provides an easy-to-use interface to model virtual cubes, while system metadata maintains a graph of data lineage all the way to the underlying raw data.  With native support for complex business analytics, including parallel periods, multi-fact models, and complex MDX calculations, AtScale platform can support your most complex OLAP use cases.

"AtScale’s no-ETL and no-data movement approach is simply a gamechanger. This application should be required for anyone who wants to do BI on Hadoop."

- Kevin Johnson CEO, Ebates

Business Intelligence TOOLS &  DRIVERS

Standard connection to your Favorite BI Tools: AtScale supports current business processes by allowing your analysts to use the BI tools they already know and love, but at sub-second speeds on live Big Data.

  • Use Excel and new generation viz tools like Tableau or Qlik
  • Leverage your traditional BI tools like Cognos and BOBJ
  • Connect with standard BI and Big Data drivers you already use
  • Choose to use API, JDBC/ODBC, OLE DB, or XMLA

Learn more in the AtScale Datasheet


Common Metadata Repository is a BI Force Multiplier: With a single semantic layer and robust metadata and lineage tracking, AtScale enables business logic to exist directly on top of the big data cluster and does not require the development of tool-specific, or siloed, semantics.  As a result, the AtScale semantic layer (referred to as a Virtual Cube) can be used by virtually any enterprise BI tool.

  • Share business definitions and logic across any BI tool
  • Ensure shared security policies for all users
  • Track data lineage and audit usage across all data assets

Read our Semantic Layer paper


Multi-Dimensional Queries on Big Data Made Simple: While big data platforms excel at low-cost distributed storage and parallel data processing, interactive support for BI-style queries remains a challenge.  Additionally, multi-dimensional analytical queries often demand complex OLAP-style calculations and functions.  AtScale’s dimensional calculation engine enables these complex business queries directly on top of your big data platform.

  • Multi-pass query support
  • Semi-additive metrics like first & last child
  • Multi-level metrics, such as plan vs. actual
  • Atomic drill-through to record level data

Read more on Multi-level Metrics


Smart Query Optimization:  With AtScale your queries run fast on Big Data because we automatically generate and maintain smart aggregates. Advanced machine-learning algorithms optimize your BI query workloads on-demand to deliver the performance you and your users expect from BI, multidimensional and OLAP systems.

  • Dynamic aggregate creation
  • Manual aggregate override Option
  • Easy aggregate maintenance
  • Support for SQL or MDX queries


Abstracting Dimensionality into Big Data: AtScale’s patented approach to data abstraction supports the creation of complex, multidimensional analytical models on top of flat files, relational data structures, or semi-structured data.  This capability is unique in the market and is at the core of the AtScale architecture.  With this approach, enterprises are now able to model the most complex business structures for analysis – directly on top of the data in their big data platforms.

  • Dimensions with multiple hierarchies
  • Support for multi-fact models
  • Complex calculated metrics
  • Pre-, Post-, and Mid-query aggregation functions
  • Cost-optimized attribute engine

Learn how we handle Multi-Fact Models


Enterprise-Level Access Control, Monitoring, and Management: AtScale works with Enterprise Big Data deployments to offer data governance and security for the data residing in Hadoop and other Big Data Platforms. Administrators have complete control over who can access which data across Big Data in the Enterprise.

  • Role-Based Access Control
  • Pluggable SASL Authentication
  • User and Query Audit Trails
  • Delegated Authorization Support
  • Support for Multiple Hadoop and Big Data Environments

Learn more about AtScale Security


Easy, Intuitive BI Model and Cube Design:  Business users get to interact directly with data in Hadoop an other big data systems via the AtScale Design Center web app. Data analysts can design virtual analytical (aka OLAP) cubes using familiar workflows and intuitive drag-and-drop interactions.

  • Intuitive OLAP Modeling Concepts
  • Rich Multi-Dimensional Support
  • Collaborative Cube Design and Lifecycle Management
  • Fast, Scalable Distinct Counts
  • ‘No ETL’ Virtual Data Abstraction Layer

Check our our Resources to learn more


AtScale delivers an advanced set of features you won’t find together in one solution, anywhere else.

Drag and Drop Modeling

Built for the business analyst, drag and drop enables rapid cube design & deployment. Build sophisticated models without writing any code.

Multi-Tenancy Support

Supports multiple clusters, multiple environments, and multi-tenant data; significantly lowering IT maintenance costs.

Multi-User Environment

Cube development is a team sport - AtScale allows for realtime cube collaboration, with snapshot and restore functionality to easily track changes.

Security Integration

Integrates with LDAP and Active Directory, supports kerberos, and enables delegated authorization for data security that leverages existing infrastructure.

Works with SQL and MDX

AtScale is the only BI platform that supports both SQL and MDX queries against the same multidimensional model.

Hierarchy Support

Hierarchical analysis is core to any BI application, and AtScale delivers rich support including multiple hierarchies, role-playing, and sharing.

Multi-fact Models

Analyzing metrics across multiple facts is core to most advanced analysis - AtScale supports even the most complex multi-fact models.

Row Level Security

Make sure that the right users see the right data with support for dynamic user-to-attribute security policies.

Predictive Aggregates

Statistical models predict optimized queries even before a user executes it, while smart algorithms keep aggregates up-to-date with zero human intervention.

Many to Many Support

Many-to-Many models, a requirement for any advanced BI platform, are supported in to AtScale.

Incremental Updates

No need to rescan your entire data to update aggregates. Incremental updates look only at the most recent partitions of data.

Snapshots and Versioning

Built by developers for developers, we ensure that you can restore and dif any version of your model.