Hi,
In order to access data from a multidimensional database, I would create a multidimensional data source using an MDX query. To do so, follow the below steps in the Virtual DataPort Administration Tool:
* Create a Multidimensional data source by navigating to **File>New>Data Source>Multidimensional DB**.
* Select **Create Base view** and click **Create from MDX query**.
* Provide the view name and MDX query to access the multidimensional data in the dialog box.
For more details, you could refer to the [Multidimensional Database Sources](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/creating_data_sources_and_base_views/multidimensional_database_sources/multidimensional_database_sources#create-a-base-view-from-an-mdx-query-multidimensional-data-source) section of the Virtual DataPort Administration Tool for creating multidimensional data sources for accessing multidimensional databases like SAP, Azure, Microsoft SQL Server Analysis Services SSAS, etc.
Hope this helps!
