Publication Table - Revision history

Vmurrell: /* Dependent Dimension Variable */

2023-07-18T12:14:25Z

‎Dependent Dimension Variable

2023-07-18T11:56:15Z

‎Overview

2023-07-18T11:54:32Z

‎Overview

2023-07-18T11:53:44Z

2023-07-18T11:52:14Z

‎Anchor Single Row [anchor]

2023-07-18T11:34:32Z

‎Time Variables

2023-07-18T11:29:28Z

‎Metadata vs Materialised

2023-07-18T11:20:25Z

2022-09-07T15:12:58Z

2022-09-07T15:06:27Z

@@ Line 668: / Line 668: @@
 |}
-When the Publication Table is materialised the [[Publication_Table_Web_Service|web service]] only requires the COUNTRY information, and it will complete the Observation key using the representation map lookup table.
+When the Publication Table is materialised the [[Publication_Table_Web_Services|web service]] only requires the COUNTRY information, and it will complete the Observation key using the representation map lookup table.
 == Component Values  ==

@@ Line 21: / Line 21: @@
 [[#Time Variables|Time arithmetic and frequency conversion]] is supported, enabling a single table to pull data from different time periods and frequencies which are all derived from the base period on which the table is built.
-Publication Tables support [[#Calculated Observation Cells|calculations]], where each calculation can take input from one or more Observations over one or more [[Dataflow_-_Structural_Metadata_Management|Dataflows]].
+Publication Tables support [[#Calculated Observation Cells|calculations]], where each calculation can take input from one or more Observations over one or more Dataflows.
 Variable values also play a big role in Publication Tables, and includes standard variable placeholders – as well as advanced [[#Conditional Variables|conditional variables]], whose list of variable values change based on the value of another Dimension for which the table is built.

@@ Line 15: / Line 15: @@
 A Publication Table is a curated table of data, where the values in the table rows, columns and table body cells can be individually specified.  This enables a single table to pull data from multiple sources and piece the data together in a way which is not possible when dealing with standard cubes of data, whose table model is typically based on a Pivot model, with columns and rows built around the Dimension values to which the column or row is assigned.  A Publication Table breaks out of this restrictive model by allowing cells of data to reference observations which do not need to share any relationship, in terms of dimensionality or even data source, with adjacent cells,.
-Data in a Publication Table may be sourced from a single [[Dataflow_-_Structural_Metadata_Management|Dataflow]] or it may be sourced from multiple Dataflows enabling cross comparison of data.
+Data in a Publication Table may be sourced from a single Dataflow or it may be sourced from multiple Dataflows enabling cross comparison of data.
 Publication Tables can be static (every cell is a defined Observation) or dynamic, where a cell includes [[#Variable Dimension Members|variables Dimensions]] in the [[#Observation Key|Observation Key]], which can be provided at [[#Metadata vs Materialised|table build time]].

@@ Line 211: / Line 211: @@
    Retired             3             5
-This rule can be coupled with [[Publication_Table#Formatting_Missing_Observations|formatting for missing observations]], then the table could be enhanced to look something like this
+This rule can be coupled with [[Publication_Tables#Formatting_Missing_Observations|formatting for missing observations]], then the table could be enhanced to look something like this
                        Male          Female

@@ Line 775: / Line 775: @@
 '''<u>Compound expressions</u>'''<br/>
-From Fusion Registry v11.5.1 and later it is possible to cast a period more the once in the same expression, for example
+From FMR V11.5.0 and later it is possible to cast a period more the once in the same expression, for example
   Q(FA(P-1))-1

← Older revision	Revision as of 11:53, 18 July 2023
(No difference)

@@ Line 27: / Line 27: @@
 == Metadata vs Materialised ==
-A Publication Table is stored in Fusion Registry the same way any other piece of structural metadata is stored.  In this way it has an owner (Agency), and identity (ID) and a version.  The change history is tracked using the same services, and the table definition can be [[Publication_Table_Web_Services|queried]] using the same SDMX web services for Structural Metadata.
+A Publication Table is stored in FMR the same way any other piece of structural metadata is stored.  In this way it has an owner (Agency), and identity (ID) and a version.  The change history is tracked using the same services, and the table definition can be [[Publication_Table_Web_Services|queried]] using the same SDMX web services for Structural Metadata.
 The Publication Table metadata contains information about which Dataflows are used by the Table, which additional variables are being imported, and a definition of the table structure, and which Observations to import by referencing them by their unique [[#Observation Key|Observation Key]].

← Older revision		Revision as of 15:12, 7 September 2022
Line 1:		Line 1:
	[[Category:How_To_V11]]		[[Category:How_To_V11]]

−	Please refer to ~~this wiki:~~ [https://wiki.sdmxcloud.org/Publication_Table~~\| Publication Tables~~]. In the fullness of time information will be available on the FMR wiki.	+	Please refer to the [https://wiki.sdmxcloud.org/Publication_Table] article in this wik. In the fullness of time information will be available on the FMR wiki.

← Older revision		Revision as of 15:06, 7 September 2022
Line 1:		Line 1:
−	[[Category:~~How to~~]]	+	[[Category:How_To_V11]]

	Please refer to this wiki: [https://wiki.sdmxcloud.org/Publication_Table\| Publication Tables]. In the fullness of time information will be available on the FMR wiki.		Please refer to this wiki: [https://wiki.sdmxcloud.org/Publication_Table\| Publication Tables]. In the fullness of time information will be available on the FMR wiki.