Excel Reporting Template
Revision as of 09:53, 28 February 2020 by Mnelson (talk | contribs) (Created page with "Category:Functions = Overview = A Data Reporting Template is a metadata driven Excel Form to enable Data Providers to easily report data. The form is Metadata Driven as t...")
Overview
A Data Reporting Template is a metadata driven Excel Form to enable Data Providers to easily report data. The form is Metadata Driven as the definition of each Worksheet takes into account:
- Dataset (Dataflow)
- Which Dimensions are placed in the Rows
- Which Dimensions are placed in the Columns
- Whether to output the headings and values as Ids or Names (e.g FREQ/A or Frequency/Annual)
- Whether to exclude fixed Dimension values, or place them in the Header
- How to report Attribute values such as Observation Confidentiality, Status or Pre-Break values
- Constraints are used to determine the universe of data, each form can contain a diffent universe of data depending on which Data Provider the form is generated for
