-
Notifications
You must be signed in to change notification settings - Fork 8
/
Copy pathStorage and Collaboration.html
373 lines (261 loc) · 18.6 KB
/
Storage and Collaboration.html
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
<!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>Storage and Collaboration — valQ Custom Visual for Microsoft Power BI 1.0.0 documentation</title>
<script type="text/javascript" src="_static/js/modernizr.min.js"></script>
<script type="text/javascript" id="documentation_options" data-url_root="./" src="_static/documentation_options.js"></script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/underscore.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<script type="text/javascript" src="_static/language_data.js"></script>
<script type="text/javascript" src="_static/js/theme.js"></script>
<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="next" title="Known Issues and Limitations" href="Knownissues.html" />
<link rel="prev" title="Analyze Tab" href="AnalyzeCategory.html" />
</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"> valQ Custom Visual for Microsoft Power BI
<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"><a class="reference internal" href="Copyright.html">Copyright</a><ul>
<li class="toctree-l2"><a class="reference internal" href="Copyright.html#trademark-information">Trademark Information</a></li>
<li class="toctree-l2"><a class="reference internal" href="Copyright.html#patent-information">Patent Information</a></li>
<li class="toctree-l2"><a class="reference internal" href="Copyright.html#microsoft-power-bi-trademarks">Microsoft Power BI Trademarks</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Introduction.html">Introduction</a><ul>
<li class="toctree-l2"><a class="reference internal" href="Introduction.html#document-history">Document History</a></li>
<li class="toctree-l2"><a class="reference internal" href="Introduction.html#who-should-read-this-guide">Who should read this guide?</a></li>
<li class="toctree-l2"><a class="reference internal" href="Introduction.html#what-is-the-visual-bi-valq-for-power-bi-as-a-custom-visual-component">What is the Visual BI valQ for Power BI as a Custom Visual Component?</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Definitions.html">Definitions</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html">General Features of valQ Custom Visual</a><ul>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#instructions-for-valq-custom-visual">Instructions for valQ Custom Visual</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#input-data">Input Data</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#tree-drill-down">Tree Drill Down</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#zoom-and-pan">Zoom and Pan</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#expand-collapse-of-tree-view">Expand/Collapse of Tree View</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#value-display-and-simulation-period">Value Display and Simulation Period</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#sub-models-filters">Sub Models - Filters</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#kpis">KPIs</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#data-simulation">Data Simulation</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#key-inputs">Key Inputs</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#scenarios-functionality">Scenarios Functionality</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#constraints">Constraints</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#visualization">Visualization</a></li>
<li class="toctree-l2"><a class="reference internal" href="Generalfeatures.html#contextual-help-information">Contextual Help Information</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#understanding-variances">Understanding Variances</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#understanding-the-node-widget-information">Understanding the Node Widget Information</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#conducting-what-if-analysis">Conducting what-if analysis</a></li>
<li class="toctree-l1"><a class="reference internal" href="Generalfeatures.html#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="Generalfeatures.html#saving-and-opening-scenarios">Saving and Opening Scenarios</a></li>
<li class="toctree-l1"><a class="reference internal" href="valQ.html">valQ in Power BI</a></li>
<li class="toctree-l1"><a class="reference internal" href="ModelCategory.html">Model Tab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#new-tab">New Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#open-a-sample-model">Open a Sample Model</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#general">General</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#configuration">Configuration</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#display">Display</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#simulation">Simulation</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#business-definition">Business Definition</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#conditional-formatting">Conditional Formatting</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#secondary-kpis">Secondary KPIs</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#create-a-simple-model">Create a Simple Model</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#read-only-dynamic-tree-in-editor">Read only Dynamic Tree in Editor</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#dynamic-scaling-on-dynamic-tree">Dynamic Scaling on Dynamic Tree</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#create-an-advanced-model">Create an Advanced Model</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#import-an-advanced-model">Import an Advanced Model</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#import-from-excel">Import from Excel</a></li>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#import-from-an-export-file">Import from an Export File</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-new-tab">Additional Properties of New Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#node-tab">Node Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#quick-editor-in-node-tab">Quick Editor in Node Tab</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-node-tab">Additional Properties of Node Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#data-series-tab">Data Series Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#data-series-manager">Data Series Manager</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#time-aggregation-labels">Time Aggregation Labels</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#data-sorting">Data Sorting</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-data-series-tab">Additional Properties of Data Series Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#settings-tab">Settings Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#navigation-panel">Navigation Panel</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#nodes">Nodes</a><ul>
<li class="toctree-l4"><a class="reference internal" href="ModelCategory.html#contribution-and-performance-variance-percentage">Contribution and Performance Variance Percentage</a></li>
</ul>
</li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#canvas">Canvas</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#number-formatting">Number Formatting</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#id1">Conditional Formatting</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#color-theme">Color Theme</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-settings-tab">Additional Properties of Settings Tab</a></li>
</ul>
</li>
<li class="toctree-l2"><a class="reference internal" href="ModelCategory.html#general-tab">General Tab</a><ul>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#license-registration">License Registration</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#export">Export</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#writeback">Writeback</a></li>
<li class="toctree-l3"><a class="reference internal" href="ModelCategory.html#additional-properties-of-the-general-tab">Additional Properties of the General Tab</a></li>
</ul>
</li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="PlanCategory.html">Plan Tab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="PlanCategory.html#understanding-the-features">Understanding the features</a></li>
<li class="toctree-l2"><a class="reference internal" href="PlanCategory.html#budgeting-allocation-scenarios">Budgeting & allocation scenarios</a></li>
<li class="toctree-l2"><a class="reference internal" href="PlanCategory.html#other-features">Other features</a><ul>
<li class="toctree-l3"><a class="reference internal" href="PlanCategory.html#adding-a-note">Adding a Note</a></li>
<li class="toctree-l3"><a class="reference internal" href="PlanCategory.html#view-history">View History</a></li>
</ul>
</li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="SimulateCategory.html">Simulate Tab</a></li>
<li class="toctree-l1"><a class="reference internal" href="AnalyzeCategory.html">Analyze Tab</a><ul>
<li class="toctree-l2"><a class="reference internal" href="AnalyzeCategory.html#variance-analysis">Variance Analysis</a></li>
</ul>
</li>
<li class="toctree-l1 current"><a class="current reference internal" href="#">Storage and Collaboration</a></li>
<li class="toctree-l1"><a class="reference internal" href="Knownissues.html">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">valQ Custom Visual for Microsoft Power BI</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>Storage and Collaboration</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="storage-and-collaboration">
<h1>Storage and Collaboration<a class="headerlink" href="#storage-and-collaboration" title="Permalink to this headline">¶</a></h1>
<p>The storage feature allows user to access, store, audit, collaborate, synchronize, and run further analysis on the baseline, comparison, and the simulated data series across the entire model scenarios.
Users require a dedicated ValQ workspace access authenticated by their Office 365 credentials.</p>
<p>After successful login, user can see additional options such as Sync, Comments, and History Log</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.1.png" />
</div>
<p>In the screenshot model, lets assume the user deletes a node ‘Ryan Smith’</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.2.1.png" />
</div>
<p>Lets also assume the user simulates on another node ‘Chris Morris’</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.2.2.png" />
</div>
<p>User can comment on the changes made by clicking the ‘Comments’ icon on top of the node. The comment along with the username and time log is saved and displayed.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.3.png" />
</div>
<p>User can synchronize and store the changes to the workspace by clicking the ‘Sync’ icon, naming the model, and clicking ‘Upload’.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.4.png" />
</div>
<p>The ‘History Log’ has captured the model and scenario level changes made by the user in a chronological order.
This icon helps in auditing the changes in the ValQ model.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.5.png" />
</div>
<p>The comments can also be tracked under the model level ‘Comments’ icon.
Comments window displays all user comments at Scenario-Node level.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.6.png" />
</div>
<p>ValQ has also been made collaborative - Users who are a part of the same workspace can also collaborate on the same ValQ model.
Assuming a second user accessing the same model simulates on the existing scenario, creates additional scenario, adds a new node, and comments on the changes done.
To store these changes, the user also synchronizes them to the workapce.</p>
<p>Once the first user logs in, all the changes made by the second user are synced up and displayed at the ValQ canvas.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.7.png" />
</div>
<p>The changes at a Model/Scenario level are captured at the History Log.
The comments in chronological order between users are displayed at a Node-Scenario level</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.8.png" />
</div>
<p>Lastly, users can also export their export all the data values fed and generated from ValQ - namely, basline, comparison, and scenario data.
Under the ‘Sync’ window, users can export their ValQ data by clicking ‘Export model as a web data source’, making the data series and scenario selection, and clicking ‘Download CSV’ (through Power BI Service) or copy-pasting the URLs into Excel (through Power BI Desktop)</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.9.1.png" />
</div>
<p>In Excel, the copied URLs are fed into the ‘From Web’ - ‘Advanced’ window to generate the exported data.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.10.png" />
</div>
<p>Users can also run further simulations to their scenarios and instantly synchronize the new data by refreshing the data query within ‘Queries & Connections’ in Excel.</p>
<div class="figure align-center">
<img alt="alternate text" src="_images/SC.11.png" />
</div>
</div>
</div>
</div>
<footer>
<div class="rst-footer-buttons" role="navigation" aria-label="footer navigation">
<a href="Knownissues.html" class="btn btn-neutral float-right" title="Known Issues and Limitations" accesskey="n" rel="next">Next <span class="fa fa-arrow-circle-right"></span></a>
<a href="AnalyzeCategory.html" class="btn btn-neutral float-left" title="Analyze Tab" accesskey="p" rel="prev"><span class="fa fa-arrow-circle-left"></span> Previous</a>
</div>
<hr/>
<div role="contentinfo">
<p>
© Copyright 2019, Visual BI Solutions
</p>
</div>
</footer>
</div>
</div>
</section>
</div>
<script type="text/javascript">
jQuery(function () {
SphinxRtdTheme.Navigation.enable(true);
});
</script>
</body>
</html>