|
|
|
|
|
|
|
|
1. |
Record Nr. |
UNINA9910456702303321 |
|
|
Autore |
Piasevoli Tomislav |
|
|
Titolo |
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 |
|
|
|
|
|
|
|
Pubbl/distr/stampa |
|
|
Birmingham, : Packt Pub., 2011 |
|
|
|
|
|
|
|
ISBN |
|
1-283-30832-0 |
9786613308320 |
1-84968-131-7 |
|
|
|
|
|
|
|
|
Descrizione fisica |
|
1 online resource (480 p.) |
|
|
|
|
|
|
Collana |
|
Quick answers to common problems |
|
|
|
|
|
|
Disciplina |
|
|
|
|
|
|
|
|
Soggetti |
|
MDX (Computer program language) |
Business intelligence |
Electronic books. |
|
|
|
|
|
|
|
|
Lingua di pubblicazione |
|
|
|
|
|
|
Formato |
Materiale a stampa |
|
|
|
|
|
Livello bibliografico |
Monografia |
|
|
|
|
|
Note generali |
|
|
|
|
|
|
Nota di bibliografia |
|
|
|
|
|
|
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 |
|
|
|
|