Forum Discussion
Scan dataset M codes.
We want to scan datasets M codes using XMLA endpoint to get information on how tables have been created. We found that we can do this for tables created from Excel, SQL, manual inputs. But the tabl...
bcdobbs
Community Champion
Community ChampionI think my solution on this post might help:
You need to access the M code from the table partitions:
SELECT *
FROM $SYSTEM.TMSCHEMA_PARTITIONS
smpa01Community Champion
Community Championbcdobbs This is aweome to say the least !!! Fantastic !!! Thanks for sharing.
- bcdobbs
All sorts of fun available...
Following code gives you list of all those queries:
SELECT * FROM $System.DBSchema_Tables
WHERE TABLE_TYPE = 'SCHEMA'
ORDER BY TABLE_NAME ASCwhich is from Dynamic Management Views (DMVs) in Analysis Services | Microsoft Docs