Expert Cube Development with SSAS Multidimensional Models :: Expert Tips and Tricks for Designing Analysis Services Multidimensional Models /
"An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wis...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UK :
Packt Pub.,
2014.
|
| Ausgabe: | 2nd ed. |
| Schriftenreihe: | Professional expertise distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | "An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you. You are expected to have some prior experience with Analysis Services cube development."-- |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (1 volume) : illustrations |
| ISBN: | 9781849689915 1849689911 |
Internformat
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn874011905 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 140320s2014 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e pn |c UMI |d E7B |d COO |d DEBBG |d DEBSZ |d OCLCQ |d OCLCO |d OCLCF |d OCLCQ |d OCLCA |d LLB |d TJC |d NKT |d D6H |d COCUF |d CNNOR |d OCLCQ |d MOR |d CCO |d PIFAG |d N$T |d EBLCP |d S4S |d YDXCP |d ZCU |d AGLDB |d MERUC |d OCLCQ |d OCLCO |d VTS |d ICG |d AU@ |d OCLCQ |d OCLCO |d STF |d DKC |d OCLCQ |d OCLCO |d OCLCQ |d AJS |d OCLCO |d OCLCQ |d OCLCO |d OCLCL |d UEJ |d OCLCQ | ||
| 019 | |a 871223823 |a 900419739 | ||
| 020 | |a 9781849689915 |q (electronic bk.) | ||
| 020 | |a 1849689911 |q (electronic bk.) | ||
| 020 | |z 9781849689908 | ||
| 020 | |z 1849689903 | ||
| 035 | |a (OCoLC)874011905 |z (OCoLC)871223823 |z (OCoLC)900419739 | ||
| 037 | |a CL0500000404 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.C55 |b W433 2014eb | |
| 072 | 7 | |a COM |x 013000 |2 bisacsh | |
| 072 | 7 | |a COM |x 014000 |2 bisacsh | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 072 | 7 | |a COM |x 067000 |2 bisacsh | |
| 072 | 7 | |a COM |x 032000 |2 bisacsh | |
| 072 | 7 | |a COM |x 037000 |2 bisacsh | |
| 072 | 7 | |a COM |x 052000 |2 bisacsh | |
| 082 | 7 | |a 004.36 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Webb, Chris, |d 1975- |1 https://id.oclc.org/worldcat/entity/E39PCjyTDYG77GJ3gPdrwyXxcP |0 http://id.loc.gov/authorities/names/no2012119872 | |
| 245 | 1 | 0 | |a Expert Cube Development with SSAS Multidimensional Models : |b Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / |c Chris Webb, Marco Russo, Alberto Ferrari. |
| 250 | |a 2nd ed. | ||
| 260 | |a Birmingham, UK : |b Packt Pub., |c 2014. | ||
| 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 Professional expertise distilled | |
| 588 | 0 | |a Online resources; title from thumbnail of cover on resource description page (Safari, viewed March 10, 2014). | |
| 500 | |a Includes index. | ||
| 520 | |a "An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you. You are expected to have some prior experience with Analysis Services cube development."-- |c Provided by publisher | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keys. | |
| 505 | 8 | |a Unknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services project. | |
| 505 | 8 | |a Creating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDs. | |
| 505 | 8 | |a Modeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tables. | |
| 505 | 8 | |a MDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures -- a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modeling. | |
| 630 | 0 | 0 | |a SQL server. |0 http://id.loc.gov/authorities/names/n90684343 |
| 630 | 0 | 7 | |a SQL server |2 fast |
| 650 | 0 | |a OLAP technology. |0 http://id.loc.gov/authorities/subjects/sh99002794 | |
| 650 | 0 | |a SQL (Computer program language) |0 http://id.loc.gov/authorities/subjects/sh86006628 | |
| 650 | 0 | |a Client/server computing. |0 http://id.loc.gov/authorities/subjects/sh93000502 | |
| 650 | 6 | |a OLAP, Technologie. | |
| 650 | 6 | |a SQL (Langage de programmation) | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 7 | |a COMPUTERS |x Computer Literacy. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Computer Science. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Hardware |x General. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Information Technology. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Machine Theory. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Reference. |2 bisacsh | |
| 650 | 7 | |a Client/server computing |2 fast | |
| 650 | 7 | |a OLAP technology |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 700 | 1 | |a Ferrari, Alberto, |d 1966- |e author. |1 https://id.oclc.org/worldcat/entity/E39PCjyvC87GtxJ4kmgDHcQfxC |0 http://id.loc.gov/authorities/names/no2011065236 | |
| 700 | 1 | |a Russo, Marco, |d 1969- |e author. |1 https://id.oclc.org/worldcat/entity/E39PBJh8TjQvJBtmftBmJcQyVC |0 http://id.loc.gov/authorities/names/no2011135906 | |
| 758 | |i has work: |a Expert Cube Development with SSAS Multidimensional Models (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFHdJj6x3TdqMXk7PjchgX |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 830 | 0 | |a Professional expertise distilled. | |
| 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=708310 |3 Volltext |
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL1572948 | ||
| 938 | |a ebrary |b EBRY |n ebr10842718 | ||
| 938 | |a EBSCOhost |b EBSC |n 708310 | ||
| 938 | |a YBP Library Services |b YANK |n 11680447 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn874011905 |
|---|---|
| _version_ | 1816882264790794240 |
| adam_text | |
| any_adam_object | |
| author | Webb, Chris, 1975- Ferrari, Alberto, 1966- Russo, Marco, 1969- |
| author_GND | http://id.loc.gov/authorities/names/no2012119872 http://id.loc.gov/authorities/names/no2011065236 http://id.loc.gov/authorities/names/no2011135906 |
| author_facet | Webb, Chris, 1975- Ferrari, Alberto, 1966- Russo, Marco, 1969- |
| author_role | aut aut |
| author_sort | Webb, Chris, 1975- |
| author_variant | c w cw a f af m r mr |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.C55 W433 2014eb |
| callnumber-search | QA76.9.C55 W433 2014eb |
| callnumber-sort | QA 276.9 C55 W433 42014EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keys. Unknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services project. Creating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDs. Modeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tables. MDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures -- a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modeling. |
| ctrlnum | (OCoLC)874011905 |
| 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 |
| edition | 2nd ed. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07431cam a2200853 a 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn874011905</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr unu||||||||</controlfield><controlfield tag="008">140320s2014 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">E7B</subfield><subfield code="d">COO</subfield><subfield code="d">DEBBG</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCA</subfield><subfield code="d">LLB</subfield><subfield code="d">TJC</subfield><subfield code="d">NKT</subfield><subfield code="d">D6H</subfield><subfield code="d">COCUF</subfield><subfield code="d">CNNOR</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MOR</subfield><subfield code="d">CCO</subfield><subfield code="d">PIFAG</subfield><subfield code="d">N$T</subfield><subfield code="d">EBLCP</subfield><subfield code="d">S4S</subfield><subfield code="d">YDXCP</subfield><subfield code="d">ZCU</subfield><subfield code="d">AGLDB</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">VTS</subfield><subfield code="d">ICG</subfield><subfield code="d">AU@</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">STF</subfield><subfield code="d">DKC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">AJS</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="019" ind1=" " ind2=" "><subfield code="a">871223823</subfield><subfield code="a">900419739</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781849689915</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1849689911</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781849689908</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1849689903</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)874011905</subfield><subfield code="z">(OCoLC)871223823</subfield><subfield code="z">(OCoLC)900419739</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000404</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">W433 2014eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">013000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">014000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">067000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">032000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">037000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">052000</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">Webb, Chris,</subfield><subfield code="d">1975-</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCjyTDYG77GJ3gPdrwyXxcP</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2012119872</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Expert Cube Development with SSAS Multidimensional Models :</subfield><subfield code="b">Expert Tips and Tricks for Designing Analysis Services Multidimensional Models /</subfield><subfield code="c">Chris Webb, Marco Russo, Alberto Ferrari.</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, UK :</subfield><subfield code="b">Packt Pub.,</subfield><subfield code="c">2014.</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">Professional expertise distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resources; title from thumbnail of cover on resource description page (Safari, viewed March 10, 2014).</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">"An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you. You are expected to have some prior experience with Analysis Services cube development."--</subfield><subfield code="c">Provided by publisher</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: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keys.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Unknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services project.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Creating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDs.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Modeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tables.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">MDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures -- a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modeling.</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">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">OLAP technology.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh99002794</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">SQL (Computer program language)</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh86006628</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="6"><subfield code="a">OLAP, Technologie.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">SQL (Langage de programmation)</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Architecture client-serveur (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Computer Literacy.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Computer Science.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Hardware</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Information Technology.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Machine Theory.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Reference.</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">OLAP technology</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Ferrari, Alberto,</subfield><subfield code="d">1966-</subfield><subfield code="e">author.</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCjyvC87GtxJ4kmgDHcQfxC</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2011065236</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Russo, Marco,</subfield><subfield code="d">1969-</subfield><subfield code="e">author.</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PBJh8TjQvJBtmftBmJcQyVC</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2011135906</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Expert Cube Development with SSAS Multidimensional Models (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCFHdJj6x3TdqMXk7PjchgX</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Professional expertise distilled.</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=708310</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest Ebook Central</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1572948</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10842718</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">708310</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">11680447</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-ocn874011905 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:25:51Z |
| institution | BVB |
| isbn | 9781849689915 1849689911 |
| language | English |
| oclc_num | 874011905 |
| 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 | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Pub., |
| record_format | marc |
| series | Professional expertise distilled. |
| series2 | Professional expertise distilled |
| spelling | Webb, Chris, 1975- https://id.oclc.org/worldcat/entity/E39PCjyTDYG77GJ3gPdrwyXxcP http://id.loc.gov/authorities/names/no2012119872 Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / Chris Webb, Marco Russo, Alberto Ferrari. 2nd ed. Birmingham, UK : Packt Pub., 2014. 1 online resource (1 volume) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Professional expertise distilled Online resources; title from thumbnail of cover on resource description page (Safari, viewed March 10, 2014). Includes index. "An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you. You are expected to have some prior experience with Analysis Services cube development."-- Provided by publisher Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keys. Unknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services project. Creating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDs. Modeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tables. MDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures -- a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modeling. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server fast OLAP technology. http://id.loc.gov/authorities/subjects/sh99002794 SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 OLAP, Technologie. SQL (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. bisacsh COMPUTERS Computer Science. bisacsh COMPUTERS Data Processing. bisacsh COMPUTERS Hardware General. bisacsh COMPUTERS Information Technology. bisacsh COMPUTERS Machine Theory. bisacsh COMPUTERS Reference. bisacsh Client/server computing fast OLAP technology fast SQL (Computer program language) fast Ferrari, Alberto, 1966- author. https://id.oclc.org/worldcat/entity/E39PCjyvC87GtxJ4kmgDHcQfxC http://id.loc.gov/authorities/names/no2011065236 Russo, Marco, 1969- author. https://id.oclc.org/worldcat/entity/E39PBJh8TjQvJBtmftBmJcQyVC http://id.loc.gov/authorities/names/no2011135906 has work: Expert Cube Development with SSAS Multidimensional Models (Text) https://id.oclc.org/worldcat/entity/E39PCFHdJj6x3TdqMXk7PjchgX https://id.oclc.org/worldcat/ontology/hasWork Professional expertise distilled. FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=708310 Volltext |
| spellingShingle | Webb, Chris, 1975- Ferrari, Alberto, 1966- Russo, Marco, 1969- Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / Professional expertise distilled. Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Designing the Data Warehouse for Analysis Services; The source database; The OLTP database; The data warehouse; The data mart; Data modeling for Analysis Services; Fact tables and dimension tables; Star schemas and snowflake schemas; Junk dimensions; Degenerate dimensions; Slowly Changing Dimensions; Bridge tables or factless fact tables; Snapshot and transaction fact tables; Updating fact and dimension tables; Natural and surrogate keys. Unknown Members, key errors, and NULLabilityPhysical database design for Analysis Services; Multiple data sources; Data types and Analysis Services; SQL queries generated during cube processing; Dimension processing; Dimensions with joined tables; Reference dimensions; Fact dimensions; Distinct Count measures; Indexes in the data mart; Usage of schemas; Naming conventions; Views versus the Data Source View; Summary; Chapter 2: Building Basic Dimensions and Cubes; Multidimensional and Tabular models; Choosing an edition of Analysis Services; Setting up a new Analysis Services project. Creating data sourcesCreating Data Source Views; Designing simple dimensions; Using the New Dimension wizard; Using the Dimension Editor; Adding new attributes; Configuring a Time dimension; Creating user hierarchies; Configuring attribute relationships; Building a simple cube; Using the New Cube wizard; Project deployment; Database processing; Summary; Chapter 3: Designing More Complex Dimensions; Grouping and banding; Grouping; Banding; Modeling Slowly Changing Dimensions; Type I SCDs; Type II SCDs; Modeling attribute relationships on a Type II SCD; Handling member status; Type III SCDs. Modeling junk dimensionsModeling ragged hierarchies; Modeling parent/child hierarchies; Ragged hierarchies with HideMemberIf; Summary; Chapter 4: Measures and Measure Groups; Measures and aggregation; Useful properties of measures; FormatString; DisplayFolders; Built-in measure aggregation types; Basic aggregation types; DistinctCount; None; Semi-additive aggregation types; ByAccount; Dimension calculations; Unary operators and weights; Custom Member Formulas; Non-aggregatable values; Measure groups; Creating multiple measure groups; Creating measure groups from dimension tables. MDX formulas versus pre-calculating valuesHandling different dimensionality; Handling different granularities; Non-aggregatable measures -- a different approach; Using linked dimensions and measure groups; Role-playing dimensions; Dimension/measure group relationships; Fact relationships; Referenced relationships; Data mining relationships; Summary; Chapter 5: Handling Transactional-level Data; Details about transactional data; Drillthrough; Actions; Drillthrough actions; Drillthrough columns order; Drillthrough and calculated members; Drillthrough modeling. SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server fast OLAP technology. http://id.loc.gov/authorities/subjects/sh99002794 SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 OLAP, Technologie. SQL (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. bisacsh COMPUTERS Computer Science. bisacsh COMPUTERS Data Processing. bisacsh COMPUTERS Hardware General. bisacsh COMPUTERS Information Technology. bisacsh COMPUTERS Machine Theory. bisacsh COMPUTERS Reference. bisacsh Client/server computing fast OLAP technology fast SQL (Computer program language) fast |
| subject_GND | http://id.loc.gov/authorities/names/n90684343 http://id.loc.gov/authorities/subjects/sh99002794 http://id.loc.gov/authorities/subjects/sh86006628 http://id.loc.gov/authorities/subjects/sh93000502 |
| title | Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / |
| title_auth | Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / |
| title_exact_search | Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / |
| title_full | Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / Chris Webb, Marco Russo, Alberto Ferrari. |
| title_fullStr | Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / Chris Webb, Marco Russo, Alberto Ferrari. |
| title_full_unstemmed | Expert Cube Development with SSAS Multidimensional Models : Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / Chris Webb, Marco Russo, Alberto Ferrari. |
| title_short | Expert Cube Development with SSAS Multidimensional Models : |
| title_sort | expert cube development with ssas multidimensional models expert tips and tricks for designing analysis services multidimensional models |
| title_sub | Expert Tips and Tricks for Designing Analysis Services Multidimensional Models / |
| topic | SQL server. http://id.loc.gov/authorities/names/n90684343 SQL server fast OLAP technology. http://id.loc.gov/authorities/subjects/sh99002794 SQL (Computer program language) http://id.loc.gov/authorities/subjects/sh86006628 Client/server computing. http://id.loc.gov/authorities/subjects/sh93000502 OLAP, Technologie. SQL (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. bisacsh COMPUTERS Computer Science. bisacsh COMPUTERS Data Processing. bisacsh COMPUTERS Hardware General. bisacsh COMPUTERS Information Technology. bisacsh COMPUTERS Machine Theory. bisacsh COMPUTERS Reference. bisacsh Client/server computing fast OLAP technology fast SQL (Computer program language) fast |
| topic_facet | SQL server. SQL server OLAP technology. SQL (Computer program language) Client/server computing. OLAP, Technologie. SQL (Langage de programmation) Architecture client-serveur (Informatique) COMPUTERS Computer Literacy. COMPUTERS Computer Science. COMPUTERS Data Processing. COMPUTERS Hardware General. COMPUTERS Information Technology. COMPUTERS Machine Theory. COMPUTERS Reference. Client/server computing OLAP technology |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=708310 |
| work_keys_str_mv | AT webbchris expertcubedevelopmentwithssasmultidimensionalmodelsexperttipsandtricksfordesigninganalysisservicesmultidimensionalmodels AT ferrarialberto expertcubedevelopmentwithssasmultidimensionalmodelsexperttipsandtricksfordesigninganalysisservicesmultidimensionalmodels AT russomarco expertcubedevelopmentwithssasmultidimensionalmodelsexperttipsandtricksfordesigninganalysisservicesmultidimensionalmodels |