LEADER 05763nam 2200745Ia 450 001 9910819524103321 005 20210507153443.0 010 $a1-283-65635-3 010 $a1-118-22343-8 035 $a(CKB)2670000000262367 035 $a(EBL)818013 035 $a(OCoLC)815621155 035 $a(SSID)ssj0000773169 035 $a(PQKBManifestationID)11493639 035 $a(PQKBTitleCode)TC0000773169 035 $a(PQKBWorkID)10829182 035 $a(PQKB)11589401 035 $a(Au-PeEL)EBL818013 035 $a(CaPaEBR)ebr10610361 035 $a(CaONFJC)MIL396885 035 $a(CaSebORM)9781118237083 035 $a(MiAaPQ)EBC818013 035 $a(EXLCZ)992670000000262367 100 $a20110928d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aProfessional Microsoft SQL Server 2012 Analysis Services with MDX and DAX$b[electronic resource] /$fby Sivakumar Harinath ... [et al.] 205 $a1st edition 210 $aHoboken, N.J. $cWiley$d2012 215 $a1 online resource (1180 p.) 225 1 $aWrox programmer to programmer 300 $aDescription based upon print version of record. 311 $a1-118-23708-0 311 $a1-118-10110-3 320 $aIncludes bibliographical references. 327 $aProfessional 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 327 $aSQL 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 327 $aCreating 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 327 $aNamed 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 327 $aRecursionFreeze 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 327 $aData Source Views in Depth 330 $aUnderstand 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 606 $aDatabase management 606 $aMDX (Computer program language) 606 $aOLAP technology 606 $aRelational databases 606 $aClient/server computing 615 0$aDatabase management. 615 0$aMDX (Computer program language) 615 0$aOLAP technology. 615 0$aRelational databases. 615 0$aClient/server computing. 676 $a005.74 700 $aHarinath$b Sivakumar$f1971-$01713086 701 $aHarinath$b Sivakumar$f1971-$01713086 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910819524103321 996 $aProfessional Microsoft SQL Server 2012 Analysis Services with MDX and DAX$94105780 997 $aUNINA