MDX with SSAS 2012 cookbook / / Sherry Li, Tomislav Piasevoli |
Autore | Li Sherry |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Birmingham : , : Packt Publishing, , [2013] |
Descrizione fisica | 1 online resource (420 p.) |
Disciplina | 005.7585 |
Altri autori (Persone) | PiasevoliTomislav |
Soggetto topico |
MDX (Computer program language)
Client/server computing |
Soggetto genere / forma | Electronic books. |
ISBN | 1-84968-961-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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 Using a utility dimension to implement flexible display units |
Record Nr. | UNINA-9910452658103321 |
Li Sherry | ||
Birmingham : , : Packt Publishing, , [2013] | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
MDX with SSAS 2012 cookbook / / Sherry Li, Tomislav Piasevoli |
Autore | Li Sherry |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Birmingham : , : Packt Publishing, , [2013] |
Descrizione fisica | 1 online resource (420 p.) |
Disciplina | 005.7585 |
Altri autori (Persone) | PiasevoliTomislav |
Soggetto topico |
MDX (Computer program language)
Client/server computing |
ISBN | 1-84968-961-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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 Using a utility dimension to implement flexible display units |
Record Nr. | UNINA-9910790432103321 |
Li Sherry | ||
Birmingham : , : Packt Publishing, , [2013] | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
MDX with SSAS 2012 cookbook / / Sherry Li, Tomislav Piasevoli |
Autore | Li Sherry |
Edizione | [2nd ed.] |
Pubbl/distr/stampa | Birmingham : , : Packt Publishing, , [2013] |
Descrizione fisica | 1 online resource (420 p.) |
Disciplina | 005.7585 |
Altri autori (Persone) | PiasevoliTomislav |
Soggetto topico |
MDX (Computer program language)
Client/server computing |
ISBN | 1-84968-961-X |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
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 Using a utility dimension to implement flexible display units |
Record Nr. | UNINA-9910816781003321 |
Li Sherry | ||
Birmingham : , : Packt Publishing, , [2013] | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|