I’ve just come across a new webcast available on Technet on ‘Common MDX Mistakes and Solutions in AS2K’, available here (for some reason the sound on the webcast wasn’t working when I viewed it, but you can download the transcript separately). It has got some really good content in it – I certainly learned a few things. Highlights include more details on how the mysterious Cache Policy connection string property works, the good news that an MDX Debugger will be available for download soon for AS2K (I’ve seen an early version and it is pretty useful), and the fact that some VBA functions are now supported natively in MDX so any queries which use them will perform better.
MDX Webcast
Published by Chris Webb
My name is Chris Webb, and I work on the Fabric CAT team at Microsoft. I blog about Power BI, Power Query, SQL Server Analysis Services, Azure Analysis Services and Excel. View all posts by Chris Webb
Published