Dimension at Observation- FXLData

Dimension at Observation

For horizontal presentation functions, the dimension at observation defaults to time but can be changed using the dimensionAtObservation REST argument.

REST Argument Syntax
dimensionAtObservation=<DIMENSION_ID> | AllDimensions

Behaviour

Value	Behaviour	Example
<DIMENSION_ID>	Using the ID of any other dimension in the dataset will cause the observations to be broken down by that dimension which will appear across the columns	dimensionAtObservation=REF_AREA
TIME_PERIOD	The same as the default behaviour where time is the dimension at observation	(dimensionAtObservation argument is ommitted)
AllDimensions	Setting the dimension at observation to the special value AllDimensions generates a result set with a single row per observation	dimensionAtObservation=AllDimensions

Examples
Setting REF_AREA as the dimension at observation

=FXLDataUrl("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GBR?labels=id&round=1&dimensionAtObservation=REF_AREA")

All Dimensions - the result is precisely one observation per row

=FXLDataUrl("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GBR?labels=id&round=1&dimensionAtObservation=AllDimensions")

Default behaviour with time as the dimension at observation

=FXLDataUrl("https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GBR?labels=id&round=1")