Introduction

21

Target Group and Prerequisites

21

Structure of the Book

21

Downloads

25

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

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

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

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

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