I know you can get metadata and schema info from relational stores in Microsoft SQL Server 2005+ via:
What is the equivalent of this in Microsoft Analysis Services?
I know you can get metadata and schema info from relational stores in Microsoft SQL Server 2005+ via:
What is the equivalent of this in Microsoft Analysis Services?
You can use an XLMA Discover query to retrieve schema information about a cube. Also, the AMO (Analysis Management Objects) API has an object model that allows you to query cube metadata through a .Net client. Behind the scenes it sends XMLA commands to the OLAP server.