Wiki source code of Analyse ad-hoc

Last modified by jhurst on 2021/11/15 09:22
Show last authors
1 DigDash Enterprise provides a table editor toolbar allowing to modify the tables and cross tables in real time: adding columns or total, modifying sorts, styles,...
2
3 Modifying table becomes easy for everyone as it doesn't require any changes in the information wallet configuration.
4
5 {{ddtoc/}}
6
7 = Setting up ad-hoc analysis =
8
9 To use the “Ad-hoc analysis”, open the **Visualization configuration **dialog box, then click** Advanced Parameters** and **Visualization Parameters**.
10
11 [[image:1592898730752-725.png]]
12
13 Open the **Specific Features **tab and check the **Table editor toolbar **box:
14
15 [[image:1592898766329-356.png]]
16
17 = Modifying table content =
18
19 When viewing the table, the chart is displayed on the right and the table editor toolbar on the left:
20
21 [[image:1592899175868-854.png]]
22
23 The table editor toolbar shows the list of dimensions and measures available in the data model. It also provides a set of tools allowing to export or save your table.
24
25 Dimensions having hierarchies or drill paths are followed by … Click the dimension to display available hierarchies:
26
27 [[image:1592899201393-933.png]]
28
29 == Adding a column ==
30
31 Drag and drop the dimension or measure on the column header before which you want to insert the column.
32
33 If you want to add a hierarchy level of a dimension, click the dimension to select the appropriate level.
34
35 (% class="box infomessage" %)
36 (((
37 //Note//: if you try to drop an object (measure or dimension) on an unauthorized place, a no-entry sign will be displayed (for example, if you try to add a measure before a dimension).
38 )))
39
40 You can also add a column using right click :
41
42 Right click the header of the column before or after the column you want to add and select **Insert Dimension (after **or **before) **or **Insert Measure** **(before** or **after)** then
43
44 select the measure or dimension you want to add. If the dimension has hierarchies, the root level is automatically added (to add a hierarchy level, drag and drop it from the dimensions list on the left).
45
46 The **Insert a measure **menu is displayed only if you select a measure header or if you select the last dimension of the table (measures can only be added at the end of the table).
47
48 [[image:1592899244710-860.png]]
49
50 To add a dimension on the selected axis, select **Add dimension To axis**.
51
52 If you want to replace an axis, select **Replace Axis **then select the dimension.
53
54 == Adding a formula: ==
55
56 To add a formula, drag and drop “Formula...” at the end of the measures list.
57
58 A dialog box shows up. Enter the name and the formula:
59
60 [[image:1592899268890-197.png]]
61
62 You can select measures from the **Available Measures... **drop-down list.
63
64 You can also select a format in the drop-down list at the bottom of the dialog box. Click **OK **to add the new formula at the end of the table.
65
66
67 == Adding a transformer ==
68
69 Transformers can be added on measures to display values for the previous year, previous month, previous week or the previous day.
70
71 To add a transformer, click **Options... **under Formula, then drag and drop the transformer on the appropriate measure.
72
73 [[image:1592899287319-338.png]]
74
75 Enter the measure name and click **OK**. The measure is added to the right of the transformed measure.
76
77
78 == Removing a column ==
79
80
81 Drag and drop the column header on the table toolbar.
82
83 You can also right click the column header and select **Remove Axis **or **Remove Measure**.
84
85 In case several dimensions are on the same axis, you can remove on of these dimensions by selecting **Remove Dimension**.
86
87 == Modifying axes properties ==
88
89 === Adding or removing a total ===
90
91 Right click the column header then select **Add Overall (begin) **or **Add Overall (end)**.
92
93 [[image:1592899309394-466.png]]
94
95 Adding overall values is also available from the dimensions options: click **Options... **below the dimensions list, then drag and drop **Total (begin) **or **Total (end)** on the dimension:
96
97 [[image:1592899337175-135.png]]
98
99 To remove a total, right click the dimension and select **Remove Total**.
100
101 === Adding or removing a Top/Bottom ===
102
103 Right click the column header then select **Add Top **or **Add Bottom **then select the measure on which you want to apply the top or bottom. Finally, enter the number of values of your top/bottom.
104
105 To remove a Top/bottom select **Remove Top/Bottom/Range**.
106
107 [[image:1592899358826-608.png]]
108
109
110 === Selecting a range of values ===
111
112 To select a range of values for a measure on a specific dimension, right click the dimension header, then select **Add range**. The list of measures table is displayed.
113
114 [[image:1592899375491-234.png]]
115
116 Select the measure to use then the range of values.
117
118 [[image:1592899389308-676.png]]
119
120 Click **OK **to display the resulting table:
121
122 [[image:1592899405613-167.png]]
123
124 To remove a range of values, select **Remove Top/Bottom/Range**.
125
126 === Adding or removing a sort ===
127
128 Right click the column header then select **Add Ascending Sort **or **Add Descending Sort**. If you want to add a measure sort, select **Add Sort on Measure (asc.) **or **Add Sort on Measure (desc.) **then select the measure.
129
130 Adding sort is also available in the dimensions options. Click **Options... **below the dimensions list then drag and drop **Sort (asc.) **or **Sort (desc.)** on the dimension.
131
132 [[image:1592899428011-481.png]]
133
134 To remove a sort, right click the column header and select **Remove Sort**.
135
136 === Modifying measure aggregation ===
137
138 Right click the measure header then select **Change aggregation **and choose one of the available functions: Sum, Average, Min, Max or Running Sum.
139
140 [[image:1592899446200-960.png]]
141
142 You can also change the aggregation by selecting it in the measures options. Click **Options... **below the measures list, then drag and drop the aggregation on the measure header.
143
144 [[image:1592899463693-472.png]]
145
146 === Modifying column format ===
147
148 Right click the measure or continuous dimension header (date dimension for example), then select **Change format **and select the desired format.
149
150 = Modifying table styles =
151
152 To modify the tables styles, click **Edit Styles **at the top of the toolbar, then click the column header to modify the column style.
153
154 (% class="box infomessage" %)
155 (((
156 //Note//: click **Edit styles **again to switch back the the table edition.
157 )))
158
159 * To modify a row, column or cell style: select the cell, right click and choose the element you want to modify (cell, row or column) then the modification type: background, cell or border.
160 * You can also:
161 ** Hide a row or a column: select row or column, then select **Hide row **or **Hide column**.
162 ** Change the text of a cell: select cell, then **Text **and enter the text. The text can include variable like ${Filter Dim} where Dim is the filtered dimension. At display, the variable is replaced by the filter value on the “Dim” dimension.
163 ** Insert a row: select **Insert Row**, then indicate whether the row must be placed before or after the current row. Enter values of each row cell.
164
165 [[image:1592899501256-405.png]]
166
167
168 = Save a table =
169
170 == Save a view ==
171
172 To save the current view of your table, click **Views... **then **Save Current View**. Enter the view name, then click **OK**.
173
174 The view is saved in the flow. To display a view, click on its name.
175
176 To remove a view, click the red cross besides the view name.
177
178 [[image:1592899538498-753.png]]
179
180 == Export a table ==
181
182 To export a table, click **Export... **then select the export type: PDF, PPT, XLS, CSV or flow. If you export your table as a flow, this one is added to the user or role wallet (same wallet as the flow you modify).
183
184 == Reset the view ==
185
186 To display the initial table again, click **Views... **then **Reset the view**
187
188 [[image:1592899557717-289.png]]
189
190
191