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

• Autore: Harinath Sivakumar <1971->
• Pubblicazione: Hoboken, N.J., : Wiley, 2012
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (1180 p.)
• Disciplina: 005.74
• Soggetto topico: Database management; MDX (Computer program language); OLAP technology; Relational databases; Client/server computing
• Altri autori: HarinathSivakumar <1971->
• Note generali: Description based upon print version of record.
• Nota di bibliografia: Includes bibliographical references.
• Nota di contenuto: 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
• Sommario/riassunto: 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
• Titolo autorizzato: Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX
• ISBN: 1-283-65635-3; 1-118-22343-8
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910785739203321
• Lo trovi qui: Univ. Federico II