Sinossi
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
300+ ready-to-use, powerful MDX queries
This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.
- Work with dimensions, hierarchies, levels, and members
- Navigate both horizontally and vertically across dimensions and hierarchies
- Sort the results of your queries
- Access subsets of dimension members and measure values using the Where clause and Filter function
- Use MDX query calculations
- Extract and manipulate dates and times
- Produce totals, subtotals, and changes cross time using aggregate and other functions
- Create, visualize, and manipulate sets
- Work with perspectives, subselects, and subcubes
- Display and hide empty cells
- Use, modify, format, and create Key Performance Indicators (KPIs)
- Deliver MDX query results to end users
Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.
Informazioni sull?autore
Art Tennick has worked in relational database design and SQL queries for over 20 years, and in MDX queries for 10 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Recently, Art worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2007/2010. His website is www.MrCube.net.
Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.
Altre edizioni note dello stesso titolo
Risultati della ricerca per Practical Mdx Queries: For Microsoft Sql Server Analysis...
Foto dell'editore
Practical MDX Queries: for Microsoft SQL Server Analysis Services 2008
Editore:
McGraw-Hill Education, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Antico o usato
Brossura
Da: Better World Books, Mishawaka, IN, U.S.A.
Valutazione del venditore 5 su 5 stelle
Condizione: Very Good. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Codice articolo 40641860-20
Compra usato
EUR 7,62
Spedizione gratuita
Spedito in U.S.A.
Spedito in U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical Mdx Queries: For Microsoft Sql Server Analysis Services 2008 (DATABASE & ERP - OMG)
Da: WorldofBooks, Goring-By-Sea, WS, Regno Unito
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Codice articolo GOR005732004
Compra usato
EUR 9,62
Spedizione EUR 9,02
Spedito da Regno Unito a U.S.A.
Spedito da Regno Unito a U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Editore:
McGraw-Hill Companies, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Antico o usato
Paperback
Da: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Codice articolo G0071713360I3N00
Compra usato
EUR 20,29
Spedizione gratuita
Spedito in U.S.A.
Spedito in U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Editore:
McGraw-Hill Companies, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Antico o usato
Paperback
Da: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Codice articolo G0071713360I4N00
Compra usato
EUR 20,29
Spedizione gratuita
Spedito in U.S.A.
Spedito in U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Editore:
McGraw-Hill Companies, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Antico o usato
Paperback
Da: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less. Codice articolo G0071713360I2N00
Compra usato
EUR 20,29
Spedizione gratuita
Spedito in U.S.A.
Spedito in U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Da: Kimmies Collection, Maryville, TN, U.S.A.
Valutazione del venditore 5 su 5 stelle
paperback. Condizione: Very Good. a very nice copy! clean and tight pages. fast and secure shipping. Codice articolo 70200
Compra usato
EUR 16,09
Spedizione EUR 4,23
Spedito in U.S.A.
Spedito in U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Editore:
McGraw-Hill Osborne Media, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Antico o usato
Paperback
Da: Books From California, Simi Valley, CA, U.S.A.
Valutazione del venditore 4 su 5 stelle
Paperback. Condizione: Very Good. Codice articolo mon0003113118
Compra usato
EUR 16,31
Spedizione EUR 4,23
Spedito in U.S.A.
Spedito in U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Editore:
McGraw-Hill Osborne, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Antico o usato
Paperback
Da: Greener Books, London, Regno Unito
Valutazione del venditore 4 su 5 stelle
Paperback. Condizione: Used; Good. **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence! Greener Books. Codice articolo 2381132
Compra usato
EUR 12,56
Spedizione EUR 18,49
Spedito da Regno Unito a U.S.A.
Spedito da Regno Unito a U.S.A.
Quantità: 1 disponibili
Foto dell'editore
Practical Mdx Queries: For Microsoft Sql Server Analysis Services 2008 (DATABASE & ERP - OMG)
Editore:
McGraw-Hill Osborne Media 2010-05-24, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Nuovo
Paperback
Da: Chiron Media, Wallingford, Regno Unito
Valutazione del venditore 5 su 5 stelle
Paperback. Condizione: New. Codice articolo 6666-ING-9780071713368
Compra nuovo
EUR 61,03
Spedizione EUR 17,91
Spedito da Regno Unito a U.S.A.
Spedito da Regno Unito a U.S.A.
Quantità: Più di 20 disponibili
Immagini fornite dal venditore
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Editore:
Mcgraw Hill LLC Jun 2010, 2010
ISBN 10: 0071713360
ISBN 13: 9780071713368
Nuovo
Taschenbuch
Da: BuchWeltWeit Ludwig Meier e.K., Bergisch Gladbach, Germania
Valutazione del venditore 5 su 5 stelle
Taschenbuch. Condizione: Neu. This item is printed on demand - it takes 3-4 days longer - Neuware -300+ ready-to-use, powerful MDX queriesThis hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.Work with dimensions, hierarchies, levels, and membersNavigate both horizontally and vertically across dimensions and hierarchiesSort the results of your queriesAccess subsets of dimension members and measure values using the Where clause and Filter functionUse MDX query calculationsExtract and manipulate dates and timesProduce totals, subtotals, and changes cross time using aggregate and other functionsCreate, visualize, and manipulate setsWork with perspectives, subselects, and subcubesDisplay and hide empty cellsUse, modify, format, and create Key Performance Indicators (KPIs)Deliver MDX query results to end users 304 pp. Englisch. Codice articolo 9780071713368
Compra nuovo
EUR 61,50
Spedizione EUR 23,00
Spedito da Germania a U.S.A.
Spedito da Germania a U.S.A.
Quantità: 2 disponibili