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.
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!
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!