Getting Started with SQL Server 2012 Cube Development.

As a practical tutorial for Analysis Services, get started with developing cubes. ""Getting Started with SQL Server 2012 Cube Development"" walks you through the basics, working with SSAS to build cubes and get them up and running. Written for SQL Server developers who have not p...

Full description

Saved in:
Bibliographic Details
Main Author: Lidberg, Simon
Format: eBook
Language:English
Published: Packt Publishing, 2013.
Subjects:
Online Access:Click for online access

MARC

LEADER 00000cam a2200000Ma 4500
001 ocn858654954
003 OCoLC
005 20240809213013.0
006 m o d
007 cr |n|||||||||
008 130920s2013 xx o 000 0 eng d
040 |a IDEBK  |b eng  |e pn  |c IDEBK  |d HEBIS  |d OCLCQ  |d MHW  |d MEAUC  |d EBLCP  |d YDXCP  |d OCLCQ  |d FEM  |d ZCU  |d MERUC  |d OCLCQ  |d G3B  |d OCLCO  |d OCLCF  |d ICG  |d OCLCQ  |d OCLCO  |d DKC  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO  |d OCLCL  |d OCLKB  |d UEJ  |d OCLCQ 
019 |a 968047851  |a 969031064  |a 1428677485 
020 |a 1299865607  |q (ebk) 
020 |a 9781299865600  |q (ebk) 
020 |a 9781849689519 
020 |a 1849689512 
020 |a 9781849689502 
020 |a 1849689504 
035 |a (OCoLC)858654954  |z (OCoLC)968047851  |z (OCoLC)969031064  |z (OCoLC)1428677485 
037 |a 517811  |b MIL 
050 4 |a QA76.9 .C55 
049 |a HCDD 
100 1 |a Lidberg, Simon. 
245 1 0 |a Getting Started with SQL Server 2012 Cube Development. 
260 |b Packt Publishing,  |c 2013. 
300 |a 1 online resource 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
347 |a text file  |2 rda 
520 |a As a practical tutorial for Analysis Services, get started with developing cubes. ""Getting Started with SQL Server 2012 Cube Development"" walks you through the basics, working with SSAS to build cubes and get them up and running. Written for SQL Server developers who have not previously worked with Analysis Services. It is assumed that you have experience with relational databases, but no prior knowledge of cube development is required. You need SQL Server 2012 in order to follow along with the exercises in this book. 
505 0 |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Self-service Business Intelligence, Creating Value from Data; Identifying common user requirements for a business intelligence system; Creating a flexible reporting solution; Getting user value through self-service reporting; Summary; Chapter 2: Installing SSAS and Preparing for Cube Development; Understanding the BI semantic model architecture; Choosing the deployment mode; Actions; Aggregations; Custom assemblies; Custom rollups; Distinct count; Linked objects. 
505 8 |a Many-to-many relationshipsParent-child Hierarchies; Translations; Writeback; Tool support; Installing Analysis Services 2012 in multidimensional mode; Hands-on steps for installing Analysis Services; Hands-on steps for attaching the sample database; Starting SQL Server Data Tools for the first time; Choosing the correct project; Hands-on steps for creating your first cube project; Navigating the project environment; Solution Explorer; Properties window; Build menu; Hands-on steps for configuring your cube project; Summary; Chapter 3: Creating Your First Multidimensional Cube. 
505 8 |a An introduction to data warehousingUnderstanding data sources; Creating the data connection; Understanding the data source view; Creating a new data source view; Adding objects to the data source view; Extending the data source view; Understanding dimensions; Creating the Date dimension; Preparing the Date dimension for end users; Renaming attributes; Creating a hierarchy and attribute relationships; Processing the dimension to review the results; Creating the first cube; Creating the Fact Internet Sales cube; Creating additional dimensions and adding them to the cube; Summary. 
505 8 |a Chapter 4: Deploying and Processing CubesDeploying objects to Analysis Services; Deploying the FirstCube project to the server; Deploying projects using advanced deployment strategies; Processing objects in Analysis Services; Processing the FirstCube project; Using advanced processing options when processing cubes; Scheduling processing; Building a SSIS package to control processing; Troubleshooting processing errors; Partitioning cubes to speed up processing; Adding partitions to the FirstCube cube; Configuring storage modes in Analysis Services; MOLAP; ROLAP; HOLAP; Proactive caching. 
505 8 |a Adding a ROLAP dimension to the FirstCube cubeSummary; Chapter 5: Querying Your Cube; Understanding multidimensionality; Writing MDX queries using Management Studio; Connecting to the cube using Management Studio; Understanding the anatomy of an MDX query; The FROM clause; The WHERE clause; The query axis clause; Important query concepts; Unique names; Finding unique names of objects; Tuples; Sets; Calculated members; Named sets; Functions; Using Excel as the query tool against cubes; Connecting Excel to the FirstCube cube; Advanced Excel features; Named sets; Calculated measures. 
588 0 |a Print version record. 
630 0 0 |a SQL server. 
630 0 7 |a SQL server  |2 fast 
650 0 |a Client/server computing. 
650 0 |a Relational databases. 
650 7 |a Client/server computing  |2 fast 
650 7 |a Relational databases  |2 fast 
758 |i has work:  |a Getting started with SQL server 2012 cube development (Text)  |1 https://id.oclc.org/worldcat/entity/E39PCYCY66bd9hDFCh7ftrykJ8  |4 https://id.oclc.org/worldcat/ontology/hasWork 
776 0 8 |i Print version:  |z 9781299865600 
856 4 0 |u https://ebookcentral.proquest.com/lib/holycrosscollege-ebooks/detail.action?docID=1343643  |y Click for online access 
903 |a EBC-AC 
994 |a 92  |b HCD