asked on March 25, 2022
Hi, we are migrating away from Microsoft SSAS to a SQL data warehouse. We are rebuilding our data model using Cube.js and I'm curious what our options are (if there are any) regarding multi-dimensional support outside of SSAS?
Is Cube.js on your roadmap? Is there a way to create a similar multidimensional experience using the custom data source?
Thanks!
⋅ March 25, 2022
Hello, Jeremiah!
Thank you for contacting us.
We want to kindly inform you that there is no built-in connector for Cube.js.
Nevertheless, we provide a custom data source API to connect Flexmonster to any data provider.
So, it is possible to create your own connector using our API:
https://www.flexmonster.com/doc/introduction-to-custom-data-source-api/
As for the roadmap, currently, there are no plans to add Cube.js support out of the box.
Feel free to ask if any further questions arise.
Regards,
Solomiia
⋅ March 25, 2022
Hi Solomiia! Thanks for your response.
The custom datasource differs from the SSAS datasource in that you cannot have multiple dimension tables represented at the same time.
Is it possible to achieve a similar 'hierarchy' experience with custom datasources? (see attached)
⋅ March 28, 2022
Hello, Jeremiah!
Thank you for your question.
Our team wants to inform you that it is possible to configure multiple dimensions using our custom API.
The simplest way to implement your example is to use folder property on the client-side.
We prepare a simple fiddle with data from your attachment to illustrate this method: https://jsfiddle.net/flexmonster/702xcbu1/
Feel free to ask if any further questions arise.
Regards,
Solomiia
