-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathvalqlumira.html
More file actions
4722 lines (4606 loc) · 203 KB
/
valqlumira.html
File metadata and controls
4722 lines (4606 loc) · 203 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
<!DOCTYPE html>
<!--[if IE 8]><html class="no-js lt-ie9" lang="en" > <![endif]-->
<!--[if gt IE 8]><!--> <html class="no-js" lang="en" > <!--<![endif]-->
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Copyright — Visual BI valQ for SAP Lumira Designer 1.0.0 documentation</title>
<link rel="stylesheet" href="_static/css/theme.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<link rel="stylesheet" href="_static/theme_overrides.css" type="text/css" />
<link rel="index" title="Index" href="genindex.html" />
<link rel="search" title="Search" href="search.html" />
<link rel="prev" title="Welcome to Visual BI valQ for SAP Lumira Designer!" href="index.html" />
<script src="_static/js/modernizr.min.js"></script>
</head>
<body class="wy-body-for-nav">
<div class="wy-grid-for-nav">
<nav data-toggle="wy-nav-shift" class="wy-nav-side">
<div class="wy-side-scroll">
<div class="wy-side-nav-search">
<a href="index.html" class="icon icon-home"> Visual BI valQ for SAP Lumira Designer
<img src="_static/vbilogo.png" class="logo" alt="Logo"/>
</a>
<div role="search">
<form id="rtd-search-form" class="wy-form" action="search.html" method="get">
<input type="text" name="q" placeholder="Search docs" />
<input type="hidden" name="check_keywords" value="yes" />
<input type="hidden" name="area" value="default" />
</form>
</div>
</div>
<div class="wy-menu wy-menu-vertical" data-spy="affix" role="navigation" aria-label="main navigation">
<p class="caption"><span class="caption-text">Contents:</span></p>
<ul class="current">
<li class="toctree-l1 current"><a class="current reference internal" href="#">Copyright</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#trademark-information">Trademark Information</a></li>
<li class="toctree-l2"><a class="reference internal" href="#patent-information">Patent Information</a></li>
<li class="toctree-l2"><a class="reference internal" href="#sap-trademarks">SAP Trademarks</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="#definitions">Definitions</a></li>
<li class="toctree-l1"><a class="reference internal" href="#introduction">Introduction</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#document-history">Document History</a></li>
<li class="toctree-l2"><a class="reference internal" href="#who-should-read-this-guide">Who should read this guide?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#what-is-valq-for-sap-lumira-designer-suite">What is valQ for SAP Lumira Designer Suite?</a></li>
<li class="toctree-l2"><a class="reference internal" href="#traditional-approach">Traditional Approach</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="#instructions">Instructions</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#input-data">Input Data</a></li>
<li class="toctree-l2"><a class="reference internal" href="#tree-drill-down">Tree Drill Down</a></li>
<li class="toctree-l2"><a class="reference internal" href="#node-level-comments">Node level Comments</a></li>
<li class="toctree-l2"><a class="reference internal" href="#zoom-and-pan">Zoom and Pan</a></li>
<li class="toctree-l2"><a class="reference internal" href="#value-display-and-simulation-period">Value Display and Simulation Period</a></li>
<li class="toctree-l2"><a class="reference internal" href="#value-driver-tree-views-filters">Value Driver Tree views - Filters</a></li>
<li class="toctree-l2"><a class="reference internal" href="#kpis">KPIs</a></li>
<li class="toctree-l2"><a class="reference internal" href="#data-simulation">Data Simulation</a></li>
<li class="toctree-l2"><a class="reference internal" href="#key-inputs">Key Inputs</a></li>
<li class="toctree-l2"><a class="reference internal" href="#scenario-comparison">Scenario Comparison</a></li>
<li class="toctree-l2"><a class="reference internal" href="#switch-to-node-details-from-compare-scenarios">Switch to Node details from compare scenarios</a></li>
<li class="toctree-l2"><a class="reference internal" href="#initiatives-in-scenario">Initiatives in Scenario</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#aggregate-value-based-on-simulation-impacts">Aggregate value based on Simulation Impacts</a></li>
<li class="toctree-l3"><a class="reference internal" href="#initiatives-in-compare-scenarios">Initiatives in compare scenarios</a></li>
<li class="toctree-l3"><a class="reference internal" href="#initiatives-in-waterfall-chart">Initiatives in Waterfall Chart</a></li>
<li class="toctree-l3"><a class="reference internal" href="#selection-of-specific-initiative">Selection of specific Initiative</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="#scenario-export-with-second-level-initiatives">Scenario Export with second level Initiatives</a></li>
<li class="toctree-l2"><a class="reference internal" href="#scenario-data-in-output-data-source">Scenario Data in output data source</a></li>
<li class="toctree-l2"><a class="reference internal" href="#constraints">Constraints</a></li>
<li class="toctree-l2"><a class="reference internal" href="#collaboration-api">Collaboration API</a></li>
<li class="toctree-l2"><a class="reference internal" href="#ibcs-chart-in-trend-analysis">IBCS Chart in Trend Analysis</a></li>
<li class="toctree-l2"><a class="reference internal" href="#data-merge-property">Data merge property</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="#understanding-variances">Understanding Variances</a></li>
<li class="toctree-l1"><a class="reference internal" href="#understanding-the-node-widget-information">Understanding the Node Widget Information</a></li>
<li class="toctree-l1"><a class="reference internal" href="#conducting-what-if-analysis">Conducting what-if analysis</a></li>
<li class="toctree-l1"><a class="reference internal" href="#getting-more-information-about-a-value-driver">Getting more information about a Value driver</a></li>
<li class="toctree-l1"><a class="reference internal" href="#saving-and-opening-scenarios">Saving and Opening Scenarios</a></li>
<li class="toctree-l1"><a class="reference internal" href="#creating-a-value-driver-tree">Creating a Value Driver Tree</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#tree-tab">Tree Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#tree-tab-left-panel">Tree Tab – Left Panel</a></li>
<li class="toctree-l3"><a class="reference internal" href="#tree-tab-right-panel">Tree Tab – Right Panel</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="#templated-nodes">Templated Nodes</a></li>
<li class="toctree-l2"><a class="reference internal" href="#enable-fixed-value-list-enum-option">Enable Fixed Value List (Enum option)</a></li>
<li class="toctree-l2"><a class="reference internal" href="#dimensional-node-component">Dimensional Node Component</a></li>
<li class="toctree-l2"><a class="reference internal" href="#search-option-in-additional-properties-sheet">Search option in Additional Properties Sheet</a></li>
<li class="toctree-l2"><a class="reference internal" href="#quick-editor-option-in-tree-tab">Quick Editor option in Tree Tab</a></li>
<li class="toctree-l2"><a class="reference internal" href="#prior-period-in-formula">Prior Period in Formula</a></li>
<li class="toctree-l2"><a class="reference internal" href="#additional-properties-of-tree-tab">Additional Properties of Tree Tab</a></li>
<li class="toctree-l2"><a class="reference internal" href="#settings-tab">Settings Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="#scale-suffix">Scale Suffix</a></li>
<li class="toctree-l3"><a class="reference internal" href="#formatting-of-numeric-values">Formatting of Numeric Values</a></li>
<li class="toctree-l3"><a class="reference internal" href="#write-simulation-results-to-underlying-systems">Write simulation results to underlying systems</a><ul>
<li class="toctree-l4"><a class="reference internal" href="#steps-to-be-followed-for-writing-simulation-results-to-underlying-systems">Steps to be followed for writing simulation results to underlying systems</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="#negative-value-format">Negative Value Format</a></li>
<li class="toctree-l3"><a class="reference internal" href="#visualization">Visualization</a></li>
<li class="toctree-l3"><a class="reference internal" href="#tree-style">Tree Style</a></li>
<li class="toctree-l3"><a class="reference internal" href="#table-style">Table Style</a></li>
<li class="toctree-l3"><a class="reference internal" href="#visualization-in-runtime">Visualization in Runtime</a><ul>
<li class="toctree-l4"><a class="reference internal" href="#tree-visualization">Tree Visualization</a></li>
<li class="toctree-l4"><a class="reference internal" href="#table-visualization">Table Visualization</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="#enable-tree-editing-in-runtime">Enable Tree Editing in Runtime</a></li>
<li class="toctree-l3"><a class="reference internal" href="#enable-tooltip-in-settings-tab">Enable Tooltip in Settings Tab</a></li>
<li class="toctree-l3"><a class="reference internal" href="#enable-search-in-settings-tab">Enable Search in Settings Tab</a></li>
<li class="toctree-l3"><a class="reference internal" href="#enable-search-in-navigation-panel">Enable Search in Navigation Panel</a></li>
<li class="toctree-l3"><a class="reference internal" href="#waterfall-type-selection">Waterfall Type Selection</a></li>
<li class="toctree-l3"><a class="reference internal" href="#show-children-count">Show Children Count</a></li>
<li class="toctree-l3"><a class="reference internal" href="#conditional-formatting">Conditional Formatting</a><ul>
<li class="toctree-l4"><a class="reference internal" href="#node-level-conditional-formatting">Node Level Conditional Formatting</a></li>
</ul>
</li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="#additional-properties-of-settings-tab">Additional Properties of Settings Tab</a></li>
<li class="toctree-l2"><a class="reference internal" href="#data-tab">Data Tab</a></li>
<li class="toctree-l2"><a class="reference internal" href="#additional-properties-of-data-tab">Additional Properties of Data Tab</a></li>
<li class="toctree-l2"><a class="reference internal" href="#scripting-functions-in-vdt-component">Scripting Functions in VDT Component</a></li>
<li class="toctree-l2"><a class="reference internal" href="#scripting-for-node-simulation">Scripting for Node Simulation</a></li>
<li class="toctree-l2"><a class="reference internal" href="#scripting-for-scenario-simulation">Scripting for Scenario Simulation</a></li>
<li class="toctree-l2"><a class="reference internal" href="#vdt-navigation-panel-component">VDT Navigation Panel Component</a></li>
<li class="toctree-l2"><a class="reference internal" href="#scripting-functions-in-vdt-navigation-panel-component">Scripting Functions in VDT Navigation Panel Component</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="#value-driver-tree-result-as-data-source">Value Driver Tree result as Data Source</a></li>
<li class="toctree-l1"><a class="reference internal" href="#excel-as-data-source">Excel as Data Source</a></li>
<li class="toctree-l1"><a class="reference internal" href="#csv-data-source">CSV Data Source</a></li>
<li class="toctree-l1"><a class="reference internal" href="#edit-scenario-and-description">Edit Scenario and Description</a></li>
<li class="toctree-l1"><a class="reference internal" href="#export-config">Export Config</a></li>
<li class="toctree-l1"><a class="reference internal" href="#detail-page-component">Detail Page Component</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#additional-properties-of-detail-page-component">Additional Properties of Detail Page Component</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="#single-data-series">Single Data Series</a><ul>
<li class="toctree-l2"><a class="reference internal" href="#primary-data-series">Primary Data Series</a></li>
<li class="toctree-l2"><a class="reference internal" href="#primary-data-series-with-comparison-data-series">Primary Data Series with Comparison Data Series</a></li>
<li class="toctree-l2"><a class="reference internal" href="#single-data-point">Single Data Point</a></li>
<li class="toctree-l2"><a class="reference internal" href="#single-data-point-with-comparison">Single Data Point with Comparison</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="#variance-analysis">Variance Analysis</a></li>
<li class="toctree-l1"><a class="reference internal" href="#dynamic-tree-from-data-source">Dynamic Tree from Data Source</a></li>
<li class="toctree-l1"><a class="reference internal" href="#known-issues-and-limitations">Known Issues and Limitations</a></li>
</ul>
</div>
</div>
</nav>
<section data-toggle="wy-nav-shift" class="wy-nav-content-wrap">
<nav class="wy-nav-top" aria-label="top navigation">
<i data-toggle="wy-nav-top" class="fa fa-bars"></i>
<a href="index.html">Visual BI valQ for SAP Lumira Designer</a>
</nav>
<div class="wy-nav-content">
<div class="rst-content">
<div role="navigation" aria-label="breadcrumbs navigation">
<ul class="wy-breadcrumbs">
<li><a href="index.html">Docs</a> »</li>
<li>Copyright</li>
<li class="wy-breadcrumbs-aside">
</li>
</ul>
<hr/>
</div>
<div role="main" class="document" itemscope="itemscope" itemtype="http://schema.org/Article">
<div itemprop="articleBody">
<div class="section" id="copyright">
<h1>Copyright<a class="headerlink" href="#copyright" title="Permalink to this headline">¶</a></h1>
<p>©Visual BI Solutions, Inc. (“Visual BI”). All rights reserved. No part
of this document may be reproduced or transmitted in any form or by any
means, electronic or mechanical, for any purpose, without the express
written permission of Visual BI. Under the law, reproducing includes
translating into another language or format.</p>
<p>As between the parties, Visual BI retains title to, and ownership of,
all proprietary rights with respect to the software contained within its
products. The software is protected by United States copyright laws and
international treaty provision. Therefore, you must treat the software
like any other copyrighted material (e.g. a book or sound recording).</p>
<p>Every effort has been made to ensure that the information in this manual
is accurate. Visual BI Solutions is not responsible for printing or
clerical errors. Information in this document is subject to change
without notice.</p>
<div class="section" id="trademark-information">
<h2>Trademark Information<a class="headerlink" href="#trademark-information" title="Permalink to this headline">¶</a></h2>
<p>Visual BI® and the Visual BI logo design are trademarks of Visual BI. in
the United States and various other countries. All other trademarks are
the property of their respective owners.</p>
</div>
<div class="section" id="patent-information">
<h2>Patent Information<a class="headerlink" href="#patent-information" title="Permalink to this headline">¶</a></h2>
<p>The accompanying product is protected by one or more U.S. and foreign
patents and/or pending patent applications held by Visual BI.</p>
</div>
<div class="section" id="sap-trademarks">
<h2>SAP Trademarks<a class="headerlink" href="#sap-trademarks" title="Permalink to this headline">¶</a></h2>
<p>SAP and other SAP products and services mentioned herein as well as
their respective logos are trademarks or registered trademarks of SAP SE
(or an SAP affiliate company) in Germany and other countries. All other
product and service names mentioned are the trademarks of their
respective companies. Please see
<a class="reference external" href="http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark">http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark</a> for
additional trademark information and notices.</p>
</div>
</div>
<div class="section" id="definitions">
<h1>Definitions<a class="headerlink" href="#definitions" title="Permalink to this headline">¶</a></h1>
<table border="1" class="docutils">
<colgroup>
<col width="50%" />
<col width="50%" />
</colgroup>
<tbody valign="top">
<tr class="row-odd"><td>Design Studio</td>
<td>SAP BusinessObjects™ Design
Studio</td>
</tr>
<tr class="row-even"><td>Lumira Designer</td>
<td>SAP Lumira Designer</td>
</tr>
<tr class="row-odd"><td>Value Driver Tree Extension (valQ)</td>
<td>Value Driver Trees for Lumira
Designer and Design Studio</td>
</tr>
<tr class="row-even"><td>Value Driver Tree</td>
<td>Mathematical or conceptual
business models visualised in a
way that links the business KPI’s
(what management or stakeholders
care about) to the operational
drivers (the things that can be
influenced to change the KPI’s).</td>
</tr>
<tr class="row-odd"><td>Node</td>
<td>A generic reference to a unique
KPI or Value Driver in a value
driver tree</td>
</tr>
<tr class="row-even"><td>Node Widget</td>
<td>The visualization of a KPI or
Value Driver in a value driver
tree</td>
</tr>
<tr class="row-odd"><td>Derived Node</td>
<td>Additional Information for a node
but not directly related to the
calculation hierarchy. This will
often be key benchmarking KPI’s
such as cost/production unit.</td>
</tr>
<tr class="row-even"><td>Parent</td>
<td>A reference to the Node one level
above in the Value Driver Tree</td>
</tr>
<tr class="row-odd"><td>Children</td>
<td>A reference to the collection of
nodes immediately below a Node</td>
</tr>
</tbody>
</table>
</div>
<div class="section" id="introduction">
<h1>Introduction<a class="headerlink" href="#introduction" title="Permalink to this headline">¶</a></h1>
<div class="section" id="document-history">
<h2>Document History<a class="headerlink" href="#document-history" title="Permalink to this headline">¶</a></h2>
<p>This document is valid for the releases shown in the Table below (see
Table 3.1):</p>
<table border="1" class="docutils">
<colgroup>
<col width="26%" />
<col width="26%" />
<col width="12%" />
<col width="36%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">Major Release</th>
<th class="head">Minor Release</th>
<th class="head">Patch</th>
<th class="head">Date</th>
</tr>
</thead>
<tbody valign="top">
<tr class="row-even"><td><strong>2</strong></td>
<td><strong>0</strong></td>
<td><strong>0</strong></td>
<td><strong>December 2017*</strong></td>
</tr>
<tr class="row-odd"><td>2</td>
<td>0</td>
<td>5</td>
<td>July 2018</td>
</tr>
<tr class="row-even"><td><strong>3</strong></td>
<td><strong>0</strong></td>
<td><strong>0</strong></td>
<td><strong>February 2019*</strong></td>
</tr>
<tr class="row-odd"><td><strong>3</strong></td>
<td><strong>1</strong></td>
<td><strong>0</strong></td>
<td><strong>April 2019*</strong></td>
</tr>
<tr class="row-even"><td><strong>3</strong></td>
<td><strong>2</strong></td>
<td><strong>0</strong></td>
<td><strong>September 2019*</strong></td>
</tr>
</tbody>
</table>
<p>Table 3.1: Document History</p>
</div>
<div class="section" id="who-should-read-this-guide">
<h2>Who should read this guide?<a class="headerlink" href="#who-should-read-this-guide" title="Permalink to this headline">¶</a></h2>
<p>This User Guide for the Visual BI Value Driver Tree for SAP Lumira
Designer (VDT) offered by Visual BI is meant for users that are going to
use Apps leveraging the Value Driver Tree Extension to analyse value
driver relationships, compare versions such as Forecast vs Current
Budget and simulate what-if scenarios such a change in price, volumes
and efficiencies real-time.</p>
</div>
<div class="section" id="what-is-valq-for-sap-lumira-designer-suite">
<h2>What is valQ for SAP Lumira Designer Suite?<a class="headerlink" href="#what-is-valq-for-sap-lumira-designer-suite" title="Permalink to this headline">¶</a></h2>
<p>The Visual BI valQ for SAP Lumira Designer suite is
mathematical or conceptual business models visualized in a way that
links the business KPI’s (what management or stakeholders care about) to
the operational drivers (the things that can be influenced to change the
KPI’s).</p>
</div>
<div class="section" id="traditional-approach">
<h2>Traditional Approach<a class="headerlink" href="#traditional-approach" title="Permalink to this headline">¶</a></h2>
<p>Spreadsheet models are often used to support planning and forecasting.
They often contain a high number of parameters. Visualizing, simulating
and sharing models is challenging and the models often become personal
tools only understood by the accountant or engineer who created it.
Integrating data real-time and dynamically in spreadsheets is difficult
resulting in the models that often are static, point-in-time and for a
single period.</p>
</div>
</div>
<div class="section" id="instructions">
<span id="ins"></span><h1>Instructions<a class="headerlink" href="#instructions" title="Permalink to this headline">¶</a></h1>
<p>The Value Driver Tree Extension from valQ provides various components that the
Designer can use in conjunction with standard SAP components or other
extensions. The extension also offers many configuration options
allowing the designer to tailor the final App to suit your specific
needs.</p>
<p>In this guide, we will describe the common end user functionality using
the demo App as an example. It is however important to understand that
your specific implementation may differ.</p>
<p>Once your designer has implemented and configured the value driver tree,
it will be accessed the same way you access your current Design
Studio/Lumira Apps. This would typically be via the BI Launchpad or via
an OpenDoc URL.</p>
<p>When you open a Value Driver Tree App, it will open in a similar manner
at the screenshot below:</p>
<div class="figure align-center" id="id5">
<img alt="alternate text" src="_images/4.1.jpg" />
<p class="caption"><span class="caption-text">Value Driver Tree</span></p>
</div>
<p>The left panel is the navigation panel, you can hide this panel by
clicking on the top left corner icon <a class="reference internal" href="_images/image3.png"><img alt="image3" src="_images/image3.png" style="width: 0.16667in; height: 0.15625in;" /></a>. On the canvas you will
find the value driver tree. By the default the tree is open on collapsed
mode at a level defined by the designer. This is typically completely
collapsed.</p>
<div class="section" id="input-data">
<h2>Input Data<a class="headerlink" href="#input-data" title="Permalink to this headline">¶</a></h2>
<p>The Value Driver Tree works with two input data series – the primary and
the comparison data series. A common way of using this is to compare
Forecast vs Budget, Budget vs Last Year Actuals etc. The data series is
at a certain time grain. This would typically be 1 year by 12 months or
a multiyear view like 5 years plan by year.</p>
<p>The selecting of the time series will often be based on Filters or
Variables. A typical scenario is where the designer has defined 4
variables on the underlying data sources:</p>
<p>Primary:</p>
<p>Version: ie. Defaulted to Forecast</p>
<p>Year: ie. Defaulted to Current Year</p>
<p>Comparison:</p>
<p>Version ie. Defaulted to Budget</p>
<p>Year ie. Defaulted to Current Year</p>
<p>This allows the users to compare different versions and years in the
value driver tree model.</p>
<p>The Value Driver Tree can display individual periods but can also apply
time aggregation such as Full Year, Year-to-Date. You can see the
currently selected Value Display aggregation on the Navigation Panel. In
the screenshot above, Full Year is selected. The primary value displayed
on the Widgets is therefore in this instance the Full Year aggregated
data.</p>
</div>
<div class="section" id="tree-drill-down">
<h2>Tree Drill Down<a class="headerlink" href="#tree-drill-down" title="Permalink to this headline">¶</a></h2>
<p>Nodes that has children will have an expand ‘>’ button to the right of
the Widget as highlighted below:</p>
<div class="figure align-center" id="id6">
<img alt="alternate text" src="_images/4.2.jpg" />
<p class="caption"><span class="caption-text">Nodes with children</span></p>
</div>
<p>You can drill down the tree by clicking the expand button.</p>
<p>The tree will focus on the branches that are being expanded. You can
collapse any specific node by clicking the ‘<’ collapse button on the
right of a widget.</p>
<p>Value Driver Trees are in reality networks. The same driver may impact
multiple aspects of the Tree. The component therefore contains a concept
of linked nodes. Such nodes have a link <a class="reference internal" href="_images/image5.png"><img alt="image5" src="_images/image5.png" style="width: 0.14583in; height: 0.17708in;" /></a> icon that you can click
which will jump to where the linked node is defined and highlight the
node:</p>
<div class="figure align-center" id="id7">
<img alt="alternate text" src="_images/4.3.jpg" />
<p class="caption"><span class="caption-text">Link</span></p>
</div>
<div class="figure align-center" id="id8">
<img alt="alternate text" src="_images/4.4.jpg" />
<p class="caption"><span class="caption-text">Linked Nodes</span></p>
</div>
<p>To collapse all nodes, click on the collapse icon on the bottom left of
the canvas <a class="reference internal" href="_images/image8.png"><img alt="image8" src="_images/image8.png" style="width: 1in; height: 0.25in;" /></a></p>
</div>
<div class="section" id="node-level-comments">
<h2>Node level Comments<a class="headerlink" href="#node-level-comments" title="Permalink to this headline">¶</a></h2>
<p>As part of the New Release, comments can be provided for the Scenarios/Initiatives at the Node Level for reference (see Figure below)</p>
<div class="figure align-center" id="id9">
<img alt="alternate text" src="_images/ncm1.png" />
<p class="caption"><span class="caption-text">Node Level Comments</span></p>
</div>
<p>For our example, Red color has been selected for the Comment and the comment is given as “Alert” (see Figure below).</p>
<div class="figure align-center" id="id10">
<img alt="alternate text" src="_images/ncm2.png" />
<p class="caption"><span class="caption-text">Node Level Comments</span></p>
</div>
<p>Based on the above configuration, you will be able to view the Node Level Comment as shown below:</p>
<div class="figure align-center" id="id11">
<img alt="alternate text" src="_images/ncm3.png" />
<p class="caption"><span class="caption-text">Node Level Comments</span></p>
</div>
<p>The comment panel will follow the material design as shown below:</p>
<div class="figure align-center" id="id12">
<img alt="alternate text" src="_images/ncm4.png" />
<p class="caption"><span class="caption-text">Comment Panel</span></p>
</div>
<p>The comments will be stored along with API and Bookmarking as part of the scenario (see Figure below).</p>
<div class="figure align-center" id="id13">
<img alt="alternate text" src="_images/ncm5.png" />
<p class="caption"><span class="caption-text">Comments in the Scenario Panel</span></p>
</div>
</div>
<div class="section" id="zoom-and-pan">
<h2>Zoom and Pan<a class="headerlink" href="#zoom-and-pan" title="Permalink to this headline">¶</a></h2>
<p>Value Driver Trees can be large. You can zoom and pan the canvas view.
If you are using an iPad or iPhone, you can zoom by pinching and pan by
dragging the same way you would navigate a map.</p>
<p>If you are using a mouse with a scroll wheel, you can point your curser
anywhere in the canvas and scroll the wheel to zoom in and out.</p>
<p>To pan, click and hold the left bottom of the mouse and drag the tree
around.</p>
<p>You can also use the zoom button to zoom if your devise doesn’t support
other options <a class="reference internal" href="_images/image9.png"><img alt="image9" src="_images/image9.png" style="width: 1.04167in; height: 0.23958in;" /></a></p>
</div>
<div class="section" id="value-display-and-simulation-period">
<h2>Value Display and Simulation Period<a class="headerlink" href="#value-display-and-simulation-period" title="Permalink to this headline">¶</a></h2>
<div class="figure align-center" id="id14">
<img alt="alternate text" src="_images/4.5.jpg" />
<p class="caption"><span class="caption-text">Value Display</span></p>
</div>
<p>With the ‘Value Display’ functionality you can choose the time
aggregation you want to display as the primary value. The designer can
link certain nodes to a user selected scaling. You can select the scale
you wish to display by selecting this under the Value Display section.
Note that the options here can be configured so they may differ. It is
important to note that not all notes are scaled using this as the value
driver tree typically contains both amounts, prices, rates and physical
volumes.</p>
<p>In addition to the primary display value, the designer can also choose a
secondary value to be displayed. I.e. if you are showing Full Year as
primary, in the below example, it has been configured to visualize the
Month data as secondary:</p>
<div class="figure align-center" id="id15">
<img alt="alternate text" src="_images/4.6.jpg" />
<p class="caption"><span class="caption-text">Value Display</span></p>
</div>
<p>The time aggregation and display relates to the Simulation Period
selected.</p>
<p>When <strong>Month</strong> is selected, it shows the first month of the simulation
interval selected. By default, the simulation period is the selected
period and the future. This is an important concept as when we simulate,
we generally don’t want to apply a change to the past as we can’t change
it. It is possible to also set the ‘to’ period in a simulation, just
click <a class="reference internal" href="_images/image12.png"><img alt="image12" src="_images/image12.png" style="width: 0.25in; height: 0.23958in;" /></a> and highlight the month you want as the end period of a
simulation. This is however a special scenario.</p>
<div class="figure align-center" id="id16">
<img alt="alternate text" src="_images/4.7.jpg" />
<p class="caption"><span class="caption-text">Simulation Period</span></p>
</div>
<p><strong>YTD</strong> – the selected period -1 is the year to date data (eg. selected
simulation period is September to December, the YTD data will be from
Jan to August).</p>
<p>Note: Simulation of future periods will not impact the YTD data.</p>
<div class="figure align-center" id="id17">
<img alt="alternate text" src="_images/4.8.jpg" />
<p class="caption"><span class="caption-text">Value Display and Simulation Period</span></p>
</div>
<p><strong>Full Year</strong> – Shows the full year cumulated data</p>
<div class="figure align-center" id="id18">
<img alt="alternate text" src="_images/4.9.jpg" />
<p class="caption"><span class="caption-text">Value Display and Simulation Period</span></p>
</div>
<p><strong>Sim. Period</strong> – to simulate a specific period, for example a 3 month
rolling forecast from September to November, click the first month
September then click <a class="reference internal" href="_images/image12.png"><img alt="image16" src="_images/image12.png" style="width: 0.25in; height: 0.23958in;" /></a>and click the last month November for
simulation. You can then choose to only show the values aggregated for
the selected simulation periods</p>
<div class="figure align-center" id="id19">
<img alt="alternate text" src="_images/4.10.jpg" />
<p class="caption"><span class="caption-text">Value Display and Simulation Period</span></p>
</div>
</div>
<div class="section" id="value-driver-tree-views-filters">
<h2>Value Driver Tree views - Filters<a class="headerlink" href="#value-driver-tree-views-filters" title="Permalink to this headline">¶</a></h2>
<p>If your Value Driver Tree is large, the designer may have defined
specific sub views. These would be listed under the Value Driver Trees
Section of the Navigation Panel. When clicking on of these views, the
tree will be filtered and the specific node will be made the top node.
Calculation dependencies are still respected but this significantly
improves the navigation as it focuses the tree on a specific area.</p>
<p>In this example, the options defined are:</p>
<ul class="simple">
<li>Open all company level: Net Profit</li>
<li>Open per department: Mining, Processing or the operational tree for
Mill Throughput</li>
</ul>
<div class="figure align-center" id="id20">
<img alt="alternate text" src="_images/4.11.jpg" />
<p class="caption"><span class="caption-text">Value Driver Tree - Filters</span></p>
</div>
</div>
<div class="section" id="kpis">
<h2>KPIs<a class="headerlink" href="#kpis" title="Permalink to this headline">¶</a></h2>
<p>The Navigation Panel can be configured to list a set of KPI’s from the
value driver tree. You are able to navigate to each of them for a fast
view on the simulation impact on a given KPI. Click on the KPI to
navigate to the node.</p>
<div class="figure align-center" id="id21">
<img alt="alternate text" src="_images/4.12.jpg" />
<p class="caption"><span class="caption-text">KPIs</span></p>
</div>
</div>
<div class="section" id="data-simulation">
<h2>Data Simulation<a class="headerlink" href="#data-simulation" title="Permalink to this headline">¶</a></h2>
<p>There are 2 options to simulate:</p>
<ul class="simple">
<li>Hover over a desired node to simulate, slide the scaling button to
right for positive impact or left for negative impact. The simulation
will be showed on the right hand side. A window will open displaying
the changes. The pencil icon will display the change in percentage
that has been made: <a class="reference internal" href="_images/image19.png"><img alt="image20" src="_images/image19.png" style="width: 0.28125in; height: 0.29167in;" /></a>, and a legend with percentage showing
if the adjust has made the scenario better or worse <a class="reference internal" href="_images/image20.png"><img alt="image21" src="_images/image20.png" style="width: 0.5625in; height: 0.25in;" /></a>.</li>
</ul>
<div class="figure align-center" id="id22">
<img alt="alternate text" src="_images/4.13.jpg" />
<p class="caption"><span class="caption-text">Data Simulation</span></p>
</div>
<ul class="simple">
<li>Click on the arrow icon of the node <a class="reference internal" href="_images/image22.png"><img alt="image23" src="_images/image22.png" style="width: 0.1875in; height: 0.16667in;" /></a> then click ‘Edit Key
Input’ <a class="reference internal" href="_images/image23.png"><img alt="image24" src="_images/image23.png" style="width: 0.16667in; height: 0.1875in;" /></a> and manually edit the changes in simulation per
period. Click X to close manual input table.</li>
</ul>
<p>Notes</p>
<ul class="simple">
<li>You can update the periods highlighted in YELLOW based on the
selected simulation period.</li>
</ul>
<div class="figure align-center" id="id23">
<img alt="alternate text" src="_images/4.14.jpg" />
<p class="caption"><span class="caption-text">Simulation Periods</span></p>
</div>
<p>The edit icon will indicate the months that have been edited</p>
<div class="figure align-center" id="id24">
<img alt="alternate text" src="_images/4.15.jpg" />
<p class="caption"><span class="caption-text">Simulation Periods</span></p>
</div>
<ul class="simple">
<li>You can update the ‘Variation’ column which will overwrite the
numbers in the selected simulation periods. Any manual updates in
period will not be overwritten by the ‘Variation’ column. In the
example below, in blue are the months which were manually edited and
in orange are highlighted the variation and in this case the month to
which the variation was applied.</li>
</ul>
<div class="figure align-center" id="id25">
<img alt="alternate text" src="_images/4.16.jpg" />
<p class="caption"><span class="caption-text">Simulation Periods</span></p>
</div>
<p>Click reset icon to return to the original data <a class="reference internal" href="_images/image27.png"><img alt="image28" src="_images/image27.png" style="width: 0.21875in; height: 0.21875in;" /></a>.</p>
</div>
<div class="section" id="key-inputs">
<h2>Key Inputs<a class="headerlink" href="#key-inputs" title="Permalink to this headline">¶</a></h2>
<p>Key Inputs is available on the left side panel to directly simulate key
cost drivers without going into the node details.</p>
<p>Click the ‘Edit Key Input’ icon <a class="reference internal" href="_images/image23.png"><img alt="image29" src="_images/image23.png" style="width: 0.16667in; height: 0.1875in;" /></a> and manually edit the changes
in simulation per periods.</p>
<div class="figure align-center" id="id26">
<img alt="alternate text" src="_images/4.17.jpg" />
<p class="caption"><span class="caption-text">Key Inputs</span></p>
</div>
<p>Notes:</p>
<ul class="simple">
<li>Can update the periods highlighted in YELLOW based on the selected
simulation period. All the changes in the Key Assumptions are
highlighted in the left side panel side.</li>
</ul>
<div class="figure align-center" id="id27">
<img alt="alternate text" src="_images/4.18.jpg" />
<p class="caption"><span class="caption-text">Simulation Periods</span></p>
</div>
<p>Click X to close manual input table.</p>
<ul class="simple">
<li>Click a Key Assumption or Key Performance Indicator and it will
highlight the source nodes to further check the details.</li>
</ul>
<div class="figure align-center" id="id28">
<img alt="alternate text" src="_images/4.19.jpg" />
<p class="caption"><span class="caption-text">Key Inputs</span></p>
</div>
<p>All simulations are highlighted in the upper right corner.</p>
<p><a class="reference internal" href="_images/image31.png"><img alt="image33" src="_images/image31.png" style="width: 2.19792in; height: 0.3125in;" /></a></p>
<p>Click <a class="reference internal" href="_images/image27.png"><img alt="image34" src="_images/image27.png" style="width: 0.21875in; height: 0.21875in;" /></a> to return to the original selected version without any
simulation.</p>
<p>When more number of simulations are done, you will be able to view the More button in the upper right corner. By clicking the More button, you will be able to see the remaining simulations as shown in the below Figure.</p>
<div class="figure align-center" id="id29">
<img alt="alternate text" src="_images/msm.png" />
<p class="caption"><span class="caption-text">Simulations - More option button</span></p>
</div>
</div>
<div class="section" id="scenario-comparison">
<h2>Scenario Comparison<a class="headerlink" href="#scenario-comparison" title="Permalink to this headline">¶</a></h2>
<p>You can create multiple scenarios in parallel, compare them as well as
sharing the collection with others.</p>
<p>This is how you do it.</p>
<ul class="simple">
<li>Update the default scenario 1.</li>
<li>Click ‘Create new Scenario’ icon <a class="reference internal" href="_images/image32.png"><img alt="image35" src="_images/image32.png" style="width: 0.21875in; height: 0.19792in;" /></a>. This copies the active
scenario.</li>
</ul>
<div class="figure align-center" id="id30">
<img alt="alternate text" src="_images/4.20.jpg" />
<p class="caption"><span class="caption-text">Scenarios</span></p>
</div>
<p>Notes:</p>
<ul class="simple">
<li>The copied scenario is the replicate of the last scenario (e.g.
Scenario 2 will have the same data from the copied Scenario 1.</li>
<li>We have the option to make additional simulation in the new scenario
or click to <a class="reference internal" href="_images/image34.png"><img alt="image37" src="_images/image34.png" style="width: 0.35417in; height: 0.20833in;" /></a> return to the original selected version without
any simulation and then make a new simulation.</li>
<li>Click ‘Compare Scenario’ icon <a class="reference internal" href="_images/image35.png"><img alt="image38" src="_images/image35.png" style="width: 0.23958in; height: 0.20833in;" /></a> to generate a report
comparison format with the key Assumptions and KPI’s.</li>
<li>Comparison report compares all scenarios that have been created in
the active collection. It also shows the Simulated Data Scenario
(Baseline: Full Year), Comparison Version (Full Year) and Simulated
Data Scenario Year to Date (Baseline: YTD).</li>
<li>Highlighted in GREEN fonts the most favorable results and in RED
fonts the least favorable result in the scenario comparison report.</li>
</ul>
<p>Click <a class="reference internal" href="_images/image36.png"><img alt="image39" src="_images/image36.png" style="width: 1.01042in; height: 0.27083in;" /></a> located in the lower left corner to extract the report
in excel format.</p>
<div class="figure align-center" id="id31">
<img alt="alternate text" src="_images/4.21.jpg" />
<p class="caption"><span class="caption-text">Full Year Scenario Comparison</span></p>
</div>
<div class="figure align-center" id="id32">
<img alt="alternate text" src="_images/4.22.jpg" />
<p class="caption"><span class="caption-text">Full Year Scenario Comparison</span></p>
</div>
</div>
<div class="section" id="switch-to-node-details-from-compare-scenarios">
<h2>Switch to Node details from compare scenarios<a class="headerlink" href="#switch-to-node-details-from-compare-scenarios" title="Permalink to this headline">¶</a></h2>
<p>As part of the New Release, you can switch down to any Node details from the compared scenarios and
it would get displayed in the Comparison Page. For our example, there are 3 different scenarios in which the Nodes
have been simulated under each scenario (see Figure below).</p>
<div class="figure align-center" id="id33">
<img alt="alternate text" src="_images/snd1.png" />
<p class="caption"><span class="caption-text">Three Scenarios in Navigation Panel</span></p>
</div>
<p>After clicking the Compare Scenarios option as shown in the above Figure, you will be able to view the
Comparison Page as shown below.</p>
<div class="figure align-center" id="id34">
<img alt="alternate text" src="_images/snd2.png" />
<p class="caption"><span class="caption-text">Three Scenarios in Detail Page</span></p>
</div>
<p>Now click the Arrow icon against the Node Net Profit as shown in the above Figure.
After clicking the Arrow icon, you will be able to view the Net Profit Node details in the Detail page (see
Figure below). You can also click the Number at the top of the scenario 1 window (see Figure above)
and you will be able to view the Net Profit Node details as part of our example.</p>
<div class="figure align-center" id="id35">
<img alt="alternate text" src="_images/snd3.png" />
<p class="caption"><span class="caption-text">Net Profit Node details in Detail page</span></p>
</div>
<p>Similarly you can view the details for other Nodes.</p>
</div>
<div class="section" id="initiatives-in-scenario">
<h2>Initiatives in Scenario<a class="headerlink" href="#initiatives-in-scenario" title="Permalink to this headline">¶</a></h2>
<p>As part of the New Release, each Scenario can have multiple number of Initiatives. Navigate to the Navigation panel and click “+” to add the Initiative in Scenario 1 (see Figure below).</p>
<div class="figure align-center" id="id36">
<img alt="alternate text" src="_images/ini1.png" />
<p class="caption"><span class="caption-text">Adding Initiatives in Scenario</span></p>
</div>
<p>In our example, two Initiatives “Initiative 1” and “Initiative 2” have been added to the Scenario 1. For Initiative 1, the simulation has been done for both the Nodes Revenue and Total Cost as shown in the below Figure.</p>
<div class="figure align-center" id="id37">
<img alt="alternate text" src="_images/ini2.png" />
<p class="caption"><span class="caption-text">Initiative 1 of Scenario 1</span></p>
</div>
<p>Now navigate to the Initiative 2 of Scenario 1. You can observe that the Nodes Revenue and Total Cost show “1” which indicates that both the Nodes are simulated once for one number of Initiative (see Figure below).</p>
<div class="figure align-center" id="id38">
<img alt="alternate text" src="_images/ini3.png" />
<p class="caption"><span class="caption-text">Initiative 2 of Scenario 1</span></p>
</div>
<p>For our example, now simulate the Node Revenue as shown in the below Figure.</p>
<div class="figure align-center" id="id39">
<img alt="alternate text" src="_images/ini4.png" />
<p class="caption"><span class="caption-text">Two Initiatives for Node Revenue</span></p>
</div>
<p>From the above Figure, you can observe that there are two number of Initiatives created for the Node Revenue. It is to be noted that any number of Initiatives can be moved from one Scenario to another Scenario by a simple drag and drop function.
Also you will be able to copy any number of Scenarios having any number of Initiatives.</p>
<div class="section" id="aggregate-value-based-on-simulation-impacts">
<h3>Aggregate value based on Simulation Impacts<a class="headerlink" href="#aggregate-value-based-on-simulation-impacts" title="Permalink to this headline">¶</a></h3>
<p>In another example, the Node Revenue in Scenario 1 has the value 416.4 (see Figure below).</p>
<div class="figure align-center" id="id40">
<img alt="alternate text" src="_images/ini4str.png" />
<p class="caption"><span class="caption-text">Three Initiatives for Node Revenue</span></p>
</div>
<p>Create three Initiatives under Scenario 1 and simulate the Node Revenue in all the three Initiatives
to different simulation values.</p>
<div class="figure align-center" id="id41">
<img alt="alternate text" src="_images/ini4a.png" />
<p class="caption"><span class="caption-text">Three Initiatives for Node Revenue</span></p>
</div>
<p>Now the Total aggregated value for the Node Revenue in Scenario 1 will be calculated as the sum of the Actual
value of the Node Revenue with the Simulation impact values of all the three Initiatives.
These Simulation Impact values can be viewed in the respective Node’s Detail Page (see Figure below)</p>
<div class="figure align-center" id="id42">
<img alt="alternate text" src="_images/ini4b.png" />
<p class="caption"><span class="caption-text">Simulation Impact Values for Three Initiatives in Node Revenue</span></p>
</div>
<p>Now the Total Aggregated value for the Node Revenue in Scenario 1 will be 416.4 + (179.0 + 249.8 + 279) = 416.4 + 707.8 = 1124.2 (see Figure below).</p>
<div class="figure align-center" id="id43">
<img alt="alternate text" src="_images/ini4c.png" />
<p class="caption"><span class="caption-text">Total Aggregated value for the Node Revenue</span></p>
</div>
</div>
<div class="section" id="initiatives-in-compare-scenarios">
<h3>Initiatives in compare scenarios<a class="headerlink" href="#initiatives-in-compare-scenarios" title="Permalink to this headline">¶</a></h3>
<p>By clicking the option “Compare Scenarios in collection” in the Navigation Panel, you will be also able to view the Initiatives in Full Year Scenario Comparison page that are part of the specific Scenario (see Figure below).</p>
<div class="figure align-center" id="id44">
<img alt="alternate text" src="_images/ini5.png" />
<p class="caption"><span class="caption-text">Initiatives view in Full Year Scenario Comparison page</span></p>
</div>
</div>
<div class="section" id="initiatives-in-waterfall-chart">
<h3>Initiatives in Waterfall Chart<a class="headerlink" href="#initiatives-in-waterfall-chart" title="Permalink to this headline">¶</a></h3>
<p>You will be able to view the Initiatives Breakdown in the Waterfall Chart which exists in the Detail Page.
The Initiatives Breakdown will be visible only when the Scenario is in active status and also the specific
Initiatives should be selected. As an example, the below Figure shows the Initiatives Breakdown for the three
different Initiatives.</p>
<div class="figure align-center" id="id45">
<img alt="alternate text" src="_images/iniwc.png" />
<p class="caption"><span class="caption-text">Initiatives Breakdown in Detail Page</span></p>
</div>
</div>
<div class="section" id="selection-of-specific-initiative">
<h3>Selection of specific Initiative<a class="headerlink" href="#selection-of-specific-initiative" title="Permalink to this headline">¶</a></h3>
<p>You will be able to select the required Initiative by clicking the respective check box
against the Initiative (see Figure below). The check boxes will be visible only when you click the Scenario Panel
as shown in the below Figure.</p>
<div class="figure align-center" id="id46">
<img alt="alternate text" src="_images/ini6.png" />
<p class="caption"><span class="caption-text">Selecting the Initiatives</span></p>
</div>
<p>In the above example, the Initiative 1 and Initiative 3 have been selected.</p>
</div>
</div>
<div class="section" id="scenario-export-with-second-level-initiatives">
<h2>Scenario Export with second level Initiatives<a class="headerlink" href="#scenario-export-with-second-level-initiatives" title="Permalink to this headline">¶</a></h2>
<p>As part of the New Release, you will be able to export the scenario with second level Initiatives.
For our example, Scenario 1 has two Initiatives, Initiative 1 and Initiative 2 (see Figure below).</p>
<div class="figure align-center" id="id47">
<img alt="alternate text" src="_images/ind1.png" />
<p class="caption"><span class="caption-text">Scenario with 2 Initiatives</span></p>
</div>
<p>After clicking the Download Scenario option as shown in the above Figure, the xml file will be downloaded
based on the configuration (see Figure below).</p>
<div class="figure align-center" id="id48">
<a class="reference internal image-reference" href="_images/ind2.png"><img alt="alternate text" src="_images/ind2.png" style="width: 1000px;" /></a>
<p class="caption"><span class="caption-text">Downloaded xml file</span></p>
</div>
<p>From the above Figure, you can observe that the downloaded xml file has one Scenario followed by
Initiative 1 and then Inititaive 2.</p>
</div>
<div class="section" id="scenario-data-in-output-data-source">
<h2>Scenario Data in output data source<a class="headerlink" href="#scenario-data-in-output-data-source" title="Permalink to this headline">¶</a></h2>
<p>Now you will be able to export the Scenario data in the output data source.
For our example, the layout that we create in Lumira Designer will be looking similar to the
Figure shown below:</p>
<div class="figure align-center" id="id49">
<img alt="alternate text" src="_images/scds1.png" />
<p class="caption"><span class="caption-text">VDT Output dataSource</span></p>
</div>
<p>From the above layout, you can observe that the VDT output data source has been assigned as a Data Source and it has been mapped to the
Advanced Table. As an end result, you will be able to view the output data source for the scenarios simulation in the Advanced Table
(see the Figures below).</p>
<div class="figure align-center" id="id50">
<img alt="alternate text" src="_images/scds2.png" />
<p class="caption"><span class="caption-text">Scenario 1 data before simulation</span></p>
</div>
<div class="figure align-center" id="id51">
<img alt="alternate text" src="_images/scds3.png" />
<p class="caption"><span class="caption-text">Scenario 1 data after simulation</span></p>
</div>
</div>
<div class="section" id="constraints">
<h2>Constraints<a class="headerlink" href="#constraints" title="Permalink to this headline">¶</a></h2>
<p>Constraints are also available in the left side panel that identifies
the metrics that are overcapacity (highlighted in RED fonts) or still
have opportunities for further improvements (WHITE fonts).</p>
<p>Notes:</p>
<ul class="simple">
<li>RED fonts means over capacity as compared to the maximum limit. (e.g.
Production Rate 1.691 tonnes per hour is over capacity as compared to
the maximum limit of 1.600 tonnes per hour).</li>
<li>WHITE fonts means still have opportunities for improvement as
compared to the maximum limit.</li>
</ul>
<div class="figure align-center" id="id52">
<img alt="alternate text" src="_images/4.23.jpg" />
<p class="caption"><span class="caption-text">Constraints</span></p>
</div>
<div class="figure align-center" id="id53">
<img alt="alternate text" src="_images/4.24.jpg" />
<p class="caption"><span class="caption-text">Constraints</span></p>
</div>
</div>
<div class="section" id="collaboration-api">
<h2>Collaboration API<a class="headerlink" href="#collaboration-api" title="Permalink to this headline">¶</a></h2>
<p>The Collaboration API details are given below:</p>
<p>Backend Code:</p>
<p><a class="reference external" href="https://github.com/visualbis/valqio">https://github.com/visualbis/valqio</a> contains sample backend server implementation using Python.</p>
<p>Demo Server:</p>
<p><a class="reference external" href="http://valqio.herokuapp.com/">http://valqio.herokuapp.com/</a> is being hosted with server for testing purpose.</p>
</div>
<div class="section" id="ibcs-chart-in-trend-analysis">
<h2>IBCS Chart in Trend Analysis<a class="headerlink" href="#ibcs-chart-in-trend-analysis" title="Permalink to this headline">¶</a></h2>
<p>IBCS Chart has been added as a new Chart type for the Node details (see Figures below).</p>
<div class="figure align-center" id="id54">
<img alt="alternate text" src="_images/ibcs1.png" />
<p class="caption"><span class="caption-text">IBCS Chart</span></p>
</div>
<div class="figure align-center" id="id55">
<img alt="alternate text" src="_images/ibcs2.png" />
<p class="caption"><span class="caption-text">IBCS Chart in Trend</span></p>
</div>
</div>
<div class="section" id="data-merge-property">
<h2>Data merge property<a class="headerlink" href="#data-merge-property" title="Permalink to this headline">¶</a></h2>
<p>The Data Merge component has been added in VDT for Append operations and the VBX Data Merge
component can be also used for advanced operations. The similar layout is shown below:</p>
<div class="figure align-center" id="id56">
<img alt="alternate text" src="_images/dmp.png" />
<p class="caption"><span class="caption-text">Data Merge component in VDT</span></p>
</div>
</div>
</div>
<div class="section" id="understanding-variances">
<h1>Understanding Variances<a class="headerlink" href="#understanding-variances" title="Permalink to this headline">¶</a></h1>
<p>The starting point for a simulation is a selection of two versions -
<strong>Primary Version</strong> and a <strong>Comparison Version</strong> and a year. For
instance a forecast vs current budget.</p>
<p>Once we start simulating, changes are applied to the primary version. We
call this changing version the Simulation.</p>
<p>To understand the improvements we achieve, we also keep track of the
original values from the primary version without simulation changes. We
therefore have 3 data series in the model that we calculate and compare:</p>
<ol class="arabic simple">
<li>Simulation (The Primary Version including applied variations)</li>
<li>Original (The Primary Version without variations)</li>
<li>Target (The Comparison Version)</li>
</ol>
<p>Based on the above, we calculate the following variances:</p>
<ul class="simple">
<li>Simulated Variance (Simulation vs Target)</li>
</ul>
<p>Q: If we changed these things, would we hit target?</p>
<ul class="simple">
<li>Simulation Impact (Simulation vs Original)</li>
</ul>
<p>Q: How much would we improve if we made these changes?</p>
<ul class="simple">
<li>Original Variance (Original vs. Target)</li>
</ul>
<p>Q: What was our variance if we did nothing?</p>
</div>
<div class="section" id="understanding-the-node-widget-information">
<h1>Understanding the Node Widget Information<a class="headerlink" href="#understanding-the-node-widget-information" title="Permalink to this headline">¶</a></h1>
<p>The Node Widget for a Value Driver displays key information such as
value, variance, simulation impacts and trend without having to navigate
further.</p>
<div class="figure align-center" id="id57">