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...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UK :
Packt Publishing,
2013.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | 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. |
| Beschreibung: | 1 online resource |
| ISBN: | 1299832385 9781299832381 9781849689618 184968961X |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn857713211 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.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 |d UEJ |d OCLCQ | ||
| 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 | ||
| 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 | 7 | |a 005.7585 | |
| 049 | |a MAIN | ||
| 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. | |
| 650 | 0 | |a MDX (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh2002008553 | |
| 650 | 0 | |a Client/server computing. |0 http://id.loc.gov/authorities/subjects/sh93000502 | |
| 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 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637238 |3 Volltext |
| 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 GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn857713211 |
|---|---|
| _version_ | 1816882243697639424 |
| adam_text | |
| any_adam_object | |
| author | Li, Sherry |
| author2 | Piasevoli, Tomislav |
| author2_role | |
| author2_variant | t p tp |
| author_facet | Li, Sherry Piasevoli, Tomislav |
| author_role | |
| author_sort | Li, Sherry |
| author_variant | s l sl |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.73.M39 QA76.73.B3 .L374 2013 |
| callnumber-search | QA76.73.M39 QA76.73.B3 .L374 2013 |
| callnumber-sort | QA 276.73 M39 |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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. 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. 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. 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. 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. |
| ctrlnum | (OCoLC)857713211 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06154cam a2200637 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn857713211</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr |n|||||||||</controlfield><controlfield tag="008">130906s2013 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">IDEBK</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">IDEBK</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">EBLCP</subfield><subfield code="d">MHW</subfield><subfield code="d">E7B</subfield><subfield code="d">MEAUC</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">S4S</subfield><subfield code="d">OCLCO</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">N$T</subfield><subfield code="d">ZCU</subfield><subfield code="d">AGLDB</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">D6H</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">ICG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">STF</subfield><subfield code="d">DKC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AJS</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">UEJ</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1299832385</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781299832381</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849689618</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">184968961X</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849689601</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1849689601</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)857713211</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">514489</subfield><subfield code="b">MIL</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.M39</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.73.B3 .L374 2013</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.7585</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Li, Sherry.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">MDX with SSAS 2012 cookbook :</subfield><subfield code="b">69 practical recipes to analyze multidimensional data stored in SSAS 2012 cubes, using high-performance MDX calculations and flexible MDX queries /</subfield><subfield code="c">Sherry Li, Tomislav Piasevoli.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, UK :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2013.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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.</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">MDX (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh2002008553</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh93000502</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">MDX (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Client/server computing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">MDX (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Piasevoli, Tomislav.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">MDX with SSAS 2012 cookbook (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCFyYmcRwPyvFVb4PyqYqw3</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="z">9781299832381</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637238</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1389406</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10754106</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">637238</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis26098928</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">11120021</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn857713211 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:25:31Z |
| institution | BVB |
| isbn | 1299832385 9781299832381 9781849689618 184968961X |
| language | English |
| oclc_num | 857713211 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource |
| psigel | ZDB-4-EBA |
| publishDate | 2013 |
| publishDateSearch | 2013 |
| publishDateSort | 2013 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Li, Sherry. 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 / Sherry Li, Tomislav Piasevoli. Birmingham, UK : Packt Publishing, 2013. 1 online resource text txt rdacontent computer c rdamedia online resource cr rdacarrier 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. 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. 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. 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. 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. 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. Print version record. MDX (Computer program language) http://id.loc.gov/authorities/subjects/sh2002008553 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 MDX (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Data Processing. bisacsh Client/server computing fast MDX (Computer program language) fast Piasevoli, Tomislav. has work: MDX with SSAS 2012 cookbook (Text) https://id.oclc.org/worldcat/entity/E39PCFyYmcRwPyvFVb4PyqYqw3 https://id.oclc.org/worldcat/ontology/hasWork Print version: 9781299832381 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637238 Volltext |
| spellingShingle | Li, Sherry 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 / 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. 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. 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. 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. 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. MDX (Computer program language) http://id.loc.gov/authorities/subjects/sh2002008553 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 MDX (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Data Processing. bisacsh Client/server computing fast MDX (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh2002008553 http://id.loc.gov/authorities/subjects/sh93000502 |
| title | 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 / |
| title_auth | 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 / |
| title_exact_search | 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 / |
| title_full | 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 / Sherry Li, Tomislav Piasevoli. |
| title_fullStr | 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 / Sherry Li, Tomislav Piasevoli. |
| title_full_unstemmed | 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 / Sherry Li, Tomislav Piasevoli. |
| title_short | MDX with SSAS 2012 cookbook : |
| title_sort | 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 |
| title_sub | 69 practical recipes to analyze multidimensional data stored in SSAS 2012 cubes, using high-performance MDX calculations and flexible MDX queries / |
| topic | MDX (Computer program language) http://id.loc.gov/authorities/subjects/sh2002008553 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 MDX (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Data Processing. bisacsh Client/server computing fast MDX (Computer program language) fast |
| topic_facet | MDX (Computer program language) Client/server computing. MDX (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Data Processing. Client/server computing |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=637238 |
| work_keys_str_mv | AT lisherry mdxwithssas2012cookbook69practicalrecipestoanalyzemultidimensionaldatastoredinssas2012cubesusinghighperformancemdxcalculationsandflexiblemdxqueries AT piasevolitomislav mdxwithssas2012cookbook69practicalrecipestoanalyzemultidimensionaldatastoredinssas2012cubesusinghighperformancemdxcalculationsandflexiblemdxqueries |