Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
MDX with Microsoft SQL server 2008 R2 analysis services [[electronic resource] ] : cookbook : 80 recipes for enriching your business intelligence solutions with high-performance MDX calculations and flexible MDX queries / / Tomislav Piasevoli
| MDX with Microsoft SQL server 2008 R2 analysis services [[electronic resource] ] : cookbook : 80 recipes for enriching your business intelligence solutions with high-performance MDX calculations and flexible MDX queries / / Tomislav Piasevoli |
| Autore | Piasevoli Tomislav |
| Pubbl/distr/stampa | Birmingham, : Packt Pub., 2011 |
| Descrizione fisica | 1 online resource (480 p.) |
| Disciplina |
005.13/3
005.7585 |
| Collana | Quick answers to common problems |
| Soggetto topico |
MDX (Computer program language)
Business intelligence |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-30832-0
9786613308320 1-84968-131-7 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; 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
Dissecting 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 Calculating 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 Finding 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 Allocating 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 Using a utility dimension to implement flexible display units |
| Record Nr. | UNINA-9910456702303321 |
Piasevoli Tomislav
|
||
| Birmingham, : Packt Pub., 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
MDX with Microsoft SQL Server 2016 Analysis Services cookbook : over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes / / Tomislav Piasevoli, Sherry Li
| MDX with Microsoft SQL Server 2016 Analysis Services cookbook : over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes / / Tomislav Piasevoli, Sherry Li |
| Autore | Piasevoli Tomislav |
| Edizione | [Third edition.] |
| Pubbl/distr/stampa | Birmingham, England ; ; Mumbai, [India] : , : Packt Publishing, , 2016 |
| Descrizione fisica | 1 online resource (582 pages) |
| Disciplina | 005.133 |
| Soggetto topico |
MDX (Computer program language)
Client/server computing |
| ISBN | 1-78646-788-7 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910155042303321 |
|
Piasevoli Tomislav
|
||
| Birmingham, England ; ; Mumbai, [India] : , : Packt Publishing, , 2016 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||