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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive