Getting Started with SQL Server 2012 Cube Development.

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:
SQL server.
SQL server
Client/server computing.
Relational databases.
Client/server computing
Relational databases
Online Access:Click for online access
Table of Contents:
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

Similar Items