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
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 969 Connectors
- 257 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 501 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 375 Beast Mode
- 20 Variables
- 485 Automate
- 103 Apps
- 378 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 316 Distribute
- 64 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 63 Community Announcements
- 4.8K Archive