Structure Explorer - Revision history

Vmurrell at 12:34, 4 October 2022

2022-10-04T12:34:45Z

Vmurrell at 12:34, 4 October 2022

2022-10-04T12:34:21Z

Vmurrell: /* Structure Retrieval */

2022-05-04T10:57:36Z

‎Structure Retrieval

Vmurrell at 18:05, 19 April 2021

2021-04-19T18:05:33Z

Vmurrell: /* Dimensions Section */

2021-04-19T17:28:12Z

‎Dimensions Section

Vmurrell: /* Series Constraint */

2021-04-19T17:27:02Z

‎Series Constraint

Vmurrell: /* Working with Retrieved Structures */

2021-04-19T17:21:15Z

‎Working with Retrieved Structures

Vmurrell: /* Delete Structure */

2021-04-19T17:20:16Z

‎Delete Structure

Vmurrell: /* Create Structure */

2021-04-19T17:16:32Z

‎Create Structure

Vmurrell: /* Structure Retrieval */

2021-04-19T17:04:42Z

‎Structure Retrieval

@@ Line 1: / Line 1: @@
-[[Category:FusionXL]]
+[[Category:Fusion XL]]
 =Prerequisites=
 To use the Structure Explorer, you need to have installed the FXL add-in and connected to a Registry from the FusionXL tab in an Excel workbook. [[Connect_FXL_to_a_Registry|Click here to learn how to do that]].

@@ Line 1: / Line 1: @@
-[[Category:Use_Fusion_XL]]
+[[Category:FusionXL]]
 =Prerequisites=
 To use the Structure Explorer, you need to have installed the FXL add-in and connected to a Registry from the FusionXL tab in an Excel workbook. [[Connect_FXL_to_a_Registry|Click here to learn how to do that]].

@@ Line 43: / Line 43: @@
 ==Structure Retrieval==
-There are 4 ways to retrieve structures from the Registry. Regardless of how a structure is retrieved, the retrieval of the structure will result in a new worksheet being opened.  Thus, it is possible to have an Excel workbook with multiple worksheets, one for each retrieved structure.
+There are 4 ways to retrieve structures from the Registry. Regardless of how a structure is retrieved, the retrieval of the structure will result in a new worksheet being opened.  Thus, it is possible to have an Excel workbook with multiple worksheets, one for each retrieved structure. Please note that if the Registry contains >1,000 structure Excel is unable to display all structures.
 ===Browse Registry===

@@ Line 224: / Line 224: @@
 * Attributes
 * Component Restrictions
 ===Dimensions Section===

@@ Line 253: / Line 253: @@
 [[File:FXL27.PNG|800px]]
-The columns '''F-G''' define dimension groupings, where dimensions included in the group are depicted by the relevant cell having the content ‘y’. The alias for each grouping is the column header, so in this example the groups ‘Group1’, ‘Group2’, and ‘Group3’ exist. Groups can be referenced by attributes, as described in the following section. If a group alias starts with the word ‘Group’ and is followed by a numerical value (e.g. ‘Group1’) then the generated attribute will reference all of the dimensions included in the group by Id (this is the equivalent SDMX attachment type of ‘Dimension Group’). If the group alias is anything else, then the generated Data Structure will include an explicit Group, with the id being set to the group alias. Any Dimensions that reference an explicit group will reference the Group by Id in the generated Data Structure Definition.
+The columns '''F-G''' define dimension groupings, where dimensions included in the group are depicted by the relevant cell having the content ‘y’. The alias for each grouping is the column header, so in this example the groups ‘Group1’, ‘Group2’, and ‘Group3’ exist. Groups can be referenced by attributes, as described in the following section. If a group alias starts with the word ‘Group’ and is followed by a numerical value (e.g., ‘Group1’) then the generated attribute will reference all of the dimensions included in the group by Id (this is the equivalent SDMX attachment type of ‘Dimension Group’). If the group alias is anything else, then the generated Data Structure will include an explicit Group, with the id being set to the group alias. Any Dimensions that reference an explicit group will reference the Group by Id in the generated Data Structure Definition.
 ===Attributes Section===

