Cargando…

MDX with SSAS 2012 cookbook : 69 practical recipes to analyze multidimensional data stored in SSAS 2012 cubes, using high-performance MDX calculations and flexible MDX queries /

This 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 t...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Li, Sherry
Otros Autores: Piasevoli, Tomislav
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing, 2013.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 a 4500
001 EBSCO_ocn857713211
003 OCoLC
005 20231017213018.0
006 m o d
007 cr |n|||||||||
008 130906s2013 enk o 000 0 eng d
040 |a IDEBK  |b eng  |e pn  |c IDEBK  |d OCLCQ  |d EBLCP  |d MHW  |d E7B  |d MEAUC  |d DEBSZ  |d S4S  |d OCLCO  |d YDXCP  |d OCLCQ  |d OCLCF  |d OCLCQ  |d COO  |d OCLCQ  |d N$T  |d ZCU  |d AGLDB  |d MERUC  |d OCLCQ  |d D6H  |d OCLCQ  |d VTS  |d ICG  |d OCLCQ  |d STF  |d DKC  |d OCLCQ  |d AJS  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO 
020 |a 1299832385  |q (electronic bk.) 
020 |a 9781299832381  |q (electronic bk.) 
020 |a 9781849689618  |q (electronic bk.) 
020 |a 184968961X  |q (electronic bk.) 
020 |z 9781849689601 
020 |z 1849689601 
029 1 |a AU@  |b 000055915797 
029 1 |a CHNEW  |b 000634484 
029 1 |a CHNEW  |b 001052198 
029 1 |a CHVBK  |b 567710181 
029 1 |a DEBBG  |b BV044185350 
029 1 |a DEBSZ  |b 39763336X 
029 1 |a DEBSZ  |b 49312666X 
029 1 |a DKDLA  |b 820120-katalog:999940746105765 
035 |a (OCoLC)857713211 
037 |a 514489  |b MIL 
050 4 |a QA76.73.M39 
050 4 |a QA76.73.B3 .L374 2013 
072 7 |a COM  |x 018000  |2 bisacsh 
082 0 4 |a 005.7585 
049 |a UAMI 
100 1 |a Li, Sherry. 
245 1 0 |a MDX with SSAS 2012 cookbook :  |b 69 practical recipes to analyze multidimensional data stored in SSAS 2012 cubes, using high-performance MDX calculations and flexible MDX queries /  |c Sherry Li, Tomislav Piasevoli. 
260 |a Birmingham, UK :  |b Packt Publishing,  |c 2013. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
520 |a This 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. 
505 0 |a Cover; 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. 
505 8 |a Implementing 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. 
505 8 |a Calculating 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. 
505 8 |a Combining 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. 
505 8 |a Forecasting 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. 
588 0 |a Print version record. 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
650 0 |a MDX (Computer program language) 
650 0 |a Client/server computing. 
650 6 |a MDX (Langage de programmation) 
650 6 |a Architecture client-serveur (Informatique) 
650 7 |a COMPUTERS  |x Data Processing.  |2 bisacsh 
650 7 |a Client/server computing  |2 fast 
650 7 |a MDX (Computer program language)  |2 fast 
700 1 |a Piasevoli, Tomislav. 
776 0 8 |i Print version:  |z 9781299832381 
856 4 0 |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637238  |z Texto completo 
938 |a EBL - Ebook Library  |b EBLB  |n EBL1389406 
938 |a ebrary  |b EBRY  |n ebr10754106 
938 |a EBSCOhost  |b EBSC  |n 637238 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis26098928 
938 |a YBP Library Services  |b YANK  |n 11120021 
994 |a 92  |b IZTAP