Many companies have recognized the benefits of migrating their on-premises legacy data warehouses to the cloud. Databricks, the data lakehouse, has emerged as a popular destination for these workloads, offering a comprehensive data platform with a highly scalable and performant SQL engine. However, when companies migrate data warehouses that include OLAP cube engines to support multidimensional analysis, they often disrupt connectivity to a crucial tool for many users—Excel.
Discover how the MDX API endpoint in Cube Cloud can restore direct query connectivity between Excel and Databricks. Learn from Databricks and Cube data experts about the challenges of maintaining direct query access to Excel and why this feature remains important to many users.
Key Topics Covered:
- The continued relevance of multidimensional analysis in various fields such as scenario planning, financial planning & analysis (FP&A), and supply chain management.
- Common challenges encountered when migrating from OLAP engines like SQL Server Analysis Services, Oracle Essbase, or SAP Hana to Databricks.
- An introduction to the role of the semantic layer in the data landscape.
- How Cube Cloud is evolving as a product to enable direct query access between Excel and other applications that use MDX as a query language, and data platforms like the Databricks Lakehouse.