MDX is the BI industry standard for multidimensional calculations and queries. Proficiency with this language is essential to the realization of your Analysis Services' full potential. MDX is an elegant and powerful language but also has a steep learning curve.
MDX with Microsoft SQL Server 2012 Analysis Services Cookbook is packed with immediately usable, practical solutions. It starts with elementary techniques that lay the foundation for designing advanced MDX calculations and queries. The discussions after each solution will provide you with a solid foundation and best practices. It covers a broad range of real-world topics and solutions and provides you with learning materials to become proficient in the language.
This book will guide you through the hands-on and practical MDX solutions, best practices, and many intricacies that hide within the MDX calculations and queries.
Starting from working with sets, creating time-aware, context-aware calculations, and business analytics solutions, through the techniques of enhancing the cube design when MDX is not enough, to capturing MDX generated by SSAS front-ends and using SSAS stored procedures, we will explore the whole range of MDX solutions for real-world BI projects.
MDX with SSAS 2012 Cookbook is a must-have book for anyone who thrives to be proficient in MDX language and to enhance their Business Intelligence solutions.