LEADER 05280nam 2200649 450 001 9910816781003321 005 20200520144314.0 010 $a1-84968-961-X 035 $a(CKB)2550000001114617 035 $a(EBL)1389406 035 $a(OCoLC)857713211 035 $a(SSID)ssj0001056504 035 $a(PQKBManifestationID)11600156 035 $a(PQKBTitleCode)TC0001056504 035 $a(PQKBWorkID)11020180 035 $a(PQKB)10498668 035 $a(Au-PeEL)EBL1389406 035 $a(CaPaEBR)ebr10754106 035 $a(CaONFJC)MIL514489 035 $a(MiAaPQ)EBC1389406 035 $a(PPN)228033195 035 $a(EXLCZ)992550000001114617 100 $a20111102d2013 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMDX with SSAS 2012 cookbook /$fSherry Li, Tomislav Piasevoli 205 $a2nd ed. 210 1$aBirmingham :$cPackt Publishing,$d[2013] 210 4$dİ2013 215 $a1 online resource (420 p.) 300 $aIncludes index. 311 $a1-84968-960-1 311 $a1-299-83238-5 327 $aCover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Elementary MDX Techniques; Introduction; Putting data on x and y axes; Skipping axes; Using a WHERE clause to filter the data returned; Optimizing MDX queries using the NonEmpty() function; Using the PROPERTIES() function to retrieve data from attribute relationships; Basic sorting and ranking; Handling division by zero errors; Setting a default member of a hierarchy in MDX script; Chapter 2: Working with Sets; Introduction; Implementing NOT IN set logic 327 $aImplementing logical OR on members from different hierarchiesImplementing logical AND on members from the same hierarchy; Iterating on a set in order to reduce it; Iterating on a set in order to create a new one; Iterating on a set using recursion; Dissecting and debugging MDX queries; Chapter 3: Working with Time; Introduction; Calculating the YTD (Year-To-Date) value; Calculating the YoY (Year-over-Year) growth (parallel periods); Calculating moving averages; Finding the last date with data; Getting values on the last date with data; Calculating today's date using the string functions 327 $aCalculating today's date using the MemberValue functionCalculating today's date using an attribute hierarchy; Calculating the difference between two dates; Calculating the difference between two times; Calculating parallel periods for multiple dates in a set; Calculating parallel periods for multiple dates in a slicer; Chapter 4: Concise Reporting; Introduction; Isolating the best N members in a set; Isolating the worst N members in a set; Identifying the best/worst members for each member of another hierarchy; Displaying few important members, others as a single row, and the total at the end 327 $aCombining two hierarchies into oneFinding the name of a child with the best/worst value; Highlighting siblings with the best/worst values; Implementing bubble-up exceptions; Chapter 5: Navigation; Introduction; Detecting a particular member in a hierarchy; Detecting the root member; Detecting members on the same branch; Finding related members in the same dimension; Finding related members in another dimension; Calculating various percentages; Calculating various averages; Calculating various ranks; Chapter 6: Business Analytics; Introduction; Forecasting using the linear regression 327 $aForecasting using the periodic cyclesAllocating the non-allocated company expenses to departments; Analyzing fluctuation of customers; Implementing the ABC analysis; Chapter 7: When MDX is Not Enough; Introduction; Using a new attribute to separate members on a level; Using a distinct count measure to implement histograms over existing hierarchies; Using a dummy dimension to implement histograms over non-existing hierarchies; Creating a physical measure as a placeholder for MDX assignments; Using a new dimension to calculate the most frequent price 327 $aUsing a utility dimension to implement flexible display units 330 $aThis book is written in a recipe-based style packed full of practical tips and techniques to help you analyse multidimensional data stored in SSAS 2012 cubes. If you need to master MDX queries in SSAS, then this book is for you!If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you. This book is also an essential resource for report developers who need to access the multidimensional cubes through the MDX language. The book assumes you have some basic working knowledge of MDX and a basic understanding of dimensional 606 $aMDX (Computer program language) 606 $aClient/server computing 615 0$aMDX (Computer program language) 615 0$aClient/server computing. 676 $a005.7585 700 $aLi$b Sherry$01632993 701 $aPiasevoli$b Tomislav$01091321 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910816781003321 996 $aMDX with SSAS 2012 cookbook$93972515 997 $aUNINA