Cargando…
Instant MDX Queries for SQL Server 2012 : learn how to write MDX queries from SQL Server Analysis Services 2012 cubes quickly and easily /
Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. This short, focused guide is a great way to get stated with writing MDX queries. New developers can use this book as a reference for how to use funct...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2013.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewers; www.packtpub.com; packtlib.packtpub.com; Table of Contents; Instant MDX Queries for SQL Server 2012; So, what is MDX for SQL Server 2012?; Installation; Step 1
- identify which edition to use; The Developer edition; The Evaluation edition; 32-bit or 64-bit; Step 2
- review the requirements; Step 3
- downloading the SQL Server 2012 trial edition; Step 4
- installing the SQL Server 2012; Step 5
- installing the Data Warehouse; Step 6
- installing the multidimensional models; And that's it.
- Quick start
- writing your first MDX queryStep 1
- open the SQL Server Management Studio and connect to the cube; Step 2
- SELECT; Axes; Tuples; Sets; Step 3
- FROM; Step 4
- WHERE; Step 5
- comments; Step 6
- your first MDX query; Top 4 features you'll want to know about; Using functions; Basic keywords and functions; It's all in the family; Can you sparse the time?; Using Calculated Members and Named Sets; Calculated Members; Named Sets; Calculations; The calculation tab; Add a new Calculated Member; Add a new Named Set; Writing for SSRS; Create a Report Project; Create a new report.
- Create a data sourceCreate a dataset; Create a table; The Months parameter; DMVs; People and places you should get to know; Official Sites; Articles and Tutorials; Blogs; Twitter.