Microsoft SQL Server 2008 MDX Step by Step
- ISBN-10
- 0735638446
- ISBN-13
- 9780735638440
- Pages
- 400
- Language
- English
- Published
- 2009-02-25
- Publisher
- Pearson Education
- Authors
- Bryan Smith, C. Clay
Description
Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct and execute MDX queries Work with tuples, sets, and expressions Build complex sets to retrieve the exact data users need Perform aggregation functions and navigate data hierarchies Assemble time-based business metrics Customize an Analysis Services cube through the MDX script Implement dynamic security to control data access Develop MDX-driven reports in SQL Server Reporting Services CD features: Practice exercises Database and code samples Fully searchable eBook
Get the book
Similar books
-
Microsoft SQL Server 2008 Reporting Services Step by Step
By Stacia MisnerTo Do This Test or learn the features of Reporting Services Use SQL Server 2008 Evaluation Edition in a singleserver deployment. ... click Service Account, specify a builtin or Windows user account and its password, and click Apply.
-
Microsoft SQL Server 2008 Analysis Services Step by Step
By Scott Cameron, Hitachi ConsultingProvides information on the fundamentals of Microsoft SQL Server 2008 Analysis Services, covering such topics as using MDX, desiging OLAP cubes, retreiving data and creating reports, and managing databases.
-
Professional Microsoft SQL Server Analysis Services 2008 with MDX
By Sivakumar Harinath, Robert Zare, Sethu MeenakshisundaramYou will see a tree view of those databases you have saved on the server to date, as shown in Figure 7-1. One of those databases should be titled AnalysisServices2008Tutorial — you should take a moment to review the tree nodes and what ...
-
MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
By Tomislav PiasevoliThe book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. However, some of the recipes depend on each another. When this is the case, you will be notified.
-
Microsoft SQL Server 2008 Analysis Services Step by Step
By Scott Cameron, Hitachi ConsultingTeach yourself to use SQL Server 2008 Analysis Services for business intelligence—one step at a time.
-
Microsoft SQL Server 2008 Step by Step
By Mike HotekTeach yourself SQL Server 2008—one step at a time.
-
Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
By Art Tennick300+ 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.
-
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
By Chris Webb, Marco Russo, Alberto FerrariDesign and implement fast, scalable and maintainable cubes with Microsoft SQL Server 2008 Analysis Services with this book and eBook
-
Applied Microsoft SQL Server 2008 Reporting Services
By Teo LachevProvides information on the features and functions of Reporting Services to turn enterprise data into a variety of reports.
-
Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports
By Paul Turley, Robert M. BrucknerIf so, this is the ideal resource for you. Packed with proven design practices, this book serves as a collection of recipes for solving design problems so that you don't have to reinvent the wheel with each challenge you face.