FusionXL Author Helper - Revision history

Vmurrell: /* Observation Attributes */

2023-09-13T10:12:03Z

‎Observation Attributes

Vmurrell: /* Observation Attributes */

2023-09-13T10:07:07Z

‎Observation Attributes

Vmurrell: /* Data Format */

2022-10-04T14:01:20Z

‎Data Format

Vmurrell: /* Uncoded Components */

2022-10-04T13:59:57Z

‎Uncoded Components

Vmurrell: /* Using the Filter */

2022-10-04T13:59:29Z

‎Using the Filter

Vmurrell: /* Observation Attributes */

2022-10-04T13:58:57Z

‎Observation Attributes

Vmurrell: /* Overview */

2022-10-04T13:57:56Z

‎Overview

Vmurrell: /* Overview */

2022-10-04T13:55:27Z

‎Overview

Vmurrell: /* Author Helper */

2022-10-04T13:38:18Z

‎Author Helper

Vmurrell at 13:37, 4 October 2022

2022-10-04T13:37:55Z

@@ Line 28: / Line 28: @@
 For observation attributes, the dataset author helper will also include the options to choose an observation time, or set the default value.  If setting a value on the observation, then it will be inserted as a Cell comment (or note depending on the version of Excel), this is shown in the image below.
-[[File:Author Helper - Attributes example.PNG|1000px]]
+[[File:Author Helper - Attributes example.png|1000px]]
@@ Line 36: / Line 36: @@
-[[FFile:Observation with multiple attributes.png|300px]]
+[[File:Observation with multiple attributes.png|300px]]
 '''Default Observation attribute'''

← Older revision		Revision as of 10:07, 13 September 2023
Line 36:		Line 36:


−	[[~~File~~:Observation with multiple attributes.png\|300px]]	+	[[FFile:Observation with multiple attributes.png\|300px]]

	'''Default Observation attribute'''		'''Default Observation attribute'''

@@ Line 73: / Line 73: @@
-[[File:Data Format Change button.PNG|900px]]
+[[File:Data Format Change button.png|900px]]
 In this example you will see that the Allowable Content for the '''COLLECTION''' component has been set to Alpha Numeric. If you hover over the Details link. more information will be displayed. If the Change button is selected, you will see  the restriction options available.
-[[File:Data type and restrictions.PNG|800px]]
+[[File:Data type and restrictions.png|800px]]
 The format and restriction details can  be seen in the Author Helper too.
-[[File:Component details.PNG|500px]]
+[[File:Component details.png|500px]]

← Older revision		Revision as of 13:59, 4 October 2022
Line 63:		Line 63:
	An example of an uncoded Attribute is shown below.		An example of an uncoded Attribute is shown below.

−	[[File:Uncoded Attribute.~~PNG~~\|800px]]	+	[[File:Uncoded Attribute.png\|800px]]

← Older revision		Revision as of 13:59, 4 October 2022
Line 50:		Line 50:


−	[[File:Author Helper - Using the Filter.~~PNG~~\|1000px]]	+	[[File:Author Helper - Using the Filter.png\|1000px]]

	First, select the Component (in this case REF_AREA) that you want to search on, next enter refine your search. In this example Z has been entered to search for all codes which contain 'z' in either the ID or description. Matches are displayed when the '''Filter''' button is clicked.		First, select the Component (in this case REF_AREA) that you want to search on, next enter refine your search. In this example Z has been entered to search for all codes which contain 'z' in either the ID or description. Matches are displayed when the '''Filter''' button is clicked.

@@ Line 36: / Line 36: @@
-[[File:Observation with multiple attributes.PNG|300px]]
+[[File:Observation with multiple attributes.png|300px]]
 '''Default Observation attribute'''
@@ Line 43: / Line 43: @@
-[[File:Default Observation attribute.PNG|400px]]
+[[File:Default Observation attribute.png|400px]]
 ===Using the Filter===

@@ Line 7: / Line 7: @@
 An example is shown below.
-[[Author Helper for ECB TRD.png|1000px]]
+[[File:Author Helper for ECB TRD.png|1000px]]
 ===Dataset Attributes===
 Dataset attributes set a single value for the entire dataset.
-[[File:Dataset attribute.PNG|600px]]
+[[File:Dataset attribute.png|600px]]
@@ Line 18: / Line 18: @@
 Series Attributes will appear in a column along with the dimensions as shown in the example below.
-[[File:Viewing a series attribute.PNG|800px]]
+[[File:Viewing a series attribute.png|800px]]
 ===Mandatory Attributes===

