Real time analytics with SAP HANA :: enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics /
Chapter 5: Creating SAP HANA Artifacts - Analytical Privileges and Calculation Views -- Creating a restricted measure and a calculated measure -- Creating filters -- Steps for creating a filter -- Creating input parameters and variables -- Creating calculation views -- Analytical privileges -- Self-...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing,
2015.
|
| Schriftenreihe: | Professional expertise distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Chapter 5: Creating SAP HANA Artifacts - Analytical Privileges and Calculation Views -- Creating a restricted measure and a calculated measure -- Creating filters -- Steps for creating a filter -- Creating input parameters and variables -- Creating calculation views -- Analytical privileges -- Self-study questions -- Summary -- Chapter 6: Understanding Text Search and Hierarchies in SAP HANA -- Creating and using Full Text Search -- Enabling the search option -- Creating hierarchies -- Creating a level hierarchy -- Creating a parent-child hierarchy -- Self-study questions -- Summary -- Chapter 7: Using Decision Tables and Transporting SAP HANA Content -- What is a decision table? -- Why use decision tables? -- Transport management in SAP HANA -- SAP HANA application lifecycle manager -- Transporting a delivery unit with HALM -- Export and import - moving SAP HANA content manually -- Currency conversion in SAP HANA -- Self-study questions -- Summary -- Chapter 8: Consuming SAP HANA Data Models -- Connecting to the SAP HANA database -- Reporting tools for SAP HANA -- Analysis for Office -- SAP Business Objects Analysis for OLAP -- Using Microsoft Excel as a reporting tool -- Summary -- Chapter 9: An Introduction to Application Function Library -- Application Function Library -- Predictive Analysis Library -- Calling PAL functions -- Business Function Library -- Self-study questions -- Summary -- Index. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource : illustrations |
| ISBN: | 9781782174127 1782174125 1782174117 9781782174110 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn932247963 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 151215s2015 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d OCLCO |d OCLCF |d OCLCO |d OCLCA |d EBLCP |d N$T |d DEBBG |d DEBSZ |d OCLCQ |d MERUC |d CEF |d UKMGB |d OCLCQ |d OCLCO |d UAB |d OCLCQ |d OCLCO |d LOA |d OCLCO |d K6U |d OCLCQ |d OCLCO |d INARC |d OCLCQ |d OCLCL |d SXB | ||
| 016 | 7 | |a 018005590 |2 Uk | |
| 019 | |a 935250048 | ||
| 020 | |a 9781782174127 |q (electronic bk.) | ||
| 020 | |a 1782174125 |q (electronic bk.) | ||
| 020 | |a 1782174117 | ||
| 020 | |a 9781782174110 | ||
| 020 | |z 9781782174110 | ||
| 035 | |a (OCoLC)932247963 |z (OCoLC)935250048 | ||
| 037 | |a 9781782174127 |b Packt Publishing Pvt. Ltd | ||
| 050 | 4 | |a T58.6 | |
| 072 | 7 | |a BUS |x 082000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 041000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 042000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 085000 |2 bisacsh | |
| 082 | 7 | |a 658.4038 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Singh, Vinay, |e author. | |
| 245 | 1 | 0 | |a Real time analytics with SAP HANA : |b enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / |c Vinay Singh. |
| 264 | 1 | |a Birmingham : |b Packt Publishing, |c 2015. | |
| 300 | |a 1 online resource : |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 resource; title from PDF title page (EBSCO, viewed November 16, 2016). | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Kickoff -- Before SQLscript Start -- Introducing SAP HANA SQL -- Classical SQL -- The SAP HANA SQLscript -- Why SQLscript? -- How different is an SQLscript in SAP HANA from classical SQL queries? -- When should we use SQLScript? -- Procedures -- Creating with the SQL editor (in SAP HANA Studio) -- Procedure creation using the wizard -- JOINS in SAP HANA -- Unions versus JOINS -- Self-study questions -- Summary -- Chapter 2: The SAP HANA Data Modeling Approach -- Row and column storage in SAP HANA -- Choosing the right table -- A basic architecture of the SAP HANA engine -- Different modeling artifacts in SAP HANA -- Modeling principles -- The SAP HANA Studio -- Perspectives in SAP HANA Studio -- Adding our system to SAP HANA Studio -- The system view -- Different schemas in SAP HANA -- Creating package and delivery unit -- Deleting packages -- Delivery units -- Self-study questions -- Summary -- Chapter 3: Different Ways of SAP HANA Data Load -- Loading data from Flat file in SAP HANA -- Real-time replication via SAP SLT (System Landscape Transformation) Replication Server -- Loading data with SAP Direct Extractor -- Application server configuration -- Creating a DXC schema and user in SAP HANA -- Loading data in SAP HANA with Data Services Workbench -- SAP Replication Server -- Smart Data Access -- Self-study questions -- Summary -- Chapter 4: Creating SAP HANA Artifacts Attribute Views and Analytical Views -- Steps to adjust preferences -- Creating attribute views -- Defining attribute and key attribute -- Creating time attribute views -- Creating analytical views -- Creating other elements -- Calculated attribute -- Calculated measures -- Calculated columns -- Creating variables -- Self-study questions. | |
| 520 | |a Chapter 5: Creating SAP HANA Artifacts - Analytical Privileges and Calculation Views -- Creating a restricted measure and a calculated measure -- Creating filters -- Steps for creating a filter -- Creating input parameters and variables -- Creating calculation views -- Analytical privileges -- Self-study questions -- Summary -- Chapter 6: Understanding Text Search and Hierarchies in SAP HANA -- Creating and using Full Text Search -- Enabling the search option -- Creating hierarchies -- Creating a level hierarchy -- Creating a parent-child hierarchy -- Self-study questions -- Summary -- Chapter 7: Using Decision Tables and Transporting SAP HANA Content -- What is a decision table? -- Why use decision tables? -- Transport management in SAP HANA -- SAP HANA application lifecycle manager -- Transporting a delivery unit with HALM -- Export and import - moving SAP HANA content manually -- Currency conversion in SAP HANA -- Self-study questions -- Summary -- Chapter 8: Consuming SAP HANA Data Models -- Connecting to the SAP HANA database -- Reporting tools for SAP HANA -- Analysis for Office -- SAP Business Objects Analysis for OLAP -- Using Microsoft Excel as a reporting tool -- Summary -- Chapter 9: An Introduction to Application Function Library -- Application Function Library -- Predictive Analysis Library -- Calling PAL functions -- Business Function Library -- Self-study questions -- Summary -- Index. | ||
| 630 | 0 | 0 | |a SAP HANA (Electronic resource) |0 http://id.loc.gov/authorities/names/n2012057360 |
| 630 | 0 | 7 | |a SAP HANA (Electronic resource) |2 fast |
| 650 | 0 | |a Real-time data processing. |0 http://id.loc.gov/authorities/subjects/sh85111765 | |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 650 | 0 | |a Business enterprises |x Data processing. | |
| 650 | 6 | |a Temps réel (Informatique) | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 6 | |a Entreprises |x Informatique. | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Industrial Management. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Management. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Management Science. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Organizational Behavior. |2 bisacsh | |
| 650 | 7 | |a Business enterprises |x Data processing |2 fast | |
| 650 | 7 | |a Database management |2 fast | |
| 650 | 7 | |a Real-time data processing |2 fast | |
| 655 | 4 | |a Electronic book. | |
| 758 | |i has work: |a Real time analytics with SAP HANA (Text) |1 https://id.oclc.org/worldcat/entity/E39PCH7bhp3CfQ88hycd4mT3FC |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 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=1089588 |3 Volltext |
| 938 | |a Internet Archive |b INAR |n realtimeanalytic0000sing | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL4191106 | ||
| 938 | |a EBSCOhost |b EBSC |n 1089588 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn932247963 |
|---|---|
| _version_ | 1816882333154803712 |
| adam_text | |
| any_adam_object | |
| author | Singh, Vinay |
| author_facet | Singh, Vinay |
| author_role | aut |
| author_sort | Singh, Vinay |
| author_variant | v s vs |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | T - Technology |
| callnumber-label | T58 |
| callnumber-raw | T58.6 |
| callnumber-search | T58.6 |
| callnumber-sort | T 258.6 |
| callnumber-subject | T - General Technology |
| collection | ZDB-4-EBA |
| contents | Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Kickoff -- Before SQLscript Start -- Introducing SAP HANA SQL -- Classical SQL -- The SAP HANA SQLscript -- Why SQLscript? -- How different is an SQLscript in SAP HANA from classical SQL queries? -- When should we use SQLScript? -- Procedures -- Creating with the SQL editor (in SAP HANA Studio) -- Procedure creation using the wizard -- JOINS in SAP HANA -- Unions versus JOINS -- Self-study questions -- Summary -- Chapter 2: The SAP HANA Data Modeling Approach -- Row and column storage in SAP HANA -- Choosing the right table -- A basic architecture of the SAP HANA engine -- Different modeling artifacts in SAP HANA -- Modeling principles -- The SAP HANA Studio -- Perspectives in SAP HANA Studio -- Adding our system to SAP HANA Studio -- The system view -- Different schemas in SAP HANA -- Creating package and delivery unit -- Deleting packages -- Delivery units -- Self-study questions -- Summary -- Chapter 3: Different Ways of SAP HANA Data Load -- Loading data from Flat file in SAP HANA -- Real-time replication via SAP SLT (System Landscape Transformation) Replication Server -- Loading data with SAP Direct Extractor -- Application server configuration -- Creating a DXC schema and user in SAP HANA -- Loading data in SAP HANA with Data Services Workbench -- SAP Replication Server -- Smart Data Access -- Self-study questions -- Summary -- Chapter 4: Creating SAP HANA Artifacts Attribute Views and Analytical Views -- Steps to adjust preferences -- Creating attribute views -- Defining attribute and key attribute -- Creating time attribute views -- Creating analytical views -- Creating other elements -- Calculated attribute -- Calculated measures -- Calculated columns -- Creating variables -- Self-study questions. |
| ctrlnum | (OCoLC)932247963 |
| dewey-full | 658.4038 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.4038 |
| dewey-search | 658.4038 |
| dewey-sort | 3658.4038 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Wirtschaftswissenschaften |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06476cam a2200721 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn932247963</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">151215s2015 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">rda</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCA</subfield><subfield code="d">EBLCP</subfield><subfield code="d">N$T</subfield><subfield code="d">DEBBG</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MERUC</subfield><subfield code="d">CEF</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">UAB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">LOA</subfield><subfield code="d">OCLCO</subfield><subfield code="d">K6U</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">INARC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCL</subfield><subfield code="d">SXB</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018005590</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">935250048</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782174127</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782174125</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782174117</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782174110</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781782174110</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)932247963</subfield><subfield code="z">(OCoLC)935250048</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">9781782174127</subfield><subfield code="b">Packt Publishing Pvt. Ltd</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">T58.6</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">082000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">041000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">042000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">BUS</subfield><subfield code="x">085000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">658.4038</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">Singh, Vinay,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Real time analytics with SAP HANA :</subfield><subfield code="b">enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics /</subfield><subfield code="c">Vinay Singh.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2015.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource :</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 resource; title from PDF title page (EBSCO, viewed November 16, 2016).</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Kickoff -- Before SQLscript Start -- Introducing SAP HANA SQL -- Classical SQL -- The SAP HANA SQLscript -- Why SQLscript? -- How different is an SQLscript in SAP HANA from classical SQL queries? -- When should we use SQLScript? -- Procedures -- Creating with the SQL editor (in SAP HANA Studio) -- Procedure creation using the wizard -- JOINS in SAP HANA -- Unions versus JOINS -- Self-study questions -- Summary -- Chapter 2: The SAP HANA Data Modeling Approach -- Row and column storage in SAP HANA -- Choosing the right table -- A basic architecture of the SAP HANA engine -- Different modeling artifacts in SAP HANA -- Modeling principles -- The SAP HANA Studio -- Perspectives in SAP HANA Studio -- Adding our system to SAP HANA Studio -- The system view -- Different schemas in SAP HANA -- Creating package and delivery unit -- Deleting packages -- Delivery units -- Self-study questions -- Summary -- Chapter 3: Different Ways of SAP HANA Data Load -- Loading data from Flat file in SAP HANA -- Real-time replication via SAP SLT (System Landscape Transformation) Replication Server -- Loading data with SAP Direct Extractor -- Application server configuration -- Creating a DXC schema and user in SAP HANA -- Loading data in SAP HANA with Data Services Workbench -- SAP Replication Server -- Smart Data Access -- Self-study questions -- Summary -- Chapter 4: Creating SAP HANA Artifacts Attribute Views and Analytical Views -- Steps to adjust preferences -- Creating attribute views -- Defining attribute and key attribute -- Creating time attribute views -- Creating analytical views -- Creating other elements -- Calculated attribute -- Calculated measures -- Calculated columns -- Creating variables -- Self-study questions.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Chapter 5: Creating SAP HANA Artifacts - Analytical Privileges and Calculation Views -- Creating a restricted measure and a calculated measure -- Creating filters -- Steps for creating a filter -- Creating input parameters and variables -- Creating calculation views -- Analytical privileges -- Self-study questions -- Summary -- Chapter 6: Understanding Text Search and Hierarchies in SAP HANA -- Creating and using Full Text Search -- Enabling the search option -- Creating hierarchies -- Creating a level hierarchy -- Creating a parent-child hierarchy -- Self-study questions -- Summary -- Chapter 7: Using Decision Tables and Transporting SAP HANA Content -- What is a decision table? -- Why use decision tables? -- Transport management in SAP HANA -- SAP HANA application lifecycle manager -- Transporting a delivery unit with HALM -- Export and import - moving SAP HANA content manually -- Currency conversion in SAP HANA -- Self-study questions -- Summary -- Chapter 8: Consuming SAP HANA Data Models -- Connecting to the SAP HANA database -- Reporting tools for SAP HANA -- Analysis for Office -- SAP Business Objects Analysis for OLAP -- Using Microsoft Excel as a reporting tool -- Summary -- Chapter 9: An Introduction to Application Function Library -- Application Function Library -- Predictive Analysis Library -- Calling PAL functions -- Business Function Library -- Self-study questions -- Summary -- Index.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">SAP HANA (Electronic resource)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2012057360</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">SAP HANA (Electronic resource)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Real-time data processing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85111765</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">Business enterprises</subfield><subfield code="x">Data processing.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Temps réel (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">Entreprises</subfield><subfield code="x">Informatique.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Industrial Management.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Management.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Management Science.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">BUSINESS & ECONOMICS</subfield><subfield code="x">Organizational Behavior.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Business enterprises</subfield><subfield code="x">Data processing</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">Real-time data processing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="655" ind1=" " ind2="4"><subfield code="a">Electronic book.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Real time analytics with SAP HANA (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCH7bhp3CfQ88hycd4mT3FC</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><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=1089588</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Internet Archive</subfield><subfield code="b">INAR</subfield><subfield code="n">realtimeanalytic0000sing</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL4191106</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1089588</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> |
| genre | Electronic book. |
| genre_facet | Electronic book. |
| id | ZDB-4-EBA-ocn932247963 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:26:56Z |
| institution | BVB |
| isbn | 9781782174127 1782174125 1782174117 9781782174110 |
| language | English |
| oclc_num | 932247963 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2015 |
| publishDateSearch | 2015 |
| publishDateSort | 2015 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Professional expertise distilled. |
| series2 | Professional expertise distilled |
| spelling | Singh, Vinay, author. Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / Vinay Singh. Birmingham : Packt Publishing, 2015. 1 online resource : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier Professional expertise distilled Online resource; title from PDF title page (EBSCO, viewed November 16, 2016). Includes index. Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Kickoff -- Before SQLscript Start -- Introducing SAP HANA SQL -- Classical SQL -- The SAP HANA SQLscript -- Why SQLscript? -- How different is an SQLscript in SAP HANA from classical SQL queries? -- When should we use SQLScript? -- Procedures -- Creating with the SQL editor (in SAP HANA Studio) -- Procedure creation using the wizard -- JOINS in SAP HANA -- Unions versus JOINS -- Self-study questions -- Summary -- Chapter 2: The SAP HANA Data Modeling Approach -- Row and column storage in SAP HANA -- Choosing the right table -- A basic architecture of the SAP HANA engine -- Different modeling artifacts in SAP HANA -- Modeling principles -- The SAP HANA Studio -- Perspectives in SAP HANA Studio -- Adding our system to SAP HANA Studio -- The system view -- Different schemas in SAP HANA -- Creating package and delivery unit -- Deleting packages -- Delivery units -- Self-study questions -- Summary -- Chapter 3: Different Ways of SAP HANA Data Load -- Loading data from Flat file in SAP HANA -- Real-time replication via SAP SLT (System Landscape Transformation) Replication Server -- Loading data with SAP Direct Extractor -- Application server configuration -- Creating a DXC schema and user in SAP HANA -- Loading data in SAP HANA with Data Services Workbench -- SAP Replication Server -- Smart Data Access -- Self-study questions -- Summary -- Chapter 4: Creating SAP HANA Artifacts Attribute Views and Analytical Views -- Steps to adjust preferences -- Creating attribute views -- Defining attribute and key attribute -- Creating time attribute views -- Creating analytical views -- Creating other elements -- Calculated attribute -- Calculated measures -- Calculated columns -- Creating variables -- Self-study questions. Chapter 5: Creating SAP HANA Artifacts - Analytical Privileges and Calculation Views -- Creating a restricted measure and a calculated measure -- Creating filters -- Steps for creating a filter -- Creating input parameters and variables -- Creating calculation views -- Analytical privileges -- Self-study questions -- Summary -- Chapter 6: Understanding Text Search and Hierarchies in SAP HANA -- Creating and using Full Text Search -- Enabling the search option -- Creating hierarchies -- Creating a level hierarchy -- Creating a parent-child hierarchy -- Self-study questions -- Summary -- Chapter 7: Using Decision Tables and Transporting SAP HANA Content -- What is a decision table? -- Why use decision tables? -- Transport management in SAP HANA -- SAP HANA application lifecycle manager -- Transporting a delivery unit with HALM -- Export and import - moving SAP HANA content manually -- Currency conversion in SAP HANA -- Self-study questions -- Summary -- Chapter 8: Consuming SAP HANA Data Models -- Connecting to the SAP HANA database -- Reporting tools for SAP HANA -- Analysis for Office -- SAP Business Objects Analysis for OLAP -- Using Microsoft Excel as a reporting tool -- Summary -- Chapter 9: An Introduction to Application Function Library -- Application Function Library -- Predictive Analysis Library -- Calling PAL functions -- Business Function Library -- Self-study questions -- Summary -- Index. SAP HANA (Electronic resource) http://id.loc.gov/authorities/names/n2012057360 SAP HANA (Electronic resource) fast Real-time data processing. http://id.loc.gov/authorities/subjects/sh85111765 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Business enterprises Data processing. Temps réel (Informatique) Bases de données Gestion. Entreprises Informatique. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Business enterprises Data processing fast Database management fast Real-time data processing fast Electronic book. has work: Real time analytics with SAP HANA (Text) https://id.oclc.org/worldcat/entity/E39PCH7bhp3CfQ88hycd4mT3FC https://id.oclc.org/worldcat/ontology/hasWork 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=1089588 Volltext |
| spellingShingle | Singh, Vinay Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / Professional expertise distilled. Cover -- Copyright -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Table of Contents -- Preface -- Chapter 1: Kickoff -- Before SQLscript Start -- Introducing SAP HANA SQL -- Classical SQL -- The SAP HANA SQLscript -- Why SQLscript? -- How different is an SQLscript in SAP HANA from classical SQL queries? -- When should we use SQLScript? -- Procedures -- Creating with the SQL editor (in SAP HANA Studio) -- Procedure creation using the wizard -- JOINS in SAP HANA -- Unions versus JOINS -- Self-study questions -- Summary -- Chapter 2: The SAP HANA Data Modeling Approach -- Row and column storage in SAP HANA -- Choosing the right table -- A basic architecture of the SAP HANA engine -- Different modeling artifacts in SAP HANA -- Modeling principles -- The SAP HANA Studio -- Perspectives in SAP HANA Studio -- Adding our system to SAP HANA Studio -- The system view -- Different schemas in SAP HANA -- Creating package and delivery unit -- Deleting packages -- Delivery units -- Self-study questions -- Summary -- Chapter 3: Different Ways of SAP HANA Data Load -- Loading data from Flat file in SAP HANA -- Real-time replication via SAP SLT (System Landscape Transformation) Replication Server -- Loading data with SAP Direct Extractor -- Application server configuration -- Creating a DXC schema and user in SAP HANA -- Loading data in SAP HANA with Data Services Workbench -- SAP Replication Server -- Smart Data Access -- Self-study questions -- Summary -- Chapter 4: Creating SAP HANA Artifacts Attribute Views and Analytical Views -- Steps to adjust preferences -- Creating attribute views -- Defining attribute and key attribute -- Creating time attribute views -- Creating analytical views -- Creating other elements -- Calculated attribute -- Calculated measures -- Calculated columns -- Creating variables -- Self-study questions. SAP HANA (Electronic resource) http://id.loc.gov/authorities/names/n2012057360 SAP HANA (Electronic resource) fast Real-time data processing. http://id.loc.gov/authorities/subjects/sh85111765 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Business enterprises Data processing. Temps réel (Informatique) Bases de données Gestion. Entreprises Informatique. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Business enterprises Data processing fast Database management fast Real-time data processing fast |
| subject_GND | http://id.loc.gov/authorities/names/n2012057360 http://id.loc.gov/authorities/subjects/sh85111765 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / |
| title_auth | Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / |
| title_exact_search | Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / |
| title_full | Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / Vinay Singh. |
| title_fullStr | Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / Vinay Singh. |
| title_full_unstemmed | Real time analytics with SAP HANA : enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / Vinay Singh. |
| title_short | Real time analytics with SAP HANA : |
| title_sort | real time analytics with sap hana enhance your sap hana skills using this step by step guide to create data models and reports for real time analytics |
| title_sub | enhance your SAP HANA skills using this step-by-step guide to create data models and reports for real time analytics / |
| topic | SAP HANA (Electronic resource) http://id.loc.gov/authorities/names/n2012057360 SAP HANA (Electronic resource) fast Real-time data processing. http://id.loc.gov/authorities/subjects/sh85111765 Database management. http://id.loc.gov/authorities/subjects/sh85035848 Business enterprises Data processing. Temps réel (Informatique) Bases de données Gestion. Entreprises Informatique. BUSINESS & ECONOMICS Industrial Management. bisacsh BUSINESS & ECONOMICS Management. bisacsh BUSINESS & ECONOMICS Management Science. bisacsh BUSINESS & ECONOMICS Organizational Behavior. bisacsh Business enterprises Data processing fast Database management fast Real-time data processing fast |
| topic_facet | SAP HANA (Electronic resource) Real-time data processing. Database management. Business enterprises Data processing. Temps réel (Informatique) Bases de données Gestion. Entreprises Informatique. BUSINESS & ECONOMICS Industrial Management. BUSINESS & ECONOMICS Management. BUSINESS & ECONOMICS Management Science. BUSINESS & ECONOMICS Organizational Behavior. Business enterprises Data processing Database management Real-time data processing Electronic book. |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1089588 |
| work_keys_str_mv | AT singhvinay realtimeanalyticswithsaphanaenhanceyoursaphanaskillsusingthisstepbystepguidetocreatedatamodelsandreportsforrealtimeanalytics |