Web MDX Query Builder & SSAS Cube Viewer

Browse Microsoft SQL Server Analysis Services (SSAS) Multidimensional cubes in a pure web browser. Build complex MDX queries visually, slice and dice parent-child hierarchies, evaluate calculated members, and deliver high-speed ad-hoc OLAP pivot tables.

Pure Web-Based SSAS Cube Exploration with Zero Client Footprint

The Kyubit Web MDX Cube Viewer brings enterprise-grade OLAP navigation directly into your browser. Engineered specifically for data engineers, BI specialists, and business analysts, Kyubit transforms complex SSAS Multidimensional cubes into interactive, drag-and-drop web pivot tables, dynamic drill-down grids, and rich data visualizations without requiring Microsoft Excel or heavy desktop clients.

Seamlessly interact with dimensions, attribute hierarchies, levels, measure groups, and KPIs. Whether writing custom MultiDimensional eXpressions (MDX) or constructing queries through the visual designer, Kyubit delivers instant query response times over high-scale analytical databases.

Kyubit Web MDX Query Builder and SSAS Multidimensional Cube Viewer Interface

Master SSAS Cubes & MDX in 3 Intuitive Steps

Connect, construct queries, and publish governed OLAP reports across your organization.

1

1. Connect Analysis Services

Directly authenticate against SSAS Multidimensional and Tabular instances with full Active Directory security integration.

2

2. Build MDX Visually

Drag measures to columns and hierarchies to rows, filter dimension members, or write custom MDX queries and calculated measures.

3

3. Analyze, Share & Export

Execute drill-through actions, export formatted pivot tables to Excel or PDF, and embed live OLAP reports into corporate portals.

Eliminate Excel Dependency for SSAS Cube Analytics

While Microsoft Excel remains common for ad-hoc exploration, managing workbook proliferation, broken data links, and inconsistent local MDX queries creates governance silos. Kyubit delivers a standardized, centralized web environment for browsing enterprise cubes.

All query logic, calculated members, named sets, and custom views are saved centrally. Users across any department access consistent definitions, live server-side calculations, and sub-second grid responses on any web-enabled device.

  • Zero Desktop Installations: Pure HTML5 web interface accessible anywhere.
  • Full MDX Flexibility: Seamless toggle between visual drag-and-drop and raw MDX script editing.
  • Direct Analysis Services Execution: Optimized server-side query processing for big data volumes.
Kyubit Web MDX SSAS Cube Viewer Architecture and Query Pipeline

Advanced MDX Querying & Cube Exploration

Harness the full analytical power of your SSAS Multidimensional data models.

Visual Drag-and-Drop MDX Query Designer

Explore multidimensional metadata with an intuitive tree explorer. Effortlessly drag Measures, Dimensions, and User Hierarchies onto the Rows, Columns, and Slicers axes. Kyubit dynamically translates your visual layout into highly optimized MDX queries behind the scenes.

Apply instant sorting, top/bottom filters, isolate specific members, and collapse or expand hierarchical tree nodes without writing a single line of script.

Visual Drag-and-Drop MDX Query Builder with Hierarchies and Measures
Advanced In-Browser MDX Script Editor with Syntax Highlighting and Calculation Builder

In-Browser MDX Script Editor & Calculated Members

For power users and data engineers, Kyubit provides a robust in-browser MDX Script Editor. Write, test, and execute raw multi-dimensional statements, non-empty cross-joins, and complex sub-cube selections.

Define session-based Calculated Measures (such as custom growth ratios, percentage of parent, and rolling variances) and custom Named Sets directly inside the web interface without altering the underlying SSAS cube schema.

Dynamic Drill-Down, Drill-Through & Decomposition

Uncover root-cause drivers behind aggregated metrics. Kyubit allows analysts to perform interactive drill-down navigation through nested levels and multi-level parent-child structures.

Need the underlying transactional records? Trigger MDX Drill-Through actions to inspect granular fact-table rows in an instant web grid. Combine with Multilevel Decomposition Trees to break down business metrics across custom dimension paths effortlessly.

SSAS Multidimensional Cube Drillthrough and Decomposition Analysis
MDX Automated Time Intelligence and High Speed Query Caching

Automated Time Intelligence & Asynchronous Query Execution

Accelerate periodic analysis with built-in OLAP Time Intelligence. Instantly apply Year-over-Year (YoY), Month-to-Date (MTD), Year-to-Date (YTD), and Parallel Period calculations to any measure without manual MDX expression coding.

