Test run
It is time to check out your first application in Design Studio! Although we waited until the end to walk you through this process, keep in mind that you don’t have to wait until the application is completely finished to do some test runs. During the development process you constantly want to see how the application behaves and how the changes you make affect the application.
To execute the application, follow the steps below:
1. Select the Execute locally option from the Application menu to check the application in a browser window. The result is shown in Figure 6.23 and Figure 6.24.
Figure 6.23 Application Running in a Browser (KPI Trends Tab)
The Application Design Process
6
2. Switch tabs, set a filter on another division, and switch between the two chart measures.
3. Check the application on your mobile device by selecting the Send to Mobile Device (using QR Code®) command in the toolbar.
6.6 Summary
In this chapter we went through a step-by-step tutorial to build a simple application with Design Studio. We used a Chart component and a Crosstab component to visualize and display data from a BEx query data source. To set up the overall layout of the application, we used a
Figure 6.24 Application Running in a Browser (Employee List Tab)
Summary 6.6
Tabstrip component, which allows the user to switch between the Chart and the Crosstab. With a Dropdown Box component, a Radio Button Group, and some associated event scripts, we created the inter-active elements in this application to filter the data and select the mea-sures to be presented in the chart. Finally, we executed the application and checked its functionality.
Index
A
ABAP, 369, 371
Adaptive Processing Server, 113 create, 114
Analysis Application Service, 108, 112 initializing, 112
Analytic component Crosstab component, 221 Dimension Filter component, 224 Filter Panel component, 227 Analytic view, 125
Analytical application, 81 Android, 432
Application, 23, 94 add data source, 145 advanced example, 349, 381 close, 144
create new, 140, 185 customer alerts, 65 customer list screen, 64 delete, 144
execute locally, 149 execute on BI platform, 149 exit, 150
human resources example, 183, 201, 202
interactivity, 263 letter to shareholders, 80 managing staff capacity, 72 monitoring wait times, 69 open, 144
operational management, 68 preferred startup mode, 150 recovery, 159
save, 145 template, 142 Application component
custom CSS, 206, 208 displayed message types, 207 force prompts on startup, 207 global script variables, 207
Application component (Cont.) on startup, 207
position of message button, 207 position of message window, 207 properties, 206
Application design process, 183, 184 adding data, 188
executing the app, 201 formatting, 197 interactivity, 192 UI and visualizations, 184 Architecture, 93
Area chart, 339
Assignment statements, 267 Attribute, 172
Auto layout properties, 215
B
Backend connection, 162 Backend system, 375 Bar chart, 334
Bar combination chart, 336, 340 Basic component
Button component, 229 Checkbox component, 231 Date Field component, 232 Dropdown Box component, 234 Image component, 235 Input Field component, 237 List Box component, 238
Radio Button Group component, 241 Text component, 242
BEx Analyzer, 425 BEx query, 26, 160, 402
setup, 189
BEx Query Designer, 195 BEx Web Analyzer, 31, 51 BEx Web Application Designer, 31
application layers, 54 design environment, 53 functionality, 51
Index
BEx Web Application Designer (Cont.) publishing, 57
setup, 52
vs. Design Studio, 41, 58 web items, 55
BI Action Language (BIAL), 27, 263 BI Launch Pad, 29, 32, 58
BI tool comparison application examples, 59
component adjustment options, 58 components, 58
data connectivity, 59 data input options, 59
layout development flexibility, 59 mobile, 59
output format, 58 platform, 58 SAP HANA, 59 scripting options, 59 SDK, 59
BI tools
dashboarding and application creation, 34
discovery and analysis, 35 reporting, 32
Biapp file, 157 BICS, 48
Boolean expression, 266 call statement, 266 comparison, 266 constant, 266
multiple comparisons, 266 Boston Consultancy Matrix, 341 BOTTOM N condition, 403 Browser, 97, 149
Bubble chart, 341
Button component, 369, 372 CSS class, 230
icon, 230 name, 230 on click, 230 properties, 229 text, 230 visible, 230
C
Calculate Model button, 352 Calculation button, 373 Calculation view, 125 Call statement, 264
arguments, 265 component, 265 method, 265
Cascading Style Sheets (CSS) 씮 CSS Central Management Console (CMC), 95,
112, 162
Central Management System (CMS), 108 Chart component, 216, 288
additional properties, 221 chart type, 217
CSS class, 217 data source, 217 name, 217 on select, 217 properties, 217 show totals, 217 swap axes, 217 visible, 217 Chart types
100% stacked bar, 218, 335 100% stacked column, 218, 337 area, 218, 339
bar, 218, 334
bar combination, 218, 336 bubble, 219, 341
column, 218, 337
column combination, 218, 338 comparison, 347
crosstab, 340
horizontal area, 219, 339 horizontal line, 218, 333 horizontal waterfall, 219, 342 line, 184, 218, 333
multiple pie, 219, 344 multiple radar, 219, 345 pie, 219, 343
radar, 219, 345 scatter, 219, 346, 354 single number, 332 stacked bar, 218, 334
Index
Chart types (Cont.) stacked column, 218, 337 stacked waterfall, 219, 343 types, 220
waterfall, 180, 219, 341 Checkbox component
enabled, 232 name, 231 on click, 232 properties, 231 selected, 232 text, 232 visible, 231 Client tool, 94, 132
required components, 97 CMOD, 370
Column chart, 337
Column combination chart, 338 Common layout properties
bottom margin, 214 height, 215 left margin, 214 right margin, 214 top margin, 214 width, 215
Component, 26, 147, 205, 253 add, 187
analytic category, 170, 216 Application component, 205 Application, CSS class, 210
Application, global script variables, 211 Application, on startup, 211
arrange, 175
basic category, 171, 229 button, 370
chart, 179, 184, 216
container category, 171, 243, 257 crosstab, 184, 187, 199
data cell, 449 distribute, 176
dropdown box, 184, 188 filtering, 262
grid layout, 356 hide, 175 list box, 239 maximize, 186
Component (Cont.) naming conventions, 259 radio button group, 184, 187 reload, 150
show, 175 tabstrip, 184, 355
tips and tricks, 253, 257, 259 Conditional statements, 265 Configuration, 93
Container component Grid Layout, 244 Pagebook, 247 Panel, 249 Popup, 250 Tabstrip, 252
Content Assistance, 272, 273 Crosstab component, 375
always fill, 223 column limit, 222 CSS class, 223, 289, 365 data source, 222 enable selection, 223 name, 222
on select, 223
pixel-based scrolling, 222 properties, 222
row limit, 222
show scaling factor, 223 visible, 222
CSS, 27, 205, 210, 212, 243, 357, 387, 417
centralized scenario, 417 federated scenario, 417 local scenario, 417
other resources, 397, 419, 420 strategies, 417
structure of a file, 418 tips, 419
D
Dashboards, 23, 24, 41, 42, 82 Data binding, 45
Data Field component properties, 232
Index
Data source, 147, 162, 171, 188 add, 145, 190
initial view, 172, 190, 191 pause refresh, 173 show prompts, 148
Data Source Alias component, 272 Data visualization, 23
Date, 234
Decimal places, 174 Design principles, 327
control your screen, 330 don’t make users think, 327 don’t make users wait, 328 emphasize features, 329 keep it simple, 329 make buttons obvious, 329 manage user focus, 328 use conventions, 330 Dimension Filter component
CSS class, 226 data source, 226 dimension, 226 dimension name, 226 display mode, 226 name, 225 on apply, 226
popup width/height/position, 226 properties, 225
target data sources, 226 visible, 225
Dimensions, 172, 188, 227, 309 Dimensions and measures
change, 307
Dropdown Box component, 291, 453 CSS class, 235
enabled, 234 items, 235 name, 234 on select, 235 properties, 234 visible, 234 DuPont analysis, 19
DuPont analysis application, 349, 350 building the application, 355 Button component, 370
Company Comparison tab, 365, 379
DuPont analysis application (Cont.) comparing results, 379
components, 359 CSS file, 357 data sources, 367 global variables, 366
input from outside application, 354 layout, 355
main screen, 350
manual input, 351, 352, 372 model, 350
OLAP input, 352, 375 on startup, 368 overview, 350 results, 354
scripting, 372, 375, 379 structure, 355
write back, 369
E
Eclipse, 25 Edit menu, 151
copy, 151
Event handlers, 270, 271 Execute
locally, 149, 201 on BI platform, 149 Expressions, 267, 268
types, 268
External parameters, 351 External URL, 350
F
Filter Panel component CSS class, 228 data source, 228 dimension name, 228
Index
Filter Panel component (Cont.) dimensions, 228
display mode, 228 member display, 228 name, 228
on apply, 228 on cancel, 228 properties, 228 target data sources, 228 title, 228
visible, 228 Filters, 235
predefined buttons, 64 set method, 398 Flexibility, 316
Future developments, 68
G
General ledger input, 353 Global variable, calculated, 367 Graphomate, 409
Grid Layout component column width, 245 name, 245
number of columns, 245 number of rows, 245 properties, 245 row height, 245
H
Help menu, 165 Hierarchy, 172 HTML5, 25
I
Image component click image, 236 CSS class, 236 hover image, 236 image, 236 name, 236
Image component (Cont.) on click, 236
opacity, 236 properties, 236 visible, 236 InfoCubes, 372, 377 InfoProviders, 26 Input Field component
CSS class, 238 enabled, 238 name, 237 on change, 238 properties, 237 value, 238 visible, 238 Insert numbers, 354 Installation, 93, 98
Analysis Application Support for Mobile Services, 108
analysis application web component, 108 document guides, 98
extract files, 102 full or custom, 107 software components, 99 wizard, 105
Integrated development environment (IDE), 26, 139
Integrated Planning (BW-IP), 57, 68, 410 Interactivity, 235, 263
iView template, 130
J
Java Support Package Manager (JSPM), 129
JavaScript, 27 JSON, 277
K
Key figures, 79
Key performance indicator (KPI), 34, 64, 88
Index
L
Layout Editor, 169, 185 Layout menu, 152
align, 152 distribute, 153
maximize component, 153
Lifecycle Management Console (LCM), 95
List Box component, 291, 373, 379, 402, 453
CSS class, 239 enabled, 239 items, 240 name, 239 on select, 240 visible, 239
vs. Dropdown Box component, 239 Load in script, 213
Local mode, 136, 150, 157 repository folder, 150 Log level, 163 Logon, 135
M
Measure, 172, 188 Member selection, 159 Menu bar, 140
application menu, 140 Methods, 264, 281
Application component, 285, 439 Button component, 287, 440 Chart component, 288, 441 Checkbox component, 288 component class, 286 Convert component, 281, 443 Crosstab component, 290
Data Source Alias component, 282, 444 Date Field component, 290
Dimension Filter component, 290, 450 Filter Panel component, 290
Image component, 292, 451 Input Field component, 293 Pagebook component, 293 Panel component, 294, 452
Methods (Cont.) Popup component, 294 Tabstrip component, 294 Text component, 295 Microsoft Excel, 43 Mobile, 29
Mobile category, 433 creating, 120 Mobile device, 97, 202
send to, 168
Mobile Server, 121, 432 Mobility, 25, 407, 412
make content available, 433 running Design Studio content, 435 MS Excel, 425
N
New Statement Wizard, 273, 274
O
OData, 411
ODBC Data Source Administrator, 162 OLAP connection, 95, 122, 125, 350
define authentication method for BW, 124 SAP HANA, 125
SAP NetWeaver BW, 122 On select, 196
Operators, 267
P
Pagebook component CSS class, 247 name, 247 on select, 248 page caching, 248 properties, 247 selected page index, 247 transition direction, 248 transition effect, 247 visible, 247
Panel component CSS class, 250 CSS styles, 250
Index
Panel component (Cont.) enabled, 250
name, 249 on click, 250 properties, 249 visible, 249 Performance, 328 Planning, 72
Planning Application Kit (PAK), 410 Populate, 235 Preferences menu, 157
application design, 158 scripting, 158
Product Availability Matrix (PAM), 96 Promotion Management, 95
Prompt, 148 Properties, 205, 253
common layout, 214 custom CSS, 208 description, 206 theme, 206
Q
QR code, 168 Query, 375
R
Radio Button Group component, 291, 453
columns, 241 CSS class, 241 enabled, 241 items, 241 name, 241 on select, 241 properties, 241 visible, 241 Reports, 23
S
S_RS_ZEN, 131
authorization fields, 132 Sales dashboard application, 381
actual sales vs. sales targets, 382 BEx query, 403
BEx query exceptions, 404 building the application, 387 Chart component, 399 components, 391, 395 conditions, 403 CSS file, 387
cumulative contribution, 386 Dropdown Box component, 393, 398 Grid Layout component, 393 layout, 387
List Box component, 393, 397 market shares, 385
On select handler, 397 overview, 381, 383, 385 Pagebook component, 391 pie chart, 383, 384 PNL_MARKETSHARE, 399 sales development, 383 setting countries, 400 Text component, 391, 395 Top N query, 402 SAP BI, 25
SAP BusinessObjects Analysis, 37 creating a Design Studio application,
426
MS Office, 31, 35, 37, 425 OLAP, 35, 37, 425 smart copy, 425, 428
SAP BusinessObjects BI platform, 26, 94, 95, 263
add-on for Design Studio, 104 client sessions, 116
configuration for Design Studio, 111 logs, 115
Mobile category, 120 Mobile Server, 432 prerequisites, 96, 105 public folder, 209 supported versions, 96
Index
SAP BusinessObjects BI platform (Cont.) user authorizations, 117
SAP BusinessObjects Dashboards, 24, 31, 34, 409, 431
chart types, 45 components, 45
container components, 47 data connectivity, 48 design environment, 44 example, 42
single-value components, 47 vs. Design Studio, 41, 58, 409 SAP BusinessObjects Design Studio, 408
and SAP BusinessObjects Mobile, 431 and the BI suite, 30
as an application-creation tool, 34 BEx WAD and Dashboards, 31 client tool, 94, 97, 132 components and properties, 205 configuration, 93
connectivity, 145 description, 24 design principles, 327
DuPont analysis application, 349 installation, 93
interactivity, 263 logon, 135 mobility, 431
roadmap, 407, 408, 412 sales dashboard application, 381 strategy and direction, 32 supported browsers, 97 updating, 99
usage scenarios, 63 visualization options, 327
vs. BEx Web Application Designer, 41, 58, 59
vs. SAP BusinessObjects Dashboards, 41, 58, 409
SAP BusinessObjects Design Studio client tool, 95
SAP BusinessObjects Explorer, 31, 35, 36, 431
SAP BusinessObjects Mobile, 29, 30, 120, 431
annotation, 437 collaboration, 436 connectivity, 432 iOS, 432
support for Design Studio, 432 supported platforms, 432 voice memo, 437
SAP BusinessObjects Web Intelligence, 31, 33, 431
SAP Crystal Reports, 31, 32, 431 SAP HANA, 24, 25, 26, 59, 95, 125, 147,
162
analytic view, 145 calculation view, 145 SAP Jam, 437
SAP Java Connector (SAP JCo), 163 SAP JCo trace, 163
SAP Logon, 95, 162 SAP Lumira, 31, 35 SAP Lumira Cloud, 431
SAP NetWeaver BW, 24, 25, 26, 94, 263, 369
BEx Analyzer, 425 BEx query, 145, 148, 188 connecting to multiple systems, 128 InfoArea, 146, 147
InfoProvider, 145 OLAP connection, 122 query view, 145 role, 146, 147
setup for Design Studio, 127 supported versions, 96
SAP NetWeaver BW Java Portal, 58 SAP NetWeaver BW query, 370 SAP NetWeaver Portal, 95, 97, 130
prerequisites, 97
setup for Design Studio, 127 SAP Notes, 101, 127
SAP Predictive Analysis, 31, 35, 71 SAP Service Marketplace, 98, 99, 101
Index
SAP Transport Management System (STMS), 95
SAP Visual Intelligence 씮 SAP Lumira Scaling factor, 174
Script Editor, 194, 196, 271 Scripting, 27, 163, 263, 271
adding a cascading filter, 305 adding a filter, 303
building a calculator, 316 changing data sources, 311 examples, 295, 303, 312, 316 finding errors, 280
menu navigation, 296 moving dimensions, 307
navigation between applications, 301 popup menu, 298
scorecards, 312 syntax, 264 Search menu, 153
application, 154, 155 find references, 155 Single sign-on (SSO), 125 Smart paste, 428
Software Development Kit (SDK), 26, 50, 59, 409
Startup mode, 158 Statements, 272 Support, 166 Syntax
call statements, 264 coloring, 164 error, 280
T
Tabstrip component CSS class, 252 name, 252 on select, 252 properties, 252 selected tab index, 252 visible, 252
Templates, 28, 142 creating, 253 selection screen, 142 statements, 276 Testing, 201 Text component, 359
CSS class, 243 CSS style, 243 enabled, 243 name, 242 on click, 243 properties, 242 style, 243 visible, 243 Themes, 28, 254
roadmap, 254 Tomcat, 109 Toolbar, 167, 169
command descriptions, 169 send to mobile device, 168 seven command groups, 168 Tools menu, 157
TOP n condition, 403 Top n countries, 382 Totals calculation, 174 Trigger, 271
U
Unify, 412 Universes, 145
UNX, 49
URL parameters, 270, 301 Usage scenarios
customer relationship management, 63 employee management, 68
field sales, 73 financial reporting, 77 sales analytics, 81 User experience, 23
Index
V
Variables, 205, 267, 269 global, 270
local, 270 set method, 398 versus filters, 398 Versions, 93 View
additional properties, 179, 199 components, 170
error log, 180 outline, 171, 188 properties, 176, 177 script problems, 181 View menu, 155, 170
additional properties, 156 components, 156 error log, 157 outline, 156 properties, 156
View menu (Cont.) reset layout, 157 script problems, 156 search results, 157 Visualization, 412
methods, 332 options, 327
W
WDeploy, 109
Web Application Container Services (WACS), 109
Welcome page, 136, 165 What-if scenario, 43 Write back, 369 WYSIWYG, 26, 139, 169
X
Xcelsius, 31, 44