Excel Reporting Template Data Format - Revision history

Vmurrell at 16:06, 13 November 2025

2025-11-13T16:06:44Z

Vmurrell at 16:50, 13 September 2023

2023-09-13T16:50:38Z

Vmurrell at 15:55, 10 September 2023

2023-09-10T15:55:07Z

Mnelson at 08:49, 29 September 2022

2022-09-29T08:49:30Z

Mnelson at 08:49, 29 September 2022

2022-09-29T08:49:18Z

Glenn: Glenn moved page Reporting Template to Excel Reporting Template Data Format: Moved article to a more descriptive name

2020-07-09T17:46:48Z

Glenn moved page Reporting Template to Excel Reporting Template Data Format: Moved article to a more descriptive name

Glenn at 17:45, 9 July 2020

2020-07-09T17:45:27Z

Mnelson: /* Example */

2020-03-31T14:00:40Z

‎Example

Mnelson: /* Example */

2020-03-30T21:00:46Z

‎Example

Mnelson: /* Formatting Using Query Parameters */

2020-03-30T20:54:14Z

‎Formatting Using Query Parameters

@@ Line 1: / Line 1: @@
 see [https://wiki.sdmxcloud.org/Category:SdmxDataFormat Data Formats]
-<p/>
+<p>
 [[Category:SdmxDataFormat]]
 [[Category:How_To]]

@@ Line 3: / Line 3: @@
 [[Category:SdmxDataFormat]]
 [[Category:How_To]]
 This article describes the format for reporting data using [[Data Reporting Template|Fusion Registry Excel templates]].

@@ Line 2: / Line 2: @@
 <p/>
 [[Category:SdmxDataFormat]]
 This article describes the format for reporting data using [[Data Reporting Template|Fusion Registry Excel templates]].

@@ Line 1: / Line 1: @@
 see [https://wiki.sdmxcloud.org/Category:SdmxDataFormat Data Formats]
 [[Category:SdmxDataFormat]]
 This article describes the format for reporting data using [[Data Reporting Template|Fusion Registry Excel templates]].

← Older revision		Revision as of 08:49, 29 September 2022
Line 1:		Line 1:
		+	see [https://wiki.sdmxcloud.org/Category:SdmxDataFormat Data Formats]
	[[Category:SdmxDataFormat]]		[[Category:SdmxDataFormat]]
	This article describes the format for reporting data using [[Data Reporting Template\|Fusion Registry Excel templates]].		This article describes the format for reporting data using [[Data Reporting Template\|Fusion Registry Excel templates]].

← Older revision	Revision as of 17:46, 9 July 2020
(No difference)

← Older revision		Revision as of 17:45, 9 July 2020
Line 1:		Line 1:
	[[Category:SdmxDataFormat]]		[[Category:SdmxDataFormat]]
		+	This article describes the format for reporting data using [[Data Reporting Template\|Fusion Registry Excel templates]].

	=Overview=		=Overview=

@@ Line 24: / Line 24: @@
 The following example shows how the report template can be used as a data dissemination format, using the partial parameter set to true.
-<i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/WB,GCI,1.0/GHA+MYS+NZL.GCI+STARTBUSDAYS..?format=reporttemplate&partial=true</i>
+<i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA+MYS+NZL.GCI+STARTBUSDAYS..?format=reporttemplate&partial=true</i>
 If the partial parameter is not set, then the data provider must be included in the path (/GHA at the end of the path, specifies the data provider to be Ghana)

@@ Line 30: / Line 30: @@
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.GCI../GHA?format=reporttemplate</i>
-The above query will build the full reporting universe for Ghana, but only populate the numbers that match the above query (as opposed to the partial parameter which only shows the data from the query response).  If the query is expanded, then more of the cells will be populated as the following example shows.
+The above query will build the full reporting universe for Ghana, but only populate the numbers that match the above query (as opposed to the partial parameter which only shows the data from the query response).
 <i>https://demo.metadatatechnology.com/FusionRegistry/ws/public/sdmxapi/rest/data/WB,GCI,1.0/GHA.../GHA?format=reporttemplate</i>
-The above URL only works if Ghana has actually reported the data, as the query is only obtaining the data as reported by the Data Provider GHA, it is not based on the Reference Area Dimenison which happens to have the same Code Id as the Data Provider Id.
+The reporting universe for Ghana is derived from all the possible combinations of dimension values for the Global Competative Index Dataflow, overlaid with the restrictions imposed by reporting constraints.
 <strong>Note:</strong> The same formatting can be applied using [[Data_Formats|HTTP Accept Headers]] as opposed to query parameters.
 <strong>Note:</strong> The workbooks are locked, the only editable parts are the observation cells.  It is possible to edit the observation values and load the data back into the Fusion Registry.

@@ Line 17: / Line 17: @@
 * partial=true
-The partial parameter is used to indicate that the output excel file should build the output table based on the data in the response or the [[Data_Reporting_Template#Defining_the_Universe_of_Data|universe of data]] defined by the report template definition.  <b>This partial parameter should be set to true for data dissemination</b> as it is not possible to generate a non-partial template without passing extra information about who the Data Provider is. If the partial parameter is false (which is the default if not provided), then the data query must include the Data Provider identifier as part of the path.  The report template will then be built in the context of that Data Provider, and will include all the cells that the data provider is expected to report, and of those cells, the ones that have data from the data query will be populated.  Examples of this is shown in the next section.
+The partial parameter is used to indicate that the output excel file should build the output table based on the data in the response or the [[Data_Reporting_Template#Defining_the_Universe_of_Data|universe of data]] defined by the report template definition.  <b>This partial parameter should be set to true for data dissemination</b> as it is not possible to generate a non-partial template without passing extra information about who the Data Provider is. If the partial parameter is false (which is the default if not provided), then the data query must include the Data Provider identifier as part of the path.  The report template content will then be built in the context of what the Data Provider has been configured to report, and will therefore include all the cells that the Data Provider can report for.  This is in contrast to the partial=true output which only includes cells which are part of the data reponse.
 =Example=