@@ Line 200: / Line 200: @@
 ===Series Constraint===
-A '''KeySet''' Constraint defines the allowed or restricted content by defining it in terms of the series key. A series key comprises of a Code Id per Dimension. Wild-carding can be used by specifying the Code Id as
+A '''KeySet''' Constraint defines the allowed or restricted content by defining it in terms of the series key. A series key comprises of a Code Id per Dimension. Wild carding can be used by specifying the Code Id as
   ‘*’

@@ Line 120: / Line 120: @@
 =Working with Retrieved Structures=
-As explained in the Retrieval sections above, there are a number of ways to obtain a structure from the connected Registry but what happens next is the same.
+As explained in the Retrieval sections above, there are several ways to obtain a structure from the connected Registry but what happens next is the same.
 ==Structure Format==

@@ Line 109: / Line 109: @@
 ===Delete Structure===
-To create a structure you need to be logged in to the connected Registry.
+To delete a structure, you need to be logged in to the connected Registry.
 After loading the structure you wish to delete, select the '''Delete Structure''' button.

@@ Line 76: / Line 76: @@
 ===Create Structure===
-To create a structure you need to be logged in to the connected Registry.
+To create a structure, you need to be logged in to the connected Registry.
-The Create Structure button opens up a window which enables you to select a structure type (please note that only Codelist, Category Schemes and Concepts schemes are functional in the current version of FXL).
+The Create Structure button opens window which enables you to select a structure type (please note that only Codelist, Category Schemes and Concepts schemes are functional in the current version of FXL).
-Next, select the Agency from the drop down list. Enter a Valid Structure ID (example CL_NEW), version and the name of the Structure as shown in  the example below:
+Next, select the Agency from the drop-down list. Enter a Valid Structure ID (example CL_NEW), version and the name of the Structure as shown in the example below:
@@ Line 97: / Line 97: @@
 ====Multi-Lingual Structures====
-Although, as show in the guidance image,  it is possible to create multi lingual structures using FXL, you will note that there is only one column for for a Descrptions and as a result you have to choose either '''fr''' or '''en''' (in this example I have used fr).
+Although, as show in the guidance image, it is possible to create multi lingual structures using FXL, you will note that there is only one column for Descriptions and as a result you have to choose either '''fr''' or '''en''' (in this example I have used fr).
-If you require a description in both languages, you can amend the spreadsheet as shown in this example. Using this method, you can add any number of languages. In this example, the language indicator is ru, to identify that the data is in Russian.
+If you require a description in both languages, you can amend the spreadsheet as shown in this example. Using this method, you can add any number of languages. In this example, the language indicator is '''ru''', to identify that the data is in Russian.
 [[File:FXL18.PNG|1000px]]

@@ Line 43: / Line 43: @@
 ==Structure Retrieval==
-There are 4 ways to retrieve structures from the Registry. Regardless of how a structure is retrieved, the retrieval of the structure will result in a new worksheet being opened.  Thus it is possible to have an Excel workbook with multiple worksheets, one for each retrieved structure.
+There are 4 ways to retrieve structures from the Registry. Regardless of how a structure is retrieved, the retrieval of the structure will result in a new worksheet being opened.  Thus, it is possible to have an Excel workbook with multiple worksheets, one for each retrieved structure.
 ===Browse Registry===
@@ Line 55: / Line 55: @@
 ===Lookup Structure===
-Lookup Structure provides a drop down menu of Registry content where the structures have been organised into folders depending on which structures reference them. This is a very useful mechanism for quickly finding the desired structure, as well as a useful tool to discover which structures make use of other structures.
+Lookup Structure provides a drop-down menu of Registry content where the structures have been organised into folders depending on which structures reference them. This is an extremely useful mechanism for quickly finding the desired structure, as well as a useful tool to discover which structures make use of other structures.
 It should be noted that whilst then ‘Browse Structures’ menu displays all Registry content, ‘Lookup Structure’ may be showing a subset, depending on the Registry content.