MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
This book offers practical, task-based, and immediately usable recipes covering a wide range of MDX calculations and queries. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, the explanations are done in great detail, which makes it good learning material for everyone who has experience in MDX and wants to improve. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. However, some of the recipes depend on each another. When this is the case, you will be notified. The book is focused on Microsoft SQL Server 2008 R2 Analysis Services, but most of the concepts and explanation are also applicable to previous versions of Microsoft SQL Server Analysis Services. If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you. The book assumes you have a working knowledge of MDX and a basic understanding of dimensional modeling and cube design.
What people are saying - Write a review
Other editions - View all
Adventure Works cube Adventure Works DW AdventureWorks Aggregate Analysis Services argument Business Intelligence cache calculated measure calculated member cell chapter colors columns context Count measure Create MEMBER Cube Browser current member CurrentMember customers database Date dimension Date].[Calendar default member defined Descendants detect Displaying DMVs Doubleclick drillthrough End Scope evaluation example EXISTING expression fact table Follow these steps following image format FORMAT_STRING function Getting ready hierarchy on rows histograms Howit Howitworks Howto implement inthe inthis Iterating itworks keyword linear regression MDX queries MDX script measure group Measures].[Reseller Sales Amount MEMBER Measures Microsoft SQL Server named sets NonEmpty null ofthe OLAP onthe option Order Count ParallelPeriod parentchild hierarchies performance previous recipe Product Product].[Product Query button query optimization Rank recursion Related recipes Reseller Order result root member Row Number Sales Territory slicer solution stored procedures string subcube There's TopCount tuple UNION ALL SELECT user hierarchy usingthe utility dimension XMLA