You can translate the question and the replies:

Translating SAP Analysis for Office Excel Add-in to Denodo

Hello! Does anyone have experience translating reports from Analysis for Office (MS Excel add-in) to Denodo? It is a painstaking manual process to navigate the cube in the Denodo GUI, and it seems like there must be a better way to find the underlying MDX with filters/dimensions set appropriately.
12-10-2022 17:04:36 -0400

1 Answer

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]( 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!
Denodo Team
14-10-2022 03:42:38 -0400
You must sign in to add an answer. If you do not have an account, you can register here