Kyubit's asynchronous execution architecture processes resource-heavy MDX queries in the background, preventing UI lockup while maintaining responsive browser interaction even when querying multi-gigabyte cubes.

Why Kyubit is the Premier Web MDX Cube Viewer

Built specifically for high-performance Microsoft Analysis Services environments.

Native SSAS Multidimensional Support

Full-spectrum support for cubes, measure groups, attribute hierarchies, parent-child dimensions, and standard SSAS KPIs.

Visual Builder + Raw MDX Mode

Empower business users with drag-and-drop pivot tables while giving developers an enterprise code editor for custom MDX statements.

100% Governed & On-Premise

Host entirely inside your secure network perimeter with seamless Windows Authentication, Active Directory mapping, and SSAS roles.

Transform MDX Queries into Enterprise Dashboards & Reports

Your SSAS cubes contain your company's most valuable analytical metrics. Kyubit makes it effortless to transform ad-hoc MDX queries into scheduled business reports, interactive scorecards, and executive visual dashboards.

Build Interactive BI Dashboards from SSAS MDX Queries

Interactive Analytical Dashboards

Combine multiple MDX queries into rich executive dashboards with synchronised dimension filters.

SSAS Multidimensional Cube KPI Scorecards and Goal Tracking

KPI Scorecards & Goal Tracking

Track cube-defined KPIs, trend statuses, and historical thresholds with automated alert notifications.

Automated Scheduled Delivery for SSAS Multidimensional OLAP Reports

Automated Report Distribution

Schedule MDX query results and pivot analyses to be delivered to user inboxes in Excel or PDF formats.

Technical Specifications & Compatibility

Analysis Services Support Microsoft SQL Server Analysis Services (SSAS) Multidimensional & Tabular (2008, 2012, 2014, 2016, 2017, 2019, 2022+) and Azure Analysis Services (AAS)
MDX Engine & Query Features Visual Drag-and-Drop Designer, Syntax-Highlighted Raw MDX Code Editor, Calculated Measures, Custom Named Sets, Sub-Cube Slicers, Non-Empty Cross-Joins
Navigation & Exploration Multi-level Drill-Down / Drill-Up, MDX Drill-Through to Fact Records, Multilevel Decomposition Trees, Parent-Child Hierarchies, Automated Time Intelligence (YoY, MTD, YTD)
Security & Access Control Full Active Directory integration, Windows Authentication, SSAS Role-Based Security, Dimension & Cell-Level Security, Kyubit User Roles (Admin, Creator, Visitor)
Export & Interoperability Excel (.xlsx) formatted export with hierarchy preservation, PDF generation, RESTful embedding API, and iFrame portal integration
Deployment Requirements 100% On-Premise IIS Web Server (Windows Server) or Private Cloud VMs (Azure, AWS, GCP). No client-side installations.

Frequently Asked Questions

Do end-users need client-side installations or Excel add-ins to browse SSAS cubes?

No. Kyubit is a zero-footprint web application that runs directly in any modern browser (Chrome, Microsoft Edge, Firefox, Safari). There is no requirement for Excel add-ins, ActiveX controls, or local desktop utilities.

Does Kyubit support custom MDX scripts and calculated members?

Yes. Beyond visual drag-and-drop querying, Kyubit includes an advanced in-browser MDX script editor with syntax highlighting, allowing BI developers to write raw MDX, define custom calculated measures, and apply complex set functions without modifying the physical cube.

How does Kyubit handle SSAS Cube security and Active Directory roles?

Kyubit integrates natively with Microsoft Active Directory and SSAS security architectures, honoring dimension-level security, cell-level security, and role-based permissions configured on your Analysis Services instance.

Can we perform Drill-Through to underlying transactional fact records?

Yes. Kyubit supports dynamic MDX drill-through actions. Users can click any aggregated cell in an OLAP pivot table to retrieve the granular transactional records defined by the cube's drill-through columns.

Can we export MDX query results and pivot analyses to Excel or PDF?

Yes. Any OLAP grid, pivot table, or visual chart can be exported to Excel (preserving hierarchical layouts and cell formatting) or high-resolution PDF documents for scheduled enterprise distribution.

Start Exploring SSAS Cubes in Your Browser Today

Download Kyubit BI Tools with a 30-day full evaluation. Experience visual MDX query building, hierarchical OLAP navigation, and browser-based pivot analysis on your own SSAS cubes.

Download Free Trial or Read the User Manual

Explore Related OLAP & SSAS Capabilities