LEADER 05174nam 2200685 a 450 001 9910456702303321 005 20200520144314.0 010 $a1-283-30832-0 010 $a9786613308320 010 $a1-84968-131-7 035 $a(CKB)2550000000045683 035 $a(EBL)948530 035 $a(OCoLC)797917524 035 $a(SSID)ssj0000644000 035 $a(PQKBManifestationID)11384147 035 $a(PQKBTitleCode)TC0000644000 035 $a(PQKBWorkID)10668305 035 $a(PQKB)10255982 035 $a(MiAaPQ)EBC948530 035 $a(WaSeSS)Ind00023987 035 $a(PPN)227988892 035 $a(Au-PeEL)EBL948530 035 $a(CaPaEBR)ebr10497608 035 $a(CaONFJC)MIL330832 035 $a(EXLCZ)992550000000045683 100 $a20111025d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMDX with Microsoft SQL server 2008 R2 analysis services$b[electronic resource] $ecookbook : 80 recipes for enriching your business intelligence solutions with high-performance MDX calculations and flexible MDX queries /$fTomislav Piasevoli 210 $aBirmingham $cPackt Pub.$d2011 215 $a1 online resource (480 p.) 225 0 $aQuick answers to common problems 300 $aIncludes index. 311 $a1-84968-130-9 320 $aIncludes index. 327 $aCover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Elementary MDX Techniques; Introduction; Skipping axis; Handling division by zero errors; Setting special format for negative, zero and null values; Applying conditional formatting on calculations; Setting default member of a hierarchy in MDX script; Implementing NOT IN set logic; Implementing logical OR on members from different hierarchies; 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 327 $aDissecting and debugging MDX queriesUsing NON_EMPTY_BEHAVIOR; Optimizing MDX queries using the NonEmpty() function; Implementing logical AND on members from the same hierarchy; Chapter 2: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; Hiding calculation values on future dates; Calculating today's date using the string functions; Calculating today's date using the MemberValue function 327 $aCalculating today's date using an attribute hierarchyCalculating 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 slicer; Chapter 3: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; Combining two hierarchies into one 327 $aFinding the name of a child with the best/worst valueHighlighting siblings with the best/worst worst value; Implementing bubble-up exceptions; Chapter 4: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 5:Business Analytics; Introduction; Forecasting using the linear regression; Forecasting using the periodic cycles 327 $aAllocating the non-allocated company expenses to departmentsCalculating the number of days from the last sales to identify the slow-moving goods; Analyzing fluctuation of customers; Implementing the ABC analysis; Chapter 6: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 existinghierarchies; 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 $aMore than 80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries in this book and eBook 606 $aMDX (Computer program language) 606 $aBusiness intelligence 608 $aElectronic books. 615 0$aMDX (Computer program language) 615 0$aBusiness intelligence. 676 $a005.13/3 676 $a005.7585 700 $aPiasevoli$b Tomislav$0873293 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910456702303321 996 $aMDX with Microsoft SQL server 2008 R2 analysis services$91949530 997 $aUNINA