Difference between revisions of "Customise publishing dependencies"
(→Run order) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
| − | {{Warning |heading=Warning |In the normal course of using | + | {{Warning |heading=Warning |In the normal course of using FluenceXL you should not need to change these settings as the dependencies are automatically detected when the report is published. |
If a single object is not being executed then [[Web_dependencies_troubleshooting|adding a helper formula]] is the recommended way of fixing the report. | If a single object is not being executed then [[Web_dependencies_troubleshooting|adding a helper formula]] is the recommended way of fixing the report. | ||
| − | You should | + | You should only consider using this if a particular report is causing issues. }} |
| Line 17: | Line 17: | ||
| − | The dependencies screen if found under the | + | The dependencies screen if found under the FluenceXL > More ribbon item. When opened it will be pre-populated with the automatically detected dependencies. The screen consists of two parts. |
==Required objects== | ==Required objects== | ||
| Line 25: | Line 25: | ||
==Run order== | ==Run order== | ||
| − | This is the order in which | + | This is the order in which FluenceXL objects are evaluated. Changing this can easily break reports and cause slicers/grids to get out of sync. Only adjust this with caution. |
Objects which are connected must be run in order, but if they are unconnected then order does not matter. The sheet an object is on does not matter. | Objects which are connected must be run in order, but if they are unconnected then order does not matter. The sheet an object is on does not matter. | ||
| − | For example if {{code|Slicer 1}} drives {{code|Slicer 2}} which drives {{code|Grid 1}} then those must be set up in that order as they are connected. | + | For example if {{code|Slicer 1}} drives {{code|Slicer 2}} which drives {{code|Grid 1}} then those must be set up in that order, as they are connected. |
If there is anothe grid, {{code|Grid 2}} which is not connected to any of those then it can be put anywhere in the order. It can be run before, after, or even between the other items as they do not affect each other. | If there is anothe grid, {{code|Grid 2}} which is not connected to any of those then it can be put anywhere in the order. It can be run before, after, or even between the other items as they do not affect each other. | ||
| Line 37: | Line 37: | ||
Note that opening the Customise Dependencies screen runs the dependency checks, so this will also take some time to open, but once all sheets and the run order are manual this stage will be skipped. | Note that opening the Customise Dependencies screen runs the dependency checks, so this will also take some time to open, but once all sheets and the run order are manual this stage will be skipped. | ||
| + | |||
| + | If you hold down the {{code|Shift}} key while opening the dependencies screen then the automatic detection will be skipped and it will open quickly. | ||
==Resetting== | ==Resetting== | ||
| − | If you change many of these settings you may find that you've got a report that doesn't work well and you need to reset it. To do this simply go into the screen and turn all sheets and the run order to automatic mode. This will clear out the saved changes and the normal | + | If you change many of these settings you may find that you've got a report that doesn't work well and you need to reset it. To do this simply go into the screen and turn all sheets and the run order to automatic mode. This will clear out the saved changes and the normal FluenceXL dependency checker will run again. |
Latest revision as of 16:31, 3 July 2023
This feature added in Version 9.1 allows you to define
- Which Grids and Tables are executed when each sheet is displayed.
- What order the workbook objects are evaluated in.
 |
Warning If a single object is not being executed then adding a helper formula is the recommended way of fixing the report. You should only consider using this if a particular report is causing issues. |
You can use this feature when:
- The correct objects are not executed on many sheets.
- Publication takes a very long time
- Detecting the dependencies is usually the bulk of the publication time.
The dependencies screen if found under the FluenceXL > More ribbon item. When opened it will be pre-populated with the automatically detected dependencies. The screen consists of two parts.
Required objects
This screen defines which objects are executed when each sheet is displayed. A grid/table is always executed when the sheet it is on is displayed.
If you require an object to be run, but it isn't detected then you can set the sheet to be managed manually and add it yourself. Note that this means the sheet requirements will not be updated, and you may need to return to add in more grids if they are added to the report.
Run order
This is the order in which FluenceXL objects are evaluated. Changing this can easily break reports and cause slicers/grids to get out of sync. Only adjust this with caution.
Objects which are connected must be run in order, but if they are unconnected then order does not matter. The sheet an object is on does not matter.
For example if Slicer 1 drives Slicer 2 which drives Grid 1 then those must be set up in that order, as they are connected.
If there is anothe grid, Grid 2 which is not connected to any of those then it can be put anywhere in the order. It can be run before, after, or even between the other items as they do not affect each other.
Slow to publish reports
If you have a report that takes a long time to publish it is very likely that the dependency detection is taking most of the time. If the report is finalised and is undergoing cosmetic changes, you can avoid the publishing delay by setting all sheets and the run order to manual.
Note that opening the Customise Dependencies screen runs the dependency checks, so this will also take some time to open, but once all sheets and the run order are manual this stage will be skipped.
If you hold down the Shift key while opening the dependencies screen then the automatic detection will be skipped and it will open quickly.
Resetting
If you change many of these settings you may find that you've got a report that doesn't work well and you need to reset it. To do this simply go into the screen and turn all sheets and the run order to automatic mode. This will clear out the saved changes and the normal FluenceXL dependency checker will run again.
