Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX / by Sivakumar Harinath ... [et al.].

Format:

Book

Author/Creator:

Harinath, Sivakumar, 1971-

Contributor:

Harinath, Sivakumar, 1971-

Series:

Wrox programmer to programmer

Language:

English

Subjects (All):

SQL server.

Database management.

MDX (Computer program language).

OLAP technology.

Relational databases.

Client/server computing.

Physical Description:

1 online resource (1180 p.)

Edition:

1st edition

Place of Publication:

Hoboken, N.J. : Wiley, 2012.

Language Note:

English

System Details:

text file

Summary:

Understand Microsoft's dramatically updated new release of its premier toolset for business intelligence The first major update to Microsoft's state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed book from key members of the product's development team? If you're a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsoft's new SQL Server 2012 Analysis Services and related tools. Discover how

Contents:

Professional Microsoft® Sql Server® 2012 Analysis Services with MDX and DAX; Contents; Introduction; Who This Book is For; What This Book Covers; How This Book is Structured; What you Need to USE This Book; Conventions; Source Code; Errata; P2P.Wrox.Com; Part I: Introduction; Chapter 1: Introduction; BISM Multidimensional Mode; A Closer Look at Data Warehousing; Key Elements of a Data Warehouse; Fact Tables; Dimension Tables; Dimensions; Cubes; The Star Schema; The Snowflake Schema; Inmon Versus Kimball?-?Different Approaches; Business Intelligence Is Data Analysis; BISM Tabular Mode

SQL Server Analysis Services 2012The Business Intelligence Semantic Model; Data Model; Query Language; Data Access Technology; Summary; Part II Designing Multidimensional BISM; Chapter 2: A First Look at Multidimensional BISM; Development, Administrative, and Client Tools; Upgrading to Analysis Services 2012; Using SQL Server Data Tools to Build Analysis Services Multidimensional Applications; Creating a Project Using SQL Server Data Tools; The Solution Explorer; The Properties Window; The Output Window; Creating an Analysis Services Database Using SQL Server Data Tools

Creating a Data SourceCreating a Data Source View (DSV); Creating a Cube Using the Cube Wizard; Deploying and Browsing a Cube; Using SQL Server Management Studio; The Object Explorer Pane; Querying Using the MDX Query Editor; Summary; Chapter 3: Understanding MDX; What Is MDX?; MDX Concepts; Measures and Measure Groups; Hierarchies and Hierarchy Levels; Members; Cells; Tuples; Sets; MDX Queries; SELECT Statement and Axis Specification; FROM Clause and Cube Specification; Subselect Clauses; WHERE Clause and Slicer Specification; Slicer Dimension; WITH Clause, Named Sets, and Calculated Members

Named SetsCalculated Members; Ranking and Sorting; MDX Expressions; MDX Operators; Arithmetic Operators; Set Operators; Comparison Operators; Logical Operators; Special MDX Operators?-?Curly Braces, Commas, and Colons; MDX Functions; MDX Function Categories; Set Functions; Crossjoin; NONEMPTYCROSSJOIN and NONEMPTY; Filter and Having; Member Functions; Numeric Functions; Dimension Functions, Level Functions, and Hierarchy Functions; String Manipulation Functions; Other Functions; MDX Scripts; MDX Script Execution; CALCULATE Statement; Cube Space; AUTO EXISTS; Cell Calculations and Assignments

RecursionFreeze Statement; Restricting Cube Space/Slicing Cube Data; SCOPE Statement; CREATE and DROP SUBCUBE; Using EXISTS; Using EXISTING; Using SUBSELECT; Parameterized MDX Queries; MDX Comments; Summary; Chapter 4: Data Sources and Data Source Views; Data Sources; Data Sources Supported by Analysis Services; .NET Versus OLE DB Data Providers; .NET Framework Data Providers; OLE DB Data Providers; The Trade-Offs; Data Source Views; DSV Wizard; DSV Designer; Adding/Removing Tables in a DSV; Specifying Primary Keys and Relationships in the DSV; Customizing Your Tables in the DSV Designer

Data Source Views in Depth

Notes:

Description based upon print version of record.

Includes bibliographical references.

ISBN:

9781283656351

1283656353

9781118223437

1118223438

OCLC:

815621155