Until now I've succeed to make VDB from different excel spreadsheets. Now I need to query the VDB running on the teiid server but not with SQL but instead with MDX Query (OLAP).
Is this possible? And how to do that?
Thank you very much.
No, MDX is not supported as query language in JDV, only SQL, OData. If you want to use MDX you need to look into other tools like Pentaho, SQL Analytical server and connect to JDV as RDBMS source.
Retrieving data ...