OpenXMLA

• OpenXMLA is a multidimensional data modeling engine based on XMLA protocol.

Quick Start

Start OpenXMLA service

# Setup Java 8
# ...
# Build project
scripts/build.sh
# Build docker image
scripts/dockerbuild.sh
# Start docker container
docker run --rm -it --name openxmla -p 6068:6068 openxmla:latest

Connect to OpenXMLA

1. Open Microsoft Excel. Create a new workbook.
2. Go to "Data" -> "Get Data" -> "From Other Sources" -> "From Analysis Services".
3. Enter the server name as http://localhost:6068/mdx/xmla/SalesWarehouse.
4. Enter any username and password (e.g., admin/admin).
5. Click "Next" to connect.

Features

1. Functionality

• Support MDX query
• Support XMLA protocol
• Support multiple projects/datasets
• Support customizable datasets

2. Front-end support

• Microsoft Excel
• Power BI
• Tableau

3. Optimization

• Query cache. Cache consistency.
• Query rewrite
  • Cross-join involves multiple dimensions. Reduce the impact from Curse of dimensionality
• Filter pushdown
• Paging

4. Monitoring/Management

• Admin portal
• Schema management
• User management

Configuration

Evaluation

License

Apache Kylin

• Official Site: https://kylin.apache.org/
• Modified Version: https://github.com/Kyligence/mdx-kylin
• Licensed under the Apache License, Version 2.0 (the "License");

Mondrian

• Official Site: https://mondrian.pentaho.com/
• Modified Version: https://github.com/pentaho/mondrian
• Licensed under the Business Source License 1.1 (BSL)