MDX (Multi – Dimensional eXpressions) support

[redpin-pankaj]

Is your feature request related to a problem? Please describe. Our organisation uses Excel with SSAS MDX heavily. It would be great if it supported on cube.dev.

Describe the solution you'd like It would be nice if apart from SQL, REST and GraphQL, the MDX (Multi – Dimensional eXpressions) is also supported. It would allow the cube.dev to better integrate with Microsoft BI tools(like excel, PowerBI etc). Additionally tableau also support MDX(https://help.tableau.com/current/pro/desktop/en-us/cubes.htm)

FYI, Apache Kylin has support for MDX (https://kylin.apache.org/docs/tutorial/quick_start_for_mdx.html)

Describe alternatives you've considered I have not tried the devart postgres driver for excel, but I am not sure if it is well maintained. I tried to install the driver but it is being blocked by MacOS.

Additional context NA

[igorlukanin]

@gh-pankaj Yep, it would be great to have that!

[igorlukanin]

Excel is now supported in Cube Cloud via the MDX API:

• https://cube.dev/blog/announcing-the-native-mdx-api-and-excel-integration-for-cube-cloud
• https://cube.dev/blog/how-to-directly-query-large-datasets-with-excel
• https://cube.dev/docs/product/apis-integrations/mdx-api

I'm not aware of any plans to bring MDX support to Cube Core.