Loading data from SSAS Cube

user021516 · April 2020

Wondering if there is a workaround / tip&tricks on creating MDX query to fetch fields from a SSAS cube? I am no MDX expert and it seems like you ened to write a MDX query to get what you need instead of like a GUI (pivotable report) in excel.

user090374 · April 2020

Hi @user021516 ,

I recommend checking out their help portal here: https://help.sap.com/viewer/655c9dba6efb4e4ca3b2f0de156ec69a/10.1.5/en-US/f9eb30386faf1014878bae8cb0e91070.html

Hope this helps!

jaeW_at_Onyx · April 2020

SSAS cubes are built on SQL tables (is it fair to assume we're talking about Microsoft BI stack)?

It might be easier / more efficient to use Workbench to access the SQL database that the cubes are built on.

Alternatively you could open your SSAS cube in Excel as a pivot table. Then use Workbench to transfer the data into Domo periodically.

Alternatively, pivot tables pointed at SSAS are built on MDX; however, Excel does not always produce the most efficient MDX. https://www.sqlbi.com/blog/marco/2007/01/18/display-the-mdx-query-of-an-excel-2007-pivottable/

Good luck!

Loading data from SSAS Cube

Comments

Categories