Cargando…

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-...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Singh, Vinay (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham : Packt Publishing, 2015.
Colección:Professional expertise distilled.
Temas:
Acceso en línea:Texto completo
Texto completo

MARC

LEADER 00000cam a2200000 i 4500
001 EBOOKCENTRAL_ocn932247963
003 OCoLC
005 20240329122006.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 
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 
029 1 |a DEBBG  |b BV043968130 
029 1 |a DEBSZ  |b 485786192 
029 1 |a GBVCP  |b 882847864 
029 1 |a UKMGB  |b 018005590 
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 0 4 |a 658.4038  |2 23 
049 |a UAMI 
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. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
590 |a ProQuest Ebook Central  |b Ebook Central Academic Complete 
630 0 0 |a SAP HANA (Electronic resource) 
630 0 7 |a SAP HANA (Electronic resource)  |2 fast 
650 0 |a Real-time data processing. 
650 0 |a Database management. 
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 
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. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781782174110/?ar  |z Texto completo 
856 4 0 |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=4191106  |z Texto completo 
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 IZTAP