05795nam 2200757Ia 450 991046224240332120210507153443.01-283-65635-31-118-22343-8(CKB)2670000000262367(EBL)818013(OCoLC)815621155(SSID)ssj0000773169(PQKBManifestationID)11493639(PQKBTitleCode)TC0000773169(PQKBWorkID)10829182(PQKB)11589401(MiAaPQ)EBC818013(CaSebORM)9781118237083(Au-PeEL)EBL818013(CaPaEBR)ebr10610361(CaONFJC)MIL396885(EXLCZ)99267000000026236720110928d2012 uy 0engur|n|---|||||txtccrProfessional Microsoft SQL Server 2012 Analysis Services with MDX and DAX[electronic resource] /by Sivakumar Harinath ... [et al.]1st editionHoboken, N.J. Wiley20121 online resource (1180 p.)Wrox programmer to programmerDescription based upon print version of record.1-118-23708-0 1-118-10110-3 Includes bibliographical references.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 ModeSQL 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 ToolsCreating 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 MembersNamed 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 AssignmentsRecursionFreeze 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 DesignerData Source Views in DepthUnderstand 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 howDatabase managementMDX (Computer program language)OLAP technologyRelational databasesClient/server computingElectronic books.Database management.MDX (Computer program language)OLAP technology.Relational databases.Client/server computing.005.74Harinath Sivakumar1971-943526Harinath Sivakumar1971-943526MiAaPQMiAaPQMiAaPQBOOK9910462242403321Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX2129441UNINA