Is it possible to read SSAS cube and role list from Excel vba through AMO. If Yes please share the details how to do that.
ADO is a .NET assembly, you can't use it in VBA, but you can use the
MSOLAP native OLE DB data provider instead.
Thank you so much Olaf for reply.
So is not possible to achieve through excel but we can go with other tool like .net...
My scenario is need to get all cube information through excel, is any other way to achevie?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?