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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| 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 | EBOOKCENTRAL_ocn857713211 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.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 |d OCLCL | ||
| 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 | |
| 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 ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 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. | |
| 758 | |i has work: |a MDX with SSAS 2012 cookbook (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFyYmcRwPyvFVb4PyqYqw3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |z 9781299832381 |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1389406 |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 | ||