SQL server analysis services 2012 cube development cookbook :: more than 100 recipes to develop business intelligence solutions using analysis services /
A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is i...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | , |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UK :
Packt Pub.,
2013.
|
| Schriftenreihe: | Quick answers to common problems.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required. |
| Beschreibung: | 1 online resource (1 volume) : illustrations |
| ISBN: | 9781849689816 1849689814 9781782170662 1782170669 9781782170679 1782170677 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn870467562 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 140213s2013 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d COO |d DEBBG |d DEBSZ |d N$T |d EBLCP |d IDEBK |d E7B |d YDXCP |d CHVBK |d OCLCF |d OCLCO |d OCLCQ |d OCL |d OCLCQ |d AGLDB |d ICA |d ZCU |d MERUC |d OCLCQ |d JBG |d OCLCO |d D6H |d VNS |d VTS |d CEF |d ICG |d NLE |d UKMGB |d OCLCQ |d OCLCO |d STF |d DKC |d AU@ |d OCLCQ |d UKAHL |d OCLCQ |d OCLCO |d OCLCQ |d K6U |d OCLCO |d OCLCQ |d OCLCO |d OCLCL |d UEJ |d OCLCQ | ||
| 015 | |a GBB6J3221 |2 bnb | ||
| 016 | 7 | |a 018014108 |2 Uk | |
| 016 | 7 | |a 018005515 |2 Uk | |
| 019 | |a 867317608 | ||
| 020 | |a 9781849689816 |q (electronic bk.) | ||
| 020 | |a 1849689814 |q (electronic bk.) | ||
| 020 | |a 9781782170662 | ||
| 020 | |a 1782170669 | ||
| 020 | |a 9781782170679 | ||
| 020 | |a 1782170677 | ||
| 020 | |z 9781849689809 | ||
| 020 | |z 1849689806 | ||
| 035 | |a (OCoLC)870467562 |z (OCoLC)867317608 | ||
| 037 | |a 9781849689816 |b Packt Publishing Pvt. Ltd | ||
| 050 | 4 | |a HD38.7 |b .D49 2013 | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 082 | 7 | |a 005.7585 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Dewald, Baya. | |
| 245 | 1 | 0 | |a SQL server analysis services 2012 cube development cookbook : |b more than 100 recipes to develop business intelligence solutions using analysis services / |c Baya Dewald, Steve Hughes, Paul Turley. |
| 260 | |a Birmingham, UK : |b Packt Pub., |c 2013. | ||
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 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 Quick answers to common problems | |
| 588 | 0 | |a Online resource; title from cover (Safari, viewed February 10, 2014). | |
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views. | |
| 505 | 8 | |a Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures. | |
| 505 | 8 | |a Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options. | |
| 505 | 8 | |a Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality. | |
| 505 | 8 | |a Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session. | |
| 520 | |a A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required. | ||
| 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 Business intelligence. |0 http://id.loc.gov/authorities/subjects/sh85018300 | |
| 650 | 0 | |a Data mining. |0 http://id.loc.gov/authorities/subjects/sh97002073 | |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a MDX (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh2002008553 | |
| 650 | 6 | |a Exploration de données (Informatique) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a MDX (Langage de programmation) | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Databases |x General. |2 bisacsh | |
| 650 | 7 | |a Business intelligence |2 fast | |
| 650 | 7 | |a Data mining |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a MDX (Computer program language) |2 fast | |
| 700 | 1 | |a Hughes, Steve. | |
| 700 | 1 | |a Turley, Paul, |d 1962- |1 https://id.oclc.org/worldcat/entity/E39PCjwqFmvM9yyTPYR6fVPjVK |0 http://id.loc.gov/authorities/names/n2004004075 | |
| 776 | 0 | 8 | |i Print version: |a Dewald, Baya. |t SQL Server Analysis Services 2012 Cube Development Cookbook. |d Birmingham : Packt Publishing, ©2013 |z 9781849689809 |
| 830 | 0 | |a Quick answers to common problems. |0 http://id.loc.gov/authorities/names/no2015091434 | |
| 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=680698 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26849674 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL1581056 | ||
| 938 | |a ebrary |b EBRY |n ebr10825553 | ||
| 938 | |a EBSCOhost |b EBSC |n 680698 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis27260897 | ||
| 938 | |a YBP Library Services |b YANK |n 11468639 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn870467562 |
|---|---|
| _version_ | 1816882260795719680 |
| adam_text | |
| any_adam_object | |
| author | Dewald, Baya |
| author2 | Hughes, Steve Turley, Paul, 1962- |
| author2_role | |
| author2_variant | s h sh p t pt |
| author_GND | http://id.loc.gov/authorities/names/n2004004075 |
| author_facet | Dewald, Baya Hughes, Steve Turley, Paul, 1962- |
| author_role | |
| author_sort | Dewald, Baya |
| author_variant | b d bd |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | H - Social Science |
| callnumber-label | HD38 |
| callnumber-raw | HD38.7 .D49 2013 |
| callnumber-search | HD38.7 .D49 2013 |
| callnumber-sort | HD 238.7 D49 42013 |
| callnumber-subject | HD - Industries, Land Use, Labor |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views. Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures. Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options. Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality. Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session. |
| ctrlnum | (OCoLC)870467562 |
| dewey-full | 005.7585 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7585 |
| dewey-search | 005.7585 |
| dewey-sort | 15.7585 |
| 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>07038cam a2200853 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn870467562</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cnu---unuuu</controlfield><controlfield tag="008">140213s2013 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UMI</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">COO</subfield><subfield code="d">DEBBG</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">N$T</subfield><subfield code="d">EBLCP</subfield><subfield code="d">IDEBK</subfield><subfield code="d">E7B</subfield><subfield code="d">YDXCP</subfield><subfield code="d">CHVBK</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">ZCU</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">JBG</subfield><subfield code="d">OCLCO</subfield><subfield code="d">D6H</subfield><subfield code="d">VNS</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">ICG</subfield><subfield code="d">NLE</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">DKC</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKAHL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">K6U</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">UEJ</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6J3221</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018014108</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018005515</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">867317608</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849689816</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849689814</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782170662</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782170669</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782170679</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782170677</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849689809</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1849689806</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)870467562</subfield><subfield code="z">(OCoLC)867317608</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">9781849689816</subfield><subfield code="b">Packt Publishing Pvt. Ltd</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">HD38.7</subfield><subfield code="b">.D49 2013</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.7585</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">Dewald, Baya.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL server analysis services 2012 cube development cookbook :</subfield><subfield code="b">more than 100 recipes to develop business intelligence solutions using analysis services /</subfield><subfield code="c">Baya Dewald, Steve Hughes, Paul Turley.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, UK :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2013.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 volume) :</subfield><subfield code="b">illustrations</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">Quick answers to common problems</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from cover (Safari, viewed February 10, 2014).</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required.</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">Business intelligence.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85018300</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Data mining.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh97002073</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">MDX (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh2002008553</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Exploration de données (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">MDX (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Databases</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Business intelligence</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data mining</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">MDX (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Hughes, Steve.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Turley, Paul,</subfield><subfield code="d">1962-</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCjwqFmvM9yyTPYR6fVPjVK</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2004004075</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Dewald, Baya.</subfield><subfield code="t">SQL Server Analysis Services 2012 Cube Development Cookbook.</subfield><subfield code="d">Birmingham : Packt Publishing, ©2013</subfield><subfield code="z">9781849689809</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Quick answers to common problems.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2015091434</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=680698</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">AH26849674</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest Ebook Central</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1581056</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10825553</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">680698</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis27260897</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">11468639</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-ocn870467562 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:25:47Z |
| institution | BVB |
| isbn | 9781849689816 1849689814 9781782170662 1782170669 9781782170679 1782170677 |
| language | English |
| oclc_num | 870467562 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (1 volume) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2013 |
| publishDateSearch | 2013 |
| publishDateSort | 2013 |
| publisher | Packt Pub., |
| record_format | marc |
| series | Quick answers to common problems. |
| series2 | Quick answers to common problems |
| spelling | Dewald, Baya. SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / Baya Dewald, Steve Hughes, Paul Turley. Birmingham, UK : Packt Pub., 2013. 1 online resource (1 volume) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Quick answers to common problems Online resource; title from cover (Safari, viewed February 10, 2014). Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views. Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures. Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options. Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality. Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session. A practical cookbook packed with recipes to help developers produce data cubes as quickly as possible by following step by step instructions, rather than explaining data mining concepts with SSAS. If you are a BI or ETL developer using SQL Server Analysis services to build OLAP cubes, this book is ideal for you. Prior knowledge of relational databases and experience with Excel as well as SQL development is required. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Business intelligence. http://id.loc.gov/authorities/subjects/sh85018300 Data mining. http://id.loc.gov/authorities/subjects/sh97002073 Database management. http://id.loc.gov/authorities/subjects/sh85035848 MDX (Computer program language) http://id.loc.gov/authorities/subjects/sh2002008553 Exploration de données (Informatique) Bases de données Gestion. MDX (Langage de programmation) COMPUTERS Programming Languages SQL. bisacsh COMPUTERS Databases General. bisacsh Business intelligence fast Data mining fast Database management fast MDX (Computer program language) fast Hughes, Steve. Turley, Paul, 1962- https://id.oclc.org/worldcat/entity/E39PCjwqFmvM9yyTPYR6fVPjVK http://id.loc.gov/authorities/names/n2004004075 Print version: Dewald, Baya. SQL Server Analysis Services 2012 Cube Development Cookbook. Birmingham : Packt Publishing, ©2013 9781849689809 Quick answers to common problems. http://id.loc.gov/authorities/names/no2015091434 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=680698 Volltext |
| spellingShingle | Dewald, Baya SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / Quick answers to common problems. Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Introduction to Multidimensional Data Model Design; Introduction; The business value of Business Intelligence; Challenges and barriers of effective BI; Overcoming BI challenges and barriers; Choosing multidimensional or Tabular models; Star- or Snowflake-relational schema; A sample scenario for choosing the Snowflake schema; Chapter 2: Defining Analysis Services Dimensions; Introduction; Defining data sources; Defining data source views. Defining entity relationships in DSVExtending data source views; Creating named calculations and queries; Creating simple dimensions; Building dimension hierarchies; Setting essential attribute properties; Browsing dimension data; Sorting the attributes; Customizing advanced attribute properties; Creating parent-child dimensions; Creating the date and time dimensions; Chapter 3: Creating Analysis Services Cubes; Introduction; Defining measure groups and measures; Setting measure properties; Browsing the cube data; Dimension usage with measure group; Examining cube file structures. Partitioning strategiesDefining partition slice; Merging partitions; Defining aggregation designs; Distinct count measure groups; Enabling write-back feature; Deployment options; Chapter 4: Extending and Customizing Cubes; Introduction; Defining calculated measures; Defining named sets; Defining drillthrough actions; Defining URL actions; Defining reporting actions; Defining key performance indicators; Defining perspectives; Defining translations; Defining measure expressions; Chapter 5: Optimizing Dimension and Cube Processing; Introduction; Understanding dimension processing options. Learning about basic dimension processingLearning advanced dimension processing options; Using out-of-line bindings for dimension processing; Dealing with partition processing options; Using SQL Server Integration Services to process Analysis Services objects; Monitoring and tuning processing performance; Chapter 6: MDX; Introduction; Returning data on the query axes; Limiting the query output; Sorting the query output; Defining query level calculations and named sets; Navigating dimension hierarchies; Working with the Time dimensions; MDX script's functionality. Monitoring and tuning MDX queriesChapter 7: Analysis Services Security; Introduction; Managing instance-level administrative security; Managing database-level security; Managing cube-level security; Managing dimension hierarchy-level security; Implementing dynamic dimension security; Implementing cell-level security; Chapter 8: Administering and Monitoring Analysis Services; Introduction; SSAS instance configuration options; Creating and dropping databases; Monitoring SSAS instance using Activity Viewer; Monitoring SSAS instance using DMVs; Cancelling a session. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Business intelligence. http://id.loc.gov/authorities/subjects/sh85018300 Data mining. http://id.loc.gov/authorities/subjects/sh97002073 Database management. http://id.loc.gov/authorities/subjects/sh85035848 MDX (Computer program language) http://id.loc.gov/authorities/subjects/sh2002008553 Exploration de données (Informatique) Bases de données Gestion. MDX (Langage de programmation) COMPUTERS Programming Languages SQL. bisacsh COMPUTERS Databases General. bisacsh Business intelligence fast Data mining fast Database management fast MDX (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/names/n90684343 http://id.loc.gov/authorities/subjects/sh85018300 http://id.loc.gov/authorities/subjects/sh97002073 http://id.loc.gov/authorities/subjects/sh85035848 http://id.loc.gov/authorities/subjects/sh2002008553 |
| title | SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / |
| title_auth | SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / |
| title_exact_search | SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / |
| title_full | SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / Baya Dewald, Steve Hughes, Paul Turley. |
| title_fullStr | SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / Baya Dewald, Steve Hughes, Paul Turley. |
| title_full_unstemmed | SQL server analysis services 2012 cube development cookbook : more than 100 recipes to develop business intelligence solutions using analysis services / Baya Dewald, Steve Hughes, Paul Turley. |
| title_short | SQL server analysis services 2012 cube development cookbook : |
| title_sort | sql server analysis services 2012 cube development cookbook more than 100 recipes to develop business intelligence solutions using analysis services |
| title_sub | more than 100 recipes to develop business intelligence solutions using analysis services / |
| topic | SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server. blmlsh SQL server fast Business intelligence. http://id.loc.gov/authorities/subjects/sh85018300 Data mining. http://id.loc.gov/authorities/subjects/sh97002073 Database management. http://id.loc.gov/authorities/subjects/sh85035848 MDX (Computer program language) http://id.loc.gov/authorities/subjects/sh2002008553 Exploration de données (Informatique) Bases de données Gestion. MDX (Langage de programmation) COMPUTERS Programming Languages SQL. bisacsh COMPUTERS Databases General. bisacsh Business intelligence fast Data mining fast Database management fast MDX (Computer program language) fast |
| topic_facet | SQL server. SQL server Business intelligence. Data mining. Database management. MDX (Computer program language) Exploration de données (Informatique) Bases de données Gestion. MDX (Langage de programmation) COMPUTERS Programming Languages SQL. COMPUTERS Databases General. Business intelligence Data mining Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=680698 |
| work_keys_str_mv | AT dewaldbaya sqlserveranalysisservices2012cubedevelopmentcookbookmorethan100recipestodevelopbusinessintelligencesolutionsusinganalysisservices AT hughessteve sqlserveranalysisservices2012cubedevelopmentcookbookmorethan100recipestodevelopbusinessintelligencesolutionsusinganalysisservices AT turleypaul sqlserveranalysisservices2012cubedevelopmentcookbookmorethan100recipestodevelopbusinessintelligencesolutionsusinganalysisservices |