Loading data from SSAS Cube

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.
Comments
-
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!
0 -
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!
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive