Reporting Attributes via Reporting Templates

From Fusion Registry Wiki
Revision as of 04:42, 28 April 2021 by Vmurrell (talk | contribs) (Convert the data)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Overview

In the current version of the Registry, only Dimensions can be included in a Reporting Template (completion worksheet) however it is possible to use Step 4 of the Reporting Template to identify attributes in such a way that when the Template is converted into an XML file, the attributes are included.

In this example I am using a Data Structure which has an Attribute relating to the confidentially status of the reported data. This article assumes that you have a basic understandin of how to create a Template using the GUI as explained in this article - How to create a Reporting Template.

You can read more about Reporting Template Data Formats here.

Creating the Reporting Template

The template wizard is created in the usual way for the first 3 steps as shown in the example thumbnials aside.

Step 1
Step 2
Step 3

Step 2 allow the insertion of an instruction worksheet which will appear (in a separate worksheet in the generated Excel workbook when the Reporting Template is generated). You can use this to provide instructions for completion.

Attribute Placement Step 4

In this example, I have selected Use Colour to represent and selected 3 items to include as shown in the example below.

Step 4

Reporting Template Excel Workbook

The Reporting Template is save and generated in the usual way. When the workbook is opened, you will seen 3 separate worksheets as well as the colour coding legend that was added in step 4.


Generated workbook


Note the default colour appears in the Obs Value cells. A completed worksheet might look like this.


Completed worksheet

Convert the data

The next step is to convert the spreadsheet into a XML file via either the Load from file option or the quick convert option as shown aside.

Convert the Excel spreadsheet

If you open the XML file and view using Pretty Print (I am using XMLSpy) you will see that the colour coding has taken affect and the correct codes are included against the Attribute CONF-STATUS.


XML Data