Client-side REST Arguments -FXLData
Jump to navigation
Jump to search
Client-side REST Arguments
The =FXLData() and =FXLDataV() functions support additional REST arguments to modify behaviour in Excel. These arguments are not passed to the Fusion Registry or Edge Server.
nocc - suppress completion of the resultset cube when startPeriod and / or endPeriod are specified. Under normal behaviour, the resultset will always span the time periods specified irrespective of whether there are observation values available. If nocc is specified in the REST Arguments, the resultset will only span time periods for which observations are available.
Examples:
nocc round=2&nocc nocc&dimensionAtObservation=REF_AREA
