Table of Contents

Open all
Close all
Foreword
19
Introduction
21
Target Group and Prerequisites
21
Structure of the Book
21
Downloads
25
Acknowledgments
27
Part I: Getting Started
29
1 Introduction to SAP Lumira, Designer Edition
31
1.1 What Is SAP Lumira, Designer Edition?
32
1.1.1 Integrated Development Environment
34
1.1.2 Components
34
1.1.3 SAP BusinessObjects BI Platform and Data Sources
35
1.1.4 Scripting
35
1.1.5 Cascading Style Sheets
36
1.1.6 Templates and Themes
36
1.1.7 Application Execution
36
1.1.8 LUMX and Interoperability
38
1.2 SAP Lumira Suite
38
1.2.1 SAP Lumira, Discovery Edition
38
1.2.2 SAP Lumira, Designer Edition
39
1.2.3 SAP Lumira, Server Edition
40
1.3 SAP Lumira and SAP’s Business Intelligence Portfolio
40
1.3.1 SAP’s BI Portfolio
40
1.3.2 Client Portfolio Conversion Strategy
41
1.3.3 Content Creation and Consumption
43
1.3.4 Interoperability
45
1.4 Recent Developments
46
1.5 Summary
48
2 SAP Lumira, Designer Edition Versus Other SAP Business Intelligence Tools
49
2.1 SAP BusinessObjects Dashboards
49
2.1.1 Setting Up a Dashboard
50
2.1.2 Components
52
2.1.3 Data Connectivity
52
2.1.4 Publishing
53
2.2 SAP BEX Web Application Designer
54
2.2.1 Setting Up a Web Application Template
55
2.2.2 Web Items
57
2.2.3 Publishing
58
2.3 SAP Analytics Cloud
58
2.3.1 Setting Up an SAP Analytics Cloud Story
59
2.3.2 Components
59
2.3.3 Connectivity
60
2.4 Key Differences
61
2.5 Summary
65
3 Usage Scenarios
67
3.1 Global Sales Dashboard
67
3.2 OLAP Application
74
3.2.1 Starting the Application
75
3.2.2 Export
79
3.3 Generic KPI Dashboard
80
3.4 Summary
83
4 Installation and Configuration
85
4.1 Architecture and Components
85
4.2 System Requirements
87
4.3 Downloading SAP Lumira, Designer Edition
88
4.4 Installing SAP Lumira, Designer Edition
92
4.5 Installing SAP Lumira, Server Edition
95
4.5.1 Downloading SAP Lumira, Server Edition
95
4.5.2 Installation on a Windows Platform
97
4.5.3 Modifying, Repairing, or Removing the Server
100
4.6 Configuring the SAP BusinessObjects BI Platform
101
4.6.1 Authorization
101
4.6.2 Bookmarks
105
4.6.3 Auditing
108
4.6.4 Lifecycle Management
110
4.6.5 Managing Extensions
113
4.7 Updating SAP Lumira, Designer Edition
115
4.7.1 Current Version
115
4.7.2 Available Versions
116
4.8 Configuring Connections via Universes and Custom Data Sources
117
4.8.1 Enable SAP HANA HTTP Connections
117
4.8.2 Creating an SAP HANA HTTP OLAP Connection
119
4.8.3 Creating an SAP BW OLAP Connection
121
4.9 Uninstalling SAP Lumira, Designer Edition
122
4.10 Summary
124
Part II: The Basics
125
5 The Integrated Development Environment
127
5.1 Menu
128
5.1.1 File
128
5.1.2 Planning
134
5.1.3 Edit
134
5.1.4 Layout
136
5.1.5 Search
138
5.1.6 View
140
5.1.7 Tools
142
5.1.8 Help
152
5.2 Toolbar
154
5.3 Layout Editor
157
5.3.1 Documents Tab
157
5.3.2 Components Tab
159
5.3.3 Outline Tab
161
5.3.4 Properties Tab
167
5.3.5 Additional Properties Tab
171
5.3.6 Error Log Tab
171
5.3.7 Script Problems Tab
172
5.4 Summary
172
6 The Application Design Process
173
6.1 Introduction
174
6.2 Adding the Data
175
6.3 Setting Up the Layout
178
6.4 Setting Up the Charts
181
6.4.1 Productive Hours Versus Total Hours
181
6.4.2 Productive Hours (Percentage)
184
6.4.3 Employee Sick Hours
186
6.4.4 Productive, Sick, and Leave Hours Combined
189
6.5 Adding Interactivity
189
6.6 Summary
193
7 Components and Properties
195
7.1 Application Component Properties
195
7.1.1 Custom CSS
199
7.1.2 Global Script Variables and the On Startup Script
202
7.2 Composite Component
205
7.3 Data Source Alias Component Properties
206
7.4 Visual Component Properties
209
7.4.1 Common Properties
209
7.4.2 Table Component Properties
212
7.4.3 Chart Component Properties
224
7.4.4 Filter Component Properties
231
7.4.5 Basic Component Properties
238
7.4.6 Container Component Properties
264
7.5 Technical Component Properties
277
7.5.1 Backend Connection Component
277
7.5.2 Global Scripts Object Component
280
7.5.3 Export Components
281
7.5.4 Keyboard Shortcuts Component
283
7.5.5 Text Pool Component
284
7.5.6 Action Sheet Component
284
7.5.7 Bookmark Component
285
7.6 Summary
287
Part III: Advanced Concepts
289
8 Scripting for Interactivity
291
8.1 BI Action Language
292
8.1.1 Syntax
292
8.1.2 Expressions
296
8.1.3 Script Variables
298
8.1.4 Calling the Event Handler
299
8.1.5 Global Scripts
299
8.2 Creating a Script
300
8.2.1 Using the Content Assistance Screen
301
8.2.2 Creating Predefined Statement Templates
304
8.2.3 Finding Script Errors
308
8.2.4 Creating a Global Script
309
8.3 Example: Building Navigation Items
310
8.3.1 Menu Navigation
310
8.3.2 Popup Navigation
314
8.3.3 Navigating between Applications
320
8.4 Example: Manipulating Data Output
327
8.4.1 Presenting Data in Text Components
327
8.4.2 Preparing Data for Variable Input
333
8.4.3 Data Binding
336
8.4.4 Using SAP BEx conditions
339
8.4.5 Changing the Chart View
343
8.5 Example: Building a Scorecard
345
8.6 Summary
353
9 Planning Applications
355
9.1 Prerequisites for Planning
355
9.2 Adding a Planning Connection
357
9.3 Manual Planning: Crosstab and Spreadsheet Components
360
9.4 Automated Planning: Planning Functions and Sequences
362
9.4.1 Planning Functions
362
9.4.2 Planning Sequences
364
9.5 Planning Functionality Options
365
9.6 Building a Planning Application
366
9.7 Using Keyboard Shortcuts
370
9.8 Summary
371
10 Enhancing Applications with CSS
373
10.1 CSS Themes
374
10.2 Using CSS Classes and Styles
378
10.3 Adding Custom CSS Classes
384
10.4 Making Applications Responsive
390
10.5 Modifying Standard Components
397
10.6 Summary
406
11 Design Principles and Visualization Options
407
11.1 General Design Principles
407
11.1.1 Don’t Make Users Think
408
11.1.2 Don’t Make Users Wait
408
11.1.3 Managing User Focus
409
11.1.4 Emphasizing Features
409
11.1.5 Keeping It Simple
410
11.1.6 Using Conventions
410
11.1.7 Getting the Most Out of Screen Room
410
11.1.8 International Business Communication Standards
412
11.2 Choosing a Visualization Method
414
11.2.1 Single Numbers
416
11.2.2 Line Charts
416
11.2.3 Area Charts
417
11.2.4 Bar Charts
418
11.2.5 Column Charts
421
11.2.6 Marimekko Charts
424
11.2.7 Waterfall Charts
425
11.2.8 Bullet Charts
425
11.2.9 Crosstabs
426
11.2.10 Scatter Charts
426
11.2.11 Bubble Charts
427
11.2.12 Pie Charts
428
11.2.13 Heat Maps
429
11.2.14 Tree Maps
429
11.2.15 Tag Clouds
430
11.2.16 Box Plots
430
11.2.17 Network Charts
431
11.2.18 Radar Charts
431
11.2.19 Funnel Charts
432
11.2.20 Parallel Coordinates Charts
433
11.2.21 Trees
433
11.3 Building Complex Applications
435
11.3.1 Building Principles
436
11.3.2 Application Building Tips
437
11.3.3 Scripting
439
11.3.4 Managing the Styling of the Application
441
11.4 Mobile Design
443
11.4.1 Mobile Design Considerations
443
11.4.2 Setup SAP Lumira, Designer Edition for Mobile Applications
444
11.5 Summary
446
12 Performance Tuning
447
12.1 Usage Scenarios
447
12.2 Data Sources
448
12.2.1 Setting Up Data Sources
449
12.2.2 Loading in Scripts
450
12.2.3 Parallel Execution
452
12.2.4 Variables
454
12.2.5 Universes
454
12.3 Components
455
12.4 Scripting
456
12.5 Browsers
457
12.6 Mobile
458
12.7 Measuring Performance
459
12.8 SAP BusinessObjects BI Platform
461
12.8.1 Sizing
462
12.8.2 JavaScript Compression
462
12.9 Summary
463
Part IV: The Software Development Kit
465
13 Using SDK Extensions in SAP Lumira, Designer Edition
467
13.1 Extensions: What They Are and How They Work
467
13.2 Installing, Updating, and Removing SDK Extensions
469
13.2.1 Installation
469
13.2.2 Updating
475
13.2.3 Uninstalling the SDK
477
13.3 Testing Changes to an SDK Extension
479
13.4 Third-Party SDK Extensions
480
13.5 Summary
483
14 SDK Installation and Deployment
485
14.1 Installing Eclipse
485
14.1.1 Java Development Kit
485
14.1.2 Eclipse
488
14.2 Setting Up XML Standards
492
14.2.1 Downloading Templates from SAP
492
14.2.2 Setting Up XML
493
14.3 Import a Project
495
14.4 Setting the Target Platform
496
14.5 Summary
500
15 Building Components Using the SDK
501
15.1 Understanding the SDK Framework
501
15.2 Languages Used in an SDK
503
15.2.1 JavaScript Overview
503
15.2.2 XML Overview
519
15.2.3 HTML Overview
520
15.2.4 CSS Overview
521
15.3 Building Blocks of an SDK Extension
522
15.3.1 Contribution.xml
522
15.3.2 Component JavaScript
523
15.3.3 Additional Properties
524
15.3.4 Script Contributions
526
15.3.5 Component CSS
527
15.3.6 Icon
528
15.4 Configuring the SDK Extension
529
15.4.1 Extension Level
529
15.4.2 Component Level
531
15.4.3 Creating Databound Properties
537
15.5 Building Internal Functionality
541
15.5.1 Function Calls
541
15.5.2 Functions
543
15.5.3 Data Runtime JSON
546
15.6 Creating Methods
554
15.7 Using the JavaScript Libraries
556
15.7.1 jQuery
556
15.7.2 D3
558
15.7.3 SAPUI5
568
15.8 Example: Building a Bullet Graph SDK Extension
570
15.8.1 Overview
570
15.8.2 Setting Up the Project and Structure
571
15.8.3 Setting Up the Base Folder Structure
573
15.8.4 Expanding the Bullet Graph Component
584
15.8.5 Creating the Component JavaScript
591
15.8.6 Creating Additional Properties
606
15.8.7 Adding Methods
611
15.9 Summary
614
Part V: Examples
615
16 Building a Sales Dashboard Application
617
16.1 Application Overview
617
16.2 Building the Application
620
16.2.1 Data Sources
620
16.2.2 Main Page
621
16.2.3 Header
622
16.2.4 Body
627
16.3 Summary
636
17 Building an OLAP Application
637
17.1 Application Overview
637
17.2 Building the Application
639
17.2.1 Using the Template
640
17.2.2 Analyzing the Techniques Used in the Template
642
17.2.3 Enhancing the Template
647
17.3 Summary
652
18 Building a Generic KPI Application
653
18.1 Application Overview
653
18.2 Building the Application
654
18.2.1 Building the Application Structure
654
18.2.2 Creating CSS Classes
658
18.2.3 Creating the Composite Component
659
18.2.4 Dynamically Adding Tiles
664
18.3 Summary
667
19 Outlook
669
19.1 SAP Analytics and Platform Strategy
669
19.2 Roadmap
673
19.3 Summary
675
Appendices
679
A SAP Lumira, Designer Edition on Mobile
679
A.1 Supported Devices
679
A.2 Connectivity
680
A.3 Setting up the Mobile Category
681
A.4 Using Content in the Mobile App
685
B Interoperability with SAP Lumira, Discovery Edition
689
B.1 Adding Advanced Features to SAP Lumira, Discovery Edition Stories
690
B.2 Combining Multiple Stories in an Application
693
B.3 Upgrading a Story
695
B.4 Data Mashup
696
B.5 Limitations
701
C Components and Methods
703
C.1 Technical Components
703
C.2 Visual Components
720
D The Authors
741
Index
743