Hi everyone,
I'm currently using Microsoft Analysis Services as my data warehouse. I'm exploring whether it's possible to use Metabase for visualizing and analyzing the data from this source.
I'd really appreciate any experiences, solutions, or caveats you can share about using Metabase with SSAS. Thanks in advance!
there's no direct connection to SSAS unless there's any way that SSAS can be connected with the SQL Server driver
I didn't dig strongly into SSAS when I was teaching myself SQL Server, but if its output is written back to the database then Metabase can access & visualize it just like any table.
That's OLAP using MDX rather than SQL.
You need to use Open Query with a linked database in MS SQL to create views. Metabase will then see the views in the regular SQL Server database.
Might be better to look at the source of the cube and see if it's easier to create a star schema from that. It's very similar to how a cube is built up so shouldn't be a huge amount of work. Right tool for the right job etc.