Sunday, October 2, 2011

list of all the tables in SSAS

To get a list of all the tables in SSAS, execute this in an MDX window:
SELECT * FROM $system.dbschema_tables
where Table_type = 'schema'