Getting started with SQL server 2012 cube development :: learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach /
Analysis Services have been the number one OLAP engine for years. With the increased focus on business intelligence solutions, there is a shortage of professionals in this area. Start your journey into becoming a BI developer using the popular tools included in every SQL Server installation. Getting...
Gespeichert in:
| Hauptverfasser: | , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing,
2013.
|
| Schriftenreihe: | Professional expertise distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Analysis Services have been the number one OLAP engine for years. With the increased focus on business intelligence solutions, there is a shortage of professionals in this area. Start your journey into becoming a BI developer using the popular tools included in every SQL Server installation. Getting Started with SQL Server 2012 Cube Development teaches you through clear step-by-step exercises to create business intelligence solutions using Analysis Services. The knowledge gained through these practical examples can immediately be applied to your real-world problems. Getting Started with SQL Server 2012 Cube Development begins with an introduction to business intelligence and Analysis Services, the world's most-used cube engine. Guiding you through easy-to-understand examples to become a cube developer. Learn how to create a cube including all the advanced features such as KPIs, calculated measures, and time intelligence. Security and performance tuning will also be explored. You will learn how to perform and automate core tasks like deployment and processing. The main focus is on multidimensional cubes, but the creation of in-memory models will also be covered. You will learn everything you need to get started with cube development using SQL Server 2012. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (288 pages) : illustrations (some color), maps (some color) |
| ISBN: | 9781849689519 1849689512 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn861536153 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 131001s2013 enkabd o 001 0 eng d | ||
| 040 | |a E7B |b eng |e rda |e pn |c E7B |d OCLCO |d UMI |d COO |d S4S |d DEBBG |d DEBSZ |d OCLCQ |d OCLCF |d COCUF |d CNNOR |d PIFAG |d N$T |d AGLDB |d OCLCQ |d OCLCO |d U3W |d D6H |d STF |d OCLCQ |d VTS |d CEF |d NRAMU |d NLE |d INT |d VT2 |d OCLCQ |d UKMGB |d OCLCO |d G3B |d TKN |d OCLCQ |d OCLCO |d UAB |d UKAHL |d OCLCO |d QGK |d OCLCQ |d OCLCO |d OCLCL |d OCLCQ |d SFB | ||
| 016 | 7 | |a 018014067 |2 Uk | |
| 019 | |a 863646097 |a 865066195 |a 961601326 |a 962574755 |a 1259219208 | ||
| 020 | |a 9781849689519 |q (electronic bk.) | ||
| 020 | |a 1849689512 |q (electronic bk.) | ||
| 020 | |z 1849689504 | ||
| 020 | |z 9781849689502 | ||
| 035 | |a (OCoLC)861536153 |z (OCoLC)863646097 |z (OCoLC)865066195 |z (OCoLC)961601326 |z (OCoLC)962574755 |z (OCoLC)1259219208 | ||
| 037 | |a CL0500000342 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.C55 |b L53 2013eb | |
| 072 | 7 | |a COM0 |x 61000 |2 bisacsh | |
| 072 | 7 | |a COM |x 005030 |2 bisacsh | |
| 082 | 7 | |a 004.36 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Lidberg, Simon, |e author. | |
| 245 | 1 | 0 | |a Getting started with SQL server 2012 cube development : |b learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / |c Simon Lidberg ; graphics, Yuvraj Mannari. |
| 264 | 1 | |a Birmingham : |b Packt Publishing, |c 2013. | |
| 300 | |a 1 online resource (288 pages) : |b illustrations (some color), maps (some color) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 490 | 1 | |a Professional expertise distilled | |
| 588 | 0 | |a Online resource; title from PDF title page (ebrary, viewed October 1, 2013). | |
| 500 | |a Includes index. | ||
| 520 | 8 | |a Analysis Services have been the number one OLAP engine for years. With the increased focus on business intelligence solutions, there is a shortage of professionals in this area. Start your journey into becoming a BI developer using the popular tools included in every SQL Server installation. Getting Started with SQL Server 2012 Cube Development teaches you through clear step-by-step exercises to create business intelligence solutions using Analysis Services. The knowledge gained through these practical examples can immediately be applied to your real-world problems. Getting Started with SQL Server 2012 Cube Development begins with an introduction to business intelligence and Analysis Services, the world's most-used cube engine. Guiding you through easy-to-understand examples to become a cube developer. Learn how to create a cube including all the advanced features such as KPIs, calculated measures, and time intelligence. Security and performance tuning will also be explored. You will learn how to perform and automate core tasks like deployment and processing. The main focus is on multidimensional cubes, but the creation of in-memory models will also be covered. You will learn everything you need to get started with cube development using SQL Server 2012. | |
| 546 | |a English. | ||
| 505 | 0 | |a Intro -- Getting Started with SQL Server 2012 Cube Development -- Table of Contents -- Getting Started with SQL Server 2012 Cube Development -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Self-service Business Intelligence, Creating Value from Data -- Identifying common user requirements for a BI system -- Creating a flexible reporting solution -- Getting user value through self-service reporting -- Summary -- 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 relationships -- Parent-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 -- 3. Creating Your First Multidimensional Cube -- An introduction to data warehousing -- Understanding data sources -- Creating the data connection -- Understanding the data source view -- Creating a new data source view -- Adding objects to the data source view. | |
| 505 | 8 | |a 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 -- 4. Deploying and Processing Cubes -- Deploying 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 cube -- Summary -- 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 -- Calculated members -- Using Reporting Services together with your cube -- Summary -- 6. Adding Functionality to Your Cube -- Adding measures -- Adding additional measure groups -- Adding dimensions to the FirstCube project. | |
| 505 | 8 | |a Adding referenced dimensions -- Adding many-to-many dimensions -- Adding dimensions with parent-child hierarchies -- Adding calculations to cubes -- Simple calculated measures -- Adding advanced calculated measures -- Adding calculated members -- Time and date calculations -- Key Performance Indicators -- Adding perspectives to simplify cube browsing -- Adding translations to support global implementations -- Extending the cube with custom actions -- Building budget solutions using writeback -- Summary -- 7. Securing Your Cube Project -- Understanding role-based security -- Adding users to the fixed server role -- Adding custom roles to the database -- Securing objects in Analysis Services -- Adding dimension security to the FirstCube project -- Securing measures -- Implementing data security -- Testing data security -- Enable Visual Totals to restrict what a user can see -- Understanding security when a user belongs to several roles -- Implementing dynamic data security -- Summary -- 8. Using Aggregations to Performance Optimize a Cube -- Understanding cube aggregations -- Adding aggregations to improve performance -- Running the aggregation wizard -- Adding aggregations manually -- Using usage-based optimization to optimize the cube -- Summary -- 9. In-memory, the Future -- Understanding tabular models -- Installing a tabular mode instance -- Creating a tabular mode project -- Defining the workspace server -- Connecting to the data source -- Adding tables to the data model -- Adding data from other data sources -- Working with partitions in tabular models -- Creating calculations -- Adding calculated columns to the tabular model -- Creating calculated measures in the tabular model -- Creating advanced calculations -- Specifying other types of tables and columns -- KPIs -- Adding hierarchies -- Sorting data based on other columns. | |
| 505 | 8 | |a Hiding columns and tables from the end users -- Creating perspectives -- Adding security to your in-memory model -- Optimizing the tabular model for performance -- Querying tabular models -- Summary -- 10. Cubes in the Larger Context -- Using Microsoft frontend tools to query Analysis Services -- Developer-focused tools -- Using Reporting Services to query your cube -- SharePoint PerformancePoint Services -- Self-service tools -- Using Excel as a self-service tool against Analysis Services cubes -- Using Excel PowerPivot to allow user-created models -- SharePoint Excel Services -- Introducing Power View -- an analytical tool -- Third-party tools -- Summary -- Index. | |
| 630 | 0 | 0 | |a SQL server. |0 http://id.loc.gov/authorities/names/n90684343 |
| 630 | 0 | 7 | |a SQL server. |2 blmlsh |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a Client/server computing. |0 http://id.loc.gov/authorities/subjects/sh93000502 | |
| 650 | 0 | |a Relational databases. |0 http://id.loc.gov/authorities/subjects/sh86007768 | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 6 | |a Bases de données relationnelles. | |
| 650 | 7 | |a COMPUTERS |x Client-Server Computing. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Enterprise Applications |x Business Intelligence Tools. |2 bisacsh | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a Relational databases |2 fast | |
| 700 | 1 | |a Mannari, Yuvraj, |e author. | |
| 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 | |z 1849689504 | |
| 776 | 0 | |z 1299865607 | |
| 830 | 0 | |a Professional expertise distilled. |0 http://id.loc.gov/authorities/names/no2015143013 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=640349 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26851237 | ||
| 938 | |a ebrary |b EBRY |n ebr10764825 | ||
| 938 | |a EBSCOhost |b EBSC |n 640349 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn861536153 |
|---|---|
| _version_ | 1816882248485437441 |
| adam_text | |
| any_adam_object | |
| author | Lidberg, Simon Mannari, Yuvraj |
| author_facet | Lidberg, Simon Mannari, Yuvraj |
| author_role | aut aut |
| author_sort | Lidberg, Simon |
| author_variant | s l sl y m ym |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.C55 L53 2013eb |
| callnumber-search | QA76.9.C55 L53 2013eb |
| callnumber-sort | QA 276.9 C55 L53 42013EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Intro -- Getting Started with SQL Server 2012 Cube Development -- Table of Contents -- Getting Started with SQL Server 2012 Cube Development -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Self-service Business Intelligence, Creating Value from Data -- Identifying common user requirements for a BI system -- Creating a flexible reporting solution -- Getting user value through self-service reporting -- Summary -- 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 relationships -- Parent-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 -- 3. Creating Your First Multidimensional Cube -- An introduction to data warehousing -- Understanding 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 -- 4. Deploying and Processing Cubes -- Deploying 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 cube -- Summary -- 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 -- Calculated members -- Using Reporting Services together with your cube -- Summary -- 6. Adding Functionality to Your Cube -- Adding measures -- Adding additional measure groups -- Adding dimensions to the FirstCube project. Adding referenced dimensions -- Adding many-to-many dimensions -- Adding dimensions with parent-child hierarchies -- Adding calculations to cubes -- Simple calculated measures -- Adding advanced calculated measures -- Adding calculated members -- Time and date calculations -- Key Performance Indicators -- Adding perspectives to simplify cube browsing -- Adding translations to support global implementations -- Extending the cube with custom actions -- Building budget solutions using writeback -- Summary -- 7. Securing Your Cube Project -- Understanding role-based security -- Adding users to the fixed server role -- Adding custom roles to the database -- Securing objects in Analysis Services -- Adding dimension security to the FirstCube project -- Securing measures -- Implementing data security -- Testing data security -- Enable Visual Totals to restrict what a user can see -- Understanding security when a user belongs to several roles -- Implementing dynamic data security -- Summary -- 8. Using Aggregations to Performance Optimize a Cube -- Understanding cube aggregations -- Adding aggregations to improve performance -- Running the aggregation wizard -- Adding aggregations manually -- Using usage-based optimization to optimize the cube -- Summary -- 9. In-memory, the Future -- Understanding tabular models -- Installing a tabular mode instance -- Creating a tabular mode project -- Defining the workspace server -- Connecting to the data source -- Adding tables to the data model -- Adding data from other data sources -- Working with partitions in tabular models -- Creating calculations -- Adding calculated columns to the tabular model -- Creating calculated measures in the tabular model -- Creating advanced calculations -- Specifying other types of tables and columns -- KPIs -- Adding hierarchies -- Sorting data based on other columns. Hiding columns and tables from the end users -- Creating perspectives -- Adding security to your in-memory model -- Optimizing the tabular model for performance -- Querying tabular models -- Summary -- 10. Cubes in the Larger Context -- Using Microsoft frontend tools to query Analysis Services -- Developer-focused tools -- Using Reporting Services to query your cube -- SharePoint PerformancePoint Services -- Self-service tools -- Using Excel as a self-service tool against Analysis Services cubes -- Using Excel PowerPivot to allow user-created models -- SharePoint Excel Services -- Introducing Power View -- an analytical tool -- Third-party tools -- Summary -- Index. |
| ctrlnum | (OCoLC)861536153 |
| dewey-full | 004.36 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 004 - Computer science |
| dewey-raw | 004.36 |
| dewey-search | 004.36 |
| dewey-sort | 14.36 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>10814cam a2200709 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn861536153</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cn|||||||||</controlfield><controlfield tag="008">131001s2013 enkabd o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">E7B</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">E7B</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">S4S</subfield><subfield code="d">DEBBG</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">COCUF</subfield><subfield code="d">CNNOR</subfield><subfield code="d">PIFAG</subfield><subfield code="d">N$T</subfield><subfield code="d">AGLDB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">U3W</subfield><subfield code="d">D6H</subfield><subfield code="d">STF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">NRAMU</subfield><subfield code="d">NLE</subfield><subfield code="d">INT</subfield><subfield code="d">VT2</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCO</subfield><subfield code="d">G3B</subfield><subfield code="d">TKN</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UAB</subfield><subfield code="d">UKAHL</subfield><subfield code="d">OCLCO</subfield><subfield code="d">QGK</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">SFB</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018014067</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">863646097</subfield><subfield code="a">865066195</subfield><subfield code="a">961601326</subfield><subfield code="a">962574755</subfield><subfield code="a">1259219208</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849689519</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849689512</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1849689504</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849689502</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)861536153</subfield><subfield code="z">(OCoLC)863646097</subfield><subfield code="z">(OCoLC)865066195</subfield><subfield code="z">(OCoLC)961601326</subfield><subfield code="z">(OCoLC)962574755</subfield><subfield code="z">(OCoLC)1259219208</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000342</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.C55</subfield><subfield code="b">L53 2013eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM0</subfield><subfield code="x">61000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">005030</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">004.36</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Lidberg, Simon,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Getting started with SQL server 2012 cube development :</subfield><subfield code="b">learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach /</subfield><subfield code="c">Simon Lidberg ; graphics, Yuvraj Mannari.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2013.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (288 pages) :</subfield><subfield code="b">illustrations (some color), maps (some color)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Professional expertise distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from PDF title page (ebrary, viewed October 1, 2013).</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Analysis Services have been the number one OLAP engine for years. With the increased focus on business intelligence solutions, there is a shortage of professionals in this area. Start your journey into becoming a BI developer using the popular tools included in every SQL Server installation. Getting Started with SQL Server 2012 Cube Development teaches you through clear step-by-step exercises to create business intelligence solutions using Analysis Services. The knowledge gained through these practical examples can immediately be applied to your real-world problems. Getting Started with SQL Server 2012 Cube Development begins with an introduction to business intelligence and Analysis Services, the world's most-used cube engine. Guiding you through easy-to-understand examples to become a cube developer. Learn how to create a cube including all the advanced features such as KPIs, calculated measures, and time intelligence. Security and performance tuning will also be explored. You will learn how to perform and automate core tasks like deployment and processing. The main focus is on multidimensional cubes, but the creation of in-memory models will also be covered. You will learn everything you need to get started with cube development using SQL Server 2012.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Intro -- Getting Started with SQL Server 2012 Cube Development -- Table of Contents -- Getting Started with SQL Server 2012 Cube Development -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Self-service Business Intelligence, Creating Value from Data -- Identifying common user requirements for a BI system -- Creating a flexible reporting solution -- Getting user value through self-service reporting -- Summary -- 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 relationships -- Parent-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 -- 3. Creating Your First Multidimensional Cube -- An introduction to data warehousing -- Understanding data sources -- Creating the data connection -- Understanding the data source view -- Creating a new data source view -- Adding objects to the data source view.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">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 -- 4. Deploying and Processing Cubes -- Deploying 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 cube -- Summary -- 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 -- Calculated members -- Using Reporting Services together with your cube -- Summary -- 6. Adding Functionality to Your Cube -- Adding measures -- Adding additional measure groups -- Adding dimensions to the FirstCube project.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Adding referenced dimensions -- Adding many-to-many dimensions -- Adding dimensions with parent-child hierarchies -- Adding calculations to cubes -- Simple calculated measures -- Adding advanced calculated measures -- Adding calculated members -- Time and date calculations -- Key Performance Indicators -- Adding perspectives to simplify cube browsing -- Adding translations to support global implementations -- Extending the cube with custom actions -- Building budget solutions using writeback -- Summary -- 7. Securing Your Cube Project -- Understanding role-based security -- Adding users to the fixed server role -- Adding custom roles to the database -- Securing objects in Analysis Services -- Adding dimension security to the FirstCube project -- Securing measures -- Implementing data security -- Testing data security -- Enable Visual Totals to restrict what a user can see -- Understanding security when a user belongs to several roles -- Implementing dynamic data security -- Summary -- 8. Using Aggregations to Performance Optimize a Cube -- Understanding cube aggregations -- Adding aggregations to improve performance -- Running the aggregation wizard -- Adding aggregations manually -- Using usage-based optimization to optimize the cube -- Summary -- 9. In-memory, the Future -- Understanding tabular models -- Installing a tabular mode instance -- Creating a tabular mode project -- Defining the workspace server -- Connecting to the data source -- Adding tables to the data model -- Adding data from other data sources -- Working with partitions in tabular models -- Creating calculations -- Adding calculated columns to the tabular model -- Creating calculated measures in the tabular model -- Creating advanced calculations -- Specifying other types of tables and columns -- KPIs -- Adding hierarchies -- Sorting data based on other columns.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Hiding columns and tables from the end users -- Creating perspectives -- Adding security to your in-memory model -- Optimizing the tabular model for performance -- Querying tabular models -- Summary -- 10. Cubes in the Larger Context -- Using Microsoft frontend tools to query Analysis Services -- Developer-focused tools -- Using Reporting Services to query your cube -- SharePoint PerformancePoint Services -- Self-service tools -- Using Excel as a self-service tool against Analysis Services cubes -- Using Excel PowerPivot to allow user-created models -- SharePoint Excel Services -- Introducing Power View -- an analytical tool -- Third-party tools -- Summary -- Index.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">SQL server.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n90684343</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SQL server.</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SQL server</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Client/server computing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh93000502</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Relational databases.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86007768</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données relationnelles.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Client-Server Computing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Enterprise Applications</subfield><subfield code="x">Business Intelligence Tools.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Client/server computing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Relational databases</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Mannari, Yuvraj,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Getting started with SQL server 2012 cube development (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCYCY66bd9hDFCh7ftrykJ8</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="z">1849689504</subfield></datafield><datafield tag="776" ind1="0" ind2=" "><subfield code="z">1299865607</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Professional expertise distilled.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2015143013</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=640349</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH26851237</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10764825</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">640349</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn861536153 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:25:36Z |
| institution | BVB |
| isbn | 9781849689519 1849689512 |
| language | English |
| oclc_num | 861536153 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (288 pages) : illustrations (some color), maps (some color) |
| psigel | ZDB-4-EBA |
| publishDate | 2013 |
| publishDateSearch | 2013 |
| publishDateSort | 2013 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Professional expertise distilled. |
| series2 | Professional expertise distilled |
| spelling | Lidberg, Simon, author. Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / Simon Lidberg ; graphics, Yuvraj Mannari. Birmingham : Packt Publishing, 2013. 1 online resource (288 pages) : illustrations (some color), maps (some color) text txt rdacontent computer c rdamedia online resource cr rdacarrier Professional expertise distilled Online resource; title from PDF title page (ebrary, viewed October 1, 2013). Includes index. Analysis Services have been the number one OLAP engine for years. With the increased focus on business intelligence solutions, there is a shortage of professionals in this area. Start your journey into becoming a BI developer using the popular tools included in every SQL Server installation. Getting Started with SQL Server 2012 Cube Development teaches you through clear step-by-step exercises to create business intelligence solutions using Analysis Services. The knowledge gained through these practical examples can immediately be applied to your real-world problems. Getting Started with SQL Server 2012 Cube Development begins with an introduction to business intelligence and Analysis Services, the world's most-used cube engine. Guiding you through easy-to-understand examples to become a cube developer. Learn how to create a cube including all the advanced features such as KPIs, calculated measures, and time intelligence. Security and performance tuning will also be explored. You will learn how to perform and automate core tasks like deployment and processing. The main focus is on multidimensional cubes, but the creation of in-memory models will also be covered. You will learn everything you need to get started with cube development using SQL Server 2012. English. Intro -- Getting Started with SQL Server 2012 Cube Development -- Table of Contents -- Getting Started with SQL Server 2012 Cube Development -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Self-service Business Intelligence, Creating Value from Data -- Identifying common user requirements for a BI system -- Creating a flexible reporting solution -- Getting user value through self-service reporting -- Summary -- 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 relationships -- Parent-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 -- 3. Creating Your First Multidimensional Cube -- An introduction to data warehousing -- Understanding 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 -- 4. Deploying and Processing Cubes -- Deploying 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 cube -- Summary -- 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 -- Calculated members -- Using Reporting Services together with your cube -- Summary -- 6. Adding Functionality to Your Cube -- Adding measures -- Adding additional measure groups -- Adding dimensions to the FirstCube project. Adding referenced dimensions -- Adding many-to-many dimensions -- Adding dimensions with parent-child hierarchies -- Adding calculations to cubes -- Simple calculated measures -- Adding advanced calculated measures -- Adding calculated members -- Time and date calculations -- Key Performance Indicators -- Adding perspectives to simplify cube browsing -- Adding translations to support global implementations -- Extending the cube with custom actions -- Building budget solutions using writeback -- Summary -- 7. Securing Your Cube Project -- Understanding role-based security -- Adding users to the fixed server role -- Adding custom roles to the database -- Securing objects in Analysis Services -- Adding dimension security to the FirstCube project -- Securing measures -- Implementing data security -- Testing data security -- Enable Visual Totals to restrict what a user can see -- Understanding security when a user belongs to several roles -- Implementing dynamic data security -- Summary -- 8. Using Aggregations to Performance Optimize a Cube -- Understanding cube aggregations -- Adding aggregations to improve performance -- Running the aggregation wizard -- Adding aggregations manually -- Using usage-based optimization to optimize the cube -- Summary -- 9. In-memory, the Future -- Understanding tabular models -- Installing a tabular mode instance -- Creating a tabular mode project -- Defining the workspace server -- Connecting to the data source -- Adding tables to the data model -- Adding data from other data sources -- Working with partitions in tabular models -- Creating calculations -- Adding calculated columns to the tabular model -- Creating calculated measures in the tabular model -- Creating advanced calculations -- Specifying other types of tables and columns -- KPIs -- Adding hierarchies -- Sorting data based on other columns. Hiding columns and tables from the end users -- Creating perspectives -- Adding security to your in-memory model -- Optimizing the tabular model for performance -- Querying tabular models -- Summary -- 10. Cubes in the Larger Context -- Using Microsoft frontend tools to query Analysis Services -- Developer-focused tools -- Using Reporting Services to query your cube -- SharePoint PerformancePoint Services -- Self-service tools -- Using Excel as a self-service tool against Analysis Services cubes -- Using Excel PowerPivot to allow user-created models -- SharePoint Excel Services -- Introducing Power View -- an analytical tool -- Third-party tools -- Summary -- Index. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Architecture client-serveur (Informatique) Bases de données relationnelles. COMPUTERS Client-Server Computing. bisacsh COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh Client/server computing fast Relational databases fast Mannari, Yuvraj, author. has work: Getting started with SQL server 2012 cube development (Text) https://id.oclc.org/worldcat/entity/E39PCYCY66bd9hDFCh7ftrykJ8 https://id.oclc.org/worldcat/ontology/hasWork 1849689504 1299865607 Professional expertise distilled. http://id.loc.gov/authorities/names/no2015143013 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=640349 Volltext |
| spellingShingle | Lidberg, Simon Mannari, Yuvraj Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / Professional expertise distilled. Intro -- Getting Started with SQL Server 2012 Cube Development -- Table of Contents -- Getting Started with SQL Server 2012 Cube Development -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 1. Self-service Business Intelligence, Creating Value from Data -- Identifying common user requirements for a BI system -- Creating a flexible reporting solution -- Getting user value through self-service reporting -- Summary -- 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 relationships -- Parent-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 -- 3. Creating Your First Multidimensional Cube -- An introduction to data warehousing -- Understanding 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 -- 4. Deploying and Processing Cubes -- Deploying 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 cube -- Summary -- 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 -- Calculated members -- Using Reporting Services together with your cube -- Summary -- 6. Adding Functionality to Your Cube -- Adding measures -- Adding additional measure groups -- Adding dimensions to the FirstCube project. Adding referenced dimensions -- Adding many-to-many dimensions -- Adding dimensions with parent-child hierarchies -- Adding calculations to cubes -- Simple calculated measures -- Adding advanced calculated measures -- Adding calculated members -- Time and date calculations -- Key Performance Indicators -- Adding perspectives to simplify cube browsing -- Adding translations to support global implementations -- Extending the cube with custom actions -- Building budget solutions using writeback -- Summary -- 7. Securing Your Cube Project -- Understanding role-based security -- Adding users to the fixed server role -- Adding custom roles to the database -- Securing objects in Analysis Services -- Adding dimension security to the FirstCube project -- Securing measures -- Implementing data security -- Testing data security -- Enable Visual Totals to restrict what a user can see -- Understanding security when a user belongs to several roles -- Implementing dynamic data security -- Summary -- 8. Using Aggregations to Performance Optimize a Cube -- Understanding cube aggregations -- Adding aggregations to improve performance -- Running the aggregation wizard -- Adding aggregations manually -- Using usage-based optimization to optimize the cube -- Summary -- 9. In-memory, the Future -- Understanding tabular models -- Installing a tabular mode instance -- Creating a tabular mode project -- Defining the workspace server -- Connecting to the data source -- Adding tables to the data model -- Adding data from other data sources -- Working with partitions in tabular models -- Creating calculations -- Adding calculated columns to the tabular model -- Creating calculated measures in the tabular model -- Creating advanced calculations -- Specifying other types of tables and columns -- KPIs -- Adding hierarchies -- Sorting data based on other columns. Hiding columns and tables from the end users -- Creating perspectives -- Adding security to your in-memory model -- Optimizing the tabular model for performance -- Querying tabular models -- Summary -- 10. Cubes in the Larger Context -- Using Microsoft frontend tools to query Analysis Services -- Developer-focused tools -- Using Reporting Services to query your cube -- SharePoint PerformancePoint Services -- Self-service tools -- Using Excel as a self-service tool against Analysis Services cubes -- Using Excel PowerPivot to allow user-created models -- SharePoint Excel Services -- Introducing Power View -- an analytical tool -- Third-party tools -- Summary -- Index. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Architecture client-serveur (Informatique) Bases de données relationnelles. COMPUTERS Client-Server Computing. bisacsh COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh Client/server computing fast Relational databases fast |
| subject_GND | http://id.loc.gov/authorities/names/n90684343 http://id.loc.gov/authorities/subjects/sh93000502 http://id.loc.gov/authorities/subjects/sh86007768 |
| title | Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / |
| title_auth | Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / |
| title_exact_search | Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / |
| title_full | Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / Simon Lidberg ; graphics, Yuvraj Mannari. |
| title_fullStr | Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / Simon Lidberg ; graphics, Yuvraj Mannari. |
| title_full_unstemmed | Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / Simon Lidberg ; graphics, Yuvraj Mannari. |
| title_short | Getting started with SQL server 2012 cube development : |
| title_sort | getting started with sql server 2012 cube development learn to develop and query analysis services cubes and models with a practical step by step approach |
| title_sub | learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / |
| topic | SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 Relational databases. http://id.loc.gov/authorities/subjects/sh86007768 Architecture client-serveur (Informatique) Bases de données relationnelles. COMPUTERS Client-Server Computing. bisacsh COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh Client/server computing fast Relational databases fast |
| topic_facet | SQL server. SQL server Client/server computing. Relational databases. Architecture client-serveur (Informatique) Bases de données relationnelles. COMPUTERS Client-Server Computing. COMPUTERS Enterprise Applications Business Intelligence Tools. Client/server computing Relational databases |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=640349 |
| work_keys_str_mv | AT lidbergsimon gettingstartedwithsqlserver2012cubedevelopmentlearntodevelopandqueryanalysisservicescubesandmodelswithapracticalstepbystepapproach AT mannariyuvraj gettingstartedwithsqlserver2012cubedevelopmentlearntodevelopandqueryanalysisservicescubesandmodelswithapracticalstepbystepapproach |