Inhaltsverzeichnis

Alle Kapitel aufklappen
Alle Kapitel zuklappen
Acknowledgments
15
Preface
17
Book Objectives
17
Target Audience
18
Book Roadmap
18
1 Introduction to the SAP Lumira Suite
21
1.1 Changing Requirements and SAP Lumira
22
1.1.1 Requirements and User Expectations
22
1.1.2 SAP Lumira and the Data Artisan
24
1.2 Self-Service Business Intelligence with SAP Lumira
24
1.2.1 From Rapid Acquisition
26
1.2.2 To Beautiful and Customizable Visualizations
27
1.2.3 Gathered Into Narrative Stories
28
1.3 SAP Lumira Cloud and SAP Lumira Server
30
1.4 Interoperability with Other SAP Systems
32
1.5 Summary
33
2 Installation and Configuration of SAP Lumira Desktop
35
2.1 License Model
36
2.1.1 Using the 30-Day Trial
37
2.1.2 Adding a Keycode
37
2.2 Downloading SAP Lumira Desktop
39
2.3 Installing SAP Lumira Desktop
41
2.4 Uninstallating SAP Lumira Desktop
47
2.5 SAP Lumira Registration
51
2.6 Updating SAP Lumira Desktop
54
2.6.1 Running Update
54
2.6.2 Checking for New Updates
57
2.6.3 Automatically Checking for New Updates
58
2.7 User Interface Presentation
59
2.7.1 Welcome Page
60
2.7.2 Rooms
63
2.7.3 Menu Bar
64
2.8 SAP Lumira File Format
65
2.8.1 File Extensions and Location
65
2.8.2 Creating and Opening Documents
66
2.8.3 Saving and Closing Document
67
2.9 Setting Preferences
69
2.10 Supportability
71
2.10.1 Online Help
72
2.10.2 Sending Feedback
72
2.10.3 Error Messages
74
2.10.4 Tracing
75
2.11 Summary
77
3 Data Acquisition
79
3.1 Data Acquisition Overview
79
3.1.1 Supported Data Sources
80
3.1.2 Acquisition Offline Mode
80
3.1.3 Acquisition Online Mode
81
3.1.4 New Dataset Creation
81
3.1.5 Active Directory and Single Sign-On
83
3.1.6 Data Acquisition Parameters for Automatic Detection and Performance
84
3.2 Text Files
86
3.3 Windows Clipboard Copy
89
3.4 Microsoft Excel
91
3.5 Query with SQL
95
3.5.1 Standard SQL Drivers
96
3.5.2 Installing/Uninstalling a Driver
98
3.5.3 Creating a Dataset from Relational Databases
100
3.5.4 Creating a Dataset from a Hadoop Database
106
3.5.5 Creating a Dataset from OData
108
3.6 SAP HANA
110
3.6.1 SAP HANA Offline Mode
111
3.6.2 SAP HANA Online Mode
116
3.6.3 Answering SAP HANA Variables and Input Parameters
117
3.7 SAP BusinessObjects BI Universes
121
3.7.1 Universes Support
122
3.7.2 Retrieving Data from Universes
123
3.7.3 Adding Filters
128
3.7.4 Answering Contexts and Parameters
130
3.8 SAP BusinessObjects BW
134
3.8.1 Retrieving Data from SAP BW
134
3.8.2 Answering SAP BusinessObjects BW Variables
137
3.9 Dataset Edit and Refresh
142
3.9.1 Editing Data Sources’ Connection Parameters
142
3.9.2 Editing Dataset Parameters
144
3.9.3 Refreshing the Dataset
146
3.10 Summary
147
4 Data Manipulation
149
4.1 The Prepare Room
150
4.1.1 Prepare Room Components
150
4.1.2 Menu Bar
151
4.1.3 Grid View
153
4.1.4 Facets View
153
4.2 Objects in SAP Lumira
156
4.2.1 Dimensions
156
4.2.2 Measures
157
4.3 Hierarchies in SAP Lumira
161
4.3.1 Creating a Time Hierarchy
162
4.3.2 Geographic Hierarchies by Name
165
4.3.3 Geographic Geography by Longitude and Latitude
171
4.3.4 Custom Hierarchies
173
4.4 Calculated Objects
174
4.4.1 Calculated Dimension
175
4.4.2 Calculated Measures
176
4.4.3 Formula Syntax
177
4.4.4 Formula Examples
178
4.4.5 Formula Table
180
4.5 Object Actions
188
4.6 Data Actions
191
4.6.1 Common Actions
191
4.6.2 String Actions
192
4.6.3 Numeric Actions
196
4.6.4 Date Actions
199
4.6.5 Value and Column Actions
199
4.7 Filtering and Sorting Data
201
4.7.1 Filtering Data in a Column
202
4.7.2 Displaying Filters in Other Rooms
204
4.7.3 Sorting Data
205
4.8 Multiple Datasets
206
4.8.1 Adding a Dataset
206
4.8.2 Merging Dataset
207
4.8.3 Appending Datasets
210
4.9 Configuring Auto-Enrichment
212
4.9.1 Enrichment Files
212
4.9.2 Versioning Rule
212
4.9.3 Enrichment File Format
213
4.9.4 File Syntax
214
4.10 Summary
216
5 Data Visualization
217
5.1 Visualize Room Overview
218
5.2 Building Charts in SAP Lumira
220
5.2.1 Aggregation
222
5.2.2 Legends
224
5.2.3 Trellis
225
5.3 Charts Types in SAP Lumira
227
5.3.1 Column Charts
227
5.3.2 Line Charts
230
5.3.3 Pie Charts
233
5.3.4 Geographic Charts
235
5.3.5 Map Charts
243
5.3.6 Scatter Charts
246
5.3.7 Table Charts
248
5.3.8 Point Charts
249
5.3.9 Special Charts
250
5.4 Measures in Charts
257
5.4.1 Sorting Charts
258
5.4.2 Rank Values
260
5.4.3 Add Calculations
262
5.4.4 Predictive Calculations
267
5.5 Chart Customization
269
5.6 Filters in Charts
271
5.7 Hierarchies and Navigation in Charts
272
5.8 Chart Preferences
273
5.9 Visualization Gallery
275
5.10 Related Visualizations
278
5.10.1 Influencers
281
5.11 Summary
283
6 Story Composition in SAP Lumira
285
6.1 Compose Room Overview
285
6.2 Story Anatomy
287
6.3 Creating a Story
288
6.4 Compose Room Organization
290
6.5 Interactive Boards
291
6.5.1 Content Layout
293
6.5.2 Entity Actions
296
6.5.3 Page Settings
298
6.6 Infographics
301
6.6.1 Infographic Layout
302
6.6.2 Organizing Entities
303
6.6.3 Resizing and Positioning Entities
304
6.6.4 Entity Actions
305
6.6.5 Moving Sections
308
6.6.6 Page Settings
308
6.6.7 Refresh Data
309
6.6.8 Preview
311
6.7 Reports
311
6.7.1 Report Flow Layout
312
6.7.2 Using Tables in Reports
314
6.8 Customizing Entities
315
6.8.1 Visualizations
315
6.8.2 Infocharts
318
6.8.3 Text
327
6.8.4 Images
328
6.8.5 Pictograms
331
6.8.6 Shapes
332
6.8.7 Controls
332
6.9 Summary
337
7 Sharing in SAP Lumira
339
7.1 Share Room Overview
340
7.2 Printing Visualizations
343
7.3 Sending Visualizations by Email
345
7.4 Publishing a Dataset or a Story to SAP Lumira Cloud
346
7.5 Republishing and Scheduling with SAP Lumira Agent
351
7.5.1 Scheduling Documents
351
7.5.2 Starting SAP Lumira Agent
353
7.5.3 Scheduling a Document
353
7.5.4 Managing All Schedules
357
7.5.5 Running a Schedule
359
7.6 Saving a Document to SAP Lumira Cloud
360
7.7 Publishing a Dataset or a Story to SAP Lumira Server
363
7.8 Publishing Datasets to the File System
366
7.9 Publishing a Dataset to SAP HANA
368
7.10 Publishing a Dataset to SAP Explorer
371
7.11 Publishing Datasets and Visualizations to SAP StreamWork
374
7.12 Publishing Datasets and Stories to SAP BusinessObjects BI
377
7.13 Summary
382
8 SAP Lumira Cloud
383
8.1 SAP Lumira Cloud Access
384
8.1.1 License Model
384
8.1.2 Creating Your Account from SAP Lumira Cloud
384
8.1.3 Creating Your Account from SAP Lumira Desktop
388
8.1.4 Account Management
389
8.1.5 Log In to SAP Lumira Cloud
389
8.1.6 Log Out of SAP Lumira Cloud
389
8.2 Connecting from SAP Lumira Desktop
390
8.3 SAP Lumira Cloud User Interface
392
8.3.1 General Overview
392
8.3.2 My Items Tab
393
8.3.3 Searching for Items
395
8.3.4 Running Actions
396
8.3.5 Settings Tab
399
8.4 Importing to SAP Lumira Cloud
402
8.4.1 Uploading Files or SAP Lumira Documents
402
8.4.2 Importing Data to Create a Dataset
403
8.5 Visualization and Composition Online
409
8.5.1 Accessing Online Rooms
409
8.5.2 Working in the Visualize and Compose Rooms
410
8.5.3 Saving Your Stories in SAP Lumira Cloud
413
8.6 Sharing Resources in SAP Lumira Cloud
414
8.6.1 Sharing Methods
414
8.6.2 Sharing a Resource
414
8.6.3 Changing Sharing Options
418
8.6.4 Accessing a Shared Resource
419
8.7 Creating a Team
420
8.7.1 Members Type
420
8.7.2 Accessing Team Administration
420
8.7.3 Inviting and Removing Users
422
8.7.4 Managing Administrators
423
8.7.5 Sending Email
424
8.7.6 Changing the Team Name
424
8.8 Mobile Access
426
8.8.1 Setting Up SAP Lumira Cloud Connection in SAP BusinessObjects Mobile
426
8.8.2 Working with SAP BusinessObjects Mobile
428
8.9 Summary
433
9 SAP Lumira Server
435
9.1 Downloading SAP Lumira Server
436
9.2 Using SAP HANA for SAP Lumira Server
438
9.2.1 SAP HANA Platform Advantages
438
9.2.2 SAP HANA Requirements
439
9.2.3 Installing SAP Lumira Server with SAP HANA Studio
439
9.2.4 SAP Lumira Server Security
442
9.3 SAP Lumira Server User Interface
445
9.3.1 Log In to SAP Lumira Server
445
9.3.2 Log Out of SAP Lumira Server
446
9.3.3 General Overview
446
9.3.4 My Items Tab
447
9.3.5 Searching for Items
449
9.3.6 Running Actions
449
9.3.7 Settings
451
9.3.8 Mobile Access
452
9.4 Importing to SAP Lumira Server
452
9.4.1 Publishing from SAP Lumira Desktop
452
9.4.2 Importing Data to Create a Dataset
453
9.4.3 Using SAP HANA Dataset
454
9.5 Visualization and Composition Online
454
9.5.1 Accessing Online Rooms
454
9.5.2 Working in the Visualize and Compose Rooms
455
9.5.3 Saving Your Story
456
9.6 Sharing Resources in SAP Lumira Server
457
9.6.1 Sharing Prerequisites
457
9.6.2 Sharing a Resource
458
9.6.3 Changing Sharing Options
460
9.6.4 Accessing a Shared Resource
461
9.7 Summary
462
10 Integrating SAP Lumira with SAP BusinessObjects BI 4.1
463
10.1 SAP BusinessObjects BI 4.1 Add-On Overview
464
10.2 Installing and Configuring SAP BusinessObjects BI 4.1 Add-On in SAP Lumira
465
10.2.1 Downloading the Add-On for SAP Lumira and the SAP Cryptography Library
466
10.2.2 Installing on a Windows Platform
468
10.2.3 Installing the Cryptography Library and Generating the Assertion Ticket
470
10.2.4 Configuring SAP HANA with an Assertion Ticket
471
10.2.5 Creating a User in SAP HANA Dedicated to SAP BusinessObjects BI 4.1
474
10.2.6 Configuring SAP Lumira Server HTTP
474
10.2.7 Configuring SAP BusinessObjects BI 4.1 to Communicate with SAP HANA
477
10.3 Importing SAP Lumira Resources into SAP BusinessObjects BI 4.1
479
10.3.1 Dataset InfoObject
479
10.3.2 Story InfoObject
480
10.4 Viewing SAP Lumira Content in SAP BusinessObjects BI Launch Pad
480
10.5 Central Management Console
482
10.5.1 Displaying Stories and Dataset
483
10.5.2 Managing Datasets in the CMC
483
10.5.3 Managing Stories in the CMC
484
10.5.4 Dataset and Story User Security
486
10.6 Universe Refresh and Scheduling
486
10.6.1 Refreshing or Scheduling a Dataset
486
10.7 Summary
488
11 SAP Lumira Software Development Kits
489
11.1 The VizExtensions Software Development Kit
490
11.1.1 VizExtensions Samples
490
11.1.2 VizExtensions Custom Charts
494
11.1.3 VizPacker
494
11.1.4 Chart Deployment
502
11.1.5 Debugging
511
11.1.6 Summary
513
11.2 The Data Source Software Development Kit
513
11.2.1 Prerequisites
514
11.2.2 Talking to SAP Lumira
515
11.2.3 SAP Lumira Arguments
516
11.2.4 Task Manager Extension
517
11.2.5 Creating an EXE
521
11.2.6 Deployment
523
11.3 Summary
526
12 Conclusion
527
The Authors
529
Index
531