@@ Line 1: / Line 1: @@
 [[Category:Fusion_XL]]
-==Author Helper==
+==Overview==
 The Author Helper is an extremely useful tool which allows you to see the Components and allowable Codes expected based on the Dataflow and Data Provider combination. If codelists have been restricted based on the Dataflow or Data Provider, then the Author Helper will not include disallowed codes.

← Older revision		Revision as of 13:37, 4 October 2022
Line 1:		Line 1:
	[[Category:Fusion_XL]]		[[Category:Fusion_XL]]
		+	==Author Helper==
		+	The Author Helper is an extremely useful tool which allows you to see the Components and allowable Codes expected based on the Dataflow and Data Provider combination. If codelists have been restricted based on the Dataflow or Data Provider, then the Author Helper will not include disallowed codes.
		+
		+	When selecting a Component in the Author Helper, the selected cell in the Excel worksheet will be automatically selected in the current row. Double clicking on a value in the Component Values section will automatically populate the current cell with the Code Id.
		+
		+	An example is shown below.
		+
		+	[[File:Author Helper for ECB TRD.PNG\|1000px]]
		+
		+	===Dataset Attributes===
		+	Dataset attributes set a single value for the entire dataset.
		+
		+	[[File:Dataset attribute.PNG\|600px]]
		+
		+
		+	===Series Attributes===
		+	Series Attributes will appear in a column along with the dimensions as shown in the example below.
		+
		+	[[File:Viewing a series attribute.PNG\|800px]]
		+
		+	===Mandatory Attributes===
		+
		+	Will appear in bold Red text if the attribute is coded, or bold Brown text if it is uncoded. In the example above, In this case, the OBS_STAUS, TIME_FORMAT and COLLECTION attributes are mandatory and coded.
		+
		+	===Observation Attributes===
		+
		+	For observation attributes, the dataset author helper will also include the options to choose an observation time, or set the default value. If setting a value on the observation, then it will be inserted as a Cell comment (or note depending on the version of Excel), this is shown in the image below.
		+
		+	[[File:Author Helper - Attributes example.PNG\|1000px]]
		+
		+
		+
		+	'''Observations with multiple attributes'''
		+	As shown in the example below, it is possible to include more than one attribute against each observation.
		+
		+
		+	[[File:Observation with multiple attributes.PNG\|300px]]
		+
		+	'''Default Observation attribute'''
		+
		+	If a data set has many observations which have the same observational attribute code, a default can be entered in the rows below the header as shown in the example below.
		+
		+
		+	[[File:Default Observation attribute.PNG\|400px]]
		+
		+	===Using the Filter===
		+
		+	If the codelist used in a dimension etc has many possible codes, you can use the filter to help you find a code as shown in the example below.
		+
		+
		+	[[File:Author Helper - Using the Filter.PNG\|1000px]]
		+
		+	First, select the Component (in this case REF_AREA) that you want to search on, next enter refine your search. In this example Z has been entered to search for all codes which contain 'z' in either the ID or description. Matches are displayed when the '''Filter''' button is clicked.
		+
		+	===Long Code Lists===
		+	Please note that if the codelsit had more than 300 codes, only the first 300 will be shown. However you can use the filter to find codes that are beyond the 300 mark.
		+
		+	===Uncoded Components===
		+
		+	Attributes which are not linked to a codelist appear on the worksheet in brown text unless they are Dimensions. Dimensions are in black text, bold if coded and normal type if they are not coded.
		+
		+	An example of an uncoded Attribute is shown below.
		+
		+	[[File:Uncoded Attribute.PNG\|800px]]
		+
		+
		+	Instead of displaying a list of codes, the Author Helper will present you with a insert box to enter data, one you press '''Insert''', the text entered will be placed into the worksheet in the selected cell.
		+
		+	===Data Format===
		+
		+	As well as the components which appear on a worksheet, the Data Structure allows formats to be set is Step 3 of the wizard via the '''Allowable Content''' feature.
		+
		+
		+	[[File:Data Format Change button.PNG\|900px]]
		+
		+	In this example you will see that the Allowable Content for the '''COLLECTION''' component has been set to Alpha Numeric. If you hover over the Details link. more information will be displayed. If the Change button is selected, you will see the restriction options available.
		+
		+
		+	[[File:Data type and restrictions.PNG\|800px]]
		+
		+	The format and restriction details can be seen in the Author Helper too.
		+
		+	[[File:Component details.PNG\|500px]]