Instant MDX Queries for SQL Server 2012
-
- Einzelkauf Download ausgewählt
-
Sprache:Englisch
Fr. 19.90
inkl. gesetzl. MwSt.Beschreibung
Produktdetails
Format
Kopierschutz
Ja
Family Sharing
Ja
Text-to-Speech
Nein
Erscheinungsdatum
26.08.2013
Verlag
Packt Publishing Pvt. Ltd.Seitenzahl
54 (Printausgabe)
Dateigröße
869 KB
Sprache
Englisch
EAN
9781782178071
In DetailMDX is a query language that is used to retrieve data inside Microsoft SQL Server Analysis Services cubes. With MDX, you can display the elements of your cube like attributes and hierarchies from your dimensions, measures from your fact tables, calculations, and KPIs.This book will help you to understand the MDX query language, write your own MDX queries to display data from your cubes in the way you want, and display the results in Management Studio or in a Reporting Services report.Instant MDX Query for SQL Server 2012 starts by showing you how to write MDX queries and takes you all the way to integrating your MDX queries into SSRS and retrieving documentation data easily on your cubes.After you have followed the steps to install SQL Server 2012 with Analysis Services, you will learn how to write MDX queries. Once you understand the basic syntax of a query, you will then learn how to use calculated measures and named sets to reuse your code. MDX functions will help you filter, order, and combine results. Once you have mastered how to write calculated measures and named sets, you will then learn how to add them into your cube to reuse them.Displaying the results in Management Studio won't be enough, so you will also learn how to write MDX queries in Reporting Services reports.ApproachGet 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 functions and the syntax of a query as well as how to use Calculated Members and Named Sets.Who this book is forThis book is great for new developers who want to learn the MDX query language from scratch and install SQL Server 2012 with Analysis Services.
Noch keine Bewertungen vorhanden
Verfassen Sie die erste Bewertung zu diesem Artikel
Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.