Difference between revisions of "FusionXL Create Dataset"

From FMR Knowledge Base
Jump to navigation Jump to search
(Dataflow)
(Fix dimension and series attribute values)
Line 19: Line 19:
 
[[File:FXL createdataset dataflow.JPG|700px]]
 
[[File:FXL createdataset dataflow.JPG|700px]]
  
=Fix dimension and series attribute values=
+
=Fixing values and choosing which non-mandatory attributes to include=
Choose '''Mandatory only''' or '''Mandatory and selected optional''' to set fixed values for dimension and series attributes.
+
* Fix values for dimensions
[[File:FXL createdataset fixed.JPG|700px]]
+
* Fix values for coded and uncode series attributes
 +
* Set default values for observation attributes - these take effect for all observations for which a specific value has not been set
 +
* Choose which non-mandatory attributes to include
 +
====Fixed coded and uncoded values====
 +
[[File:FXL createdataset fixed.JPG|600px]]

Revision as of 08:48, 4 January 2022

FXL createdataset overview.JPG

The FusonXL Create Data Set function assists in reporting data to a Fusion Registry 10 or 11 statistical data warehouse by creating a spreadsheet form for the specific dataflow.

The reporting process is simplified by:

  • Defining the reporting period and frequency which automatically generates a template with the correct observation time periods
  • Optionally setting fixed values for Dimensions and Series Attributes where the value is the same for all series being reported
  • Optionally setting default values for Observation Attributes which apply to all observations unless overridden for specific observations
  • Choosing which non-mandatory attributes to report

From the FusionXL ribbon bar

  1. Log in as a user with Data Provider privileges
  2. Choose Data Author under the Connection group
  3. Choose Create Data Set

FXL createdataset ribbon.JPG

Dataflow

Choose the Dataflow to report data for, and set the basic frequency and reporting period.

FXL createdataset dataflow.JPG

Fixing values and choosing which non-mandatory attributes to include

  • Fix values for dimensions
  • Fix values for coded and uncode series attributes
  • Set default values for observation attributes - these take effect for all observations for which a specific value has not been set
  • Choose which non-mandatory attributes to include

Fixed coded and uncoded values

FXL createdataset fixed.JPG