Publication Table - Revision history

Vmurrell at 11:38, 3 November 2025

2025-11-03T11:38:05Z

Mnelson: /* Missing Values */

2023-11-08T16:22:48Z

‎Missing Values

Mnelson: /* Calculated Cell Missing Values */

2023-11-08T16:07:57Z

‎Calculated Cell Missing Values

Mnelson: /* Calculated Cell Observation Key */

2023-11-08T16:07:37Z

‎Calculated Cell Observation Key

Vmurrell at 15:08, 4 September 2023

2023-09-04T15:08:14Z

Mnelson: /* Dependent Dimension Variable */

2023-08-30T11:58:40Z

‎Dependent Dimension Variable

Mnelson: /* Calculated Observation Cells */

2023-01-31T08:47:36Z

‎Calculated Observation Cells

Mnelson: /* Calculated Cell Observation Key */

2023-01-24T09:48:18Z

‎Calculated Cell Observation Key

Mnelson: /* Calculated Observation Cells */

2023-01-24T09:46:12Z

‎Calculated Observation Cells

Mnelson: /* Calculated Observation Cells */

2023-01-24T09:24:58Z

‎Calculated Observation Cells

← Older revision		Revision as of 11:38, 3 November 2025
Line 1:		Line 1:
−	~~[[Category:Functions]]~~
	[[Category:How_To]]		[[Category:How_To]]

@@ Line 354: / Line 354: @@
 This would not output a value if A:UK:EMP, A:FR:EMP or A:DE:EMP have no corresponding Observation value for the time period the table is being built for.
-RFS version 11.12.0 and higher allow for assignment of default value(s) to missing components of the calculation.  The syntax uses the pipe '|' symbol, the semantic meaning is 'use this value | or this value if missing'.  An example of the pipe symbol being used in a calculation expression is shown below:
+RFS version 11.12.0 and higher allow for assignment of default value(s) to missing components of the calculation.
   :=[A:(UK|1+FR|1+DE|0):EMP]
@@ Line 360: / Line 367: @@
 This expression substitutes the UK for the value of 1 if there is no corresponding Observation for A:UK:EMP.  The Observation A:FR:EMP is substituted for 2 if missing, and A:DE:EMP is substituted for 0.  Therefore is all 3 Observations are missing, the final value for the expression = 1+1+0 = 2.
-It is possible to substitute the entire block if any part is missing by appending the double pipe '||' to the end of the expression.  The following example results in a zero value if any input Observation (UK, FR, DE) value is missing:
+It is also possible to substitute the entire block when using inline expressions. The following example results in a zero value if any input Observation (UK, FR, DE) value is missing:
   :=[A:(UK+FR+DE):EMP||0]
 === Calculated Cell Observation Key ===

← Older revision		Revision as of 16:07, 8 November 2023
Line 347:		Line 347:


−	=== ~~Calculated Cell~~ Missing Values ===	+	=== Missing Values ===
	If any input Observations are missing in the calculation, the final result of the calculation is an empty value. For example:		If any input Observations are missing in the calculation, the final result of the calculation is an empty value. For example:

← Older revision		Revision as of 16:07, 8 November 2023
Line 346:		Line 346:
	\|}		\|}

		+
		+	=== Calculated Cell Missing Values ===
		+	If any input Observations are missing in the calculation, the final result of the calculation is an empty value. For example:
		+
		+	:=[A:(UK+FR+DE):EMP]
		+
		+	This would not output a value if A:UK:EMP, A:FR:EMP or A:DE:EMP have no corresponding Observation value for the time period the table is being built for.
		+
		+	RFS version 11.12.0 and higher allow for assignment of default value(s) to missing components of the calculation. The syntax uses the pipe '\|' symbol, the semantic meaning is 'use this value \| or this value if missing'. An example of the pipe symbol being used in a calculation expression is shown below:
		+
		+	:=[A:(UK\|1+FR\|1+DE\|0):EMP]
		+
		+	This expression substitutes the UK for the value of 1 if there is no corresponding Observation for A:UK:EMP. The Observation A:FR:EMP is substituted for 2 if missing, and A:DE:EMP is substituted for 0. Therefore is all 3 Observations are missing, the final value for the expression = 1+1+0 = 2.
		+
		+	It is possible to substitute the entire block if any part is missing by appending the double pipe '\|\|' to the end of the expression. The following example results in a zero value if any input Observation (UK, FR, DE) value is missing:
		+
		+	:=[A:(UK+FR+DE):EMP\|\|0]
		+
		+	The above expression is equivalent to the following expression:
		+
		+	:=[A:UK:EMP\|\|0] + [A:FR:EMP\|\|0] + [A:DE:EMP\|\|0]

	=== Calculated Cell Observation Key ===		=== Calculated Cell Observation Key ===

← Older revision		Revision as of 15:08, 4 September 2023
Line 1:		Line 1:
	[[Category:Functions]]		[[Category:Functions]]
		+	[[Category:How_To]]

	@See [[Publication_Table_Web_Services\|Publication Table Web Services]]		@See [[Publication_Table_Web_Services\|Publication Table Web Services]]

← Older revision		Revision as of 11:58, 30 August 2023
Line 669:		Line 669:

	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_Service\|web service]] only requires the COUNTRY information, and it will complete the Observation key using the representation map lookup table.
		+
		+	'''Note''' it is possible to override the mapped value by passing in an explicit override to the web service. For example passing to the web service both COUNTRY=UK with CURRENCY=EUR will override the mapping behaviour for CURRENCY.

	== Component Values ==		== Component Values ==

@@ Line 317: / Line 317: @@
 * Any Observation Keys must appear within enclosing square brackets '[' and ']'
 * An Observation key may embed calculations on a single Dimension by using parenthesis '(' and ')' in the key part
 * The same rules for variable Dimensions and Time Period apply when resolving the Observation Keys used in the calculation
@@ Line 328: / Line 329: @@
 |-
 | :=[A:(UK+FR+DE):EMP] || Add the series A:UK:EMP + A:FR:EMP + A:DE:EMP
 |-
 | :=[A:UK:EMP]+[A:FR:EMP]+[A:DE:EMP]  || Add the series A:UK:EMP + A:FR:EMP + A:DE:EMP

@@ Line 359: / Line 359: @@
 |A:UK10:EMP:=[A:UK:EMP]+10  || A:UK10:EMP:2009 || The output key is explicitly assigned. The time period is added to the end of the key.
 |}
 == Percentage Of ==

@@ Line 340: / Line 340: @@
 |}
 Calculated Cells have implicit [[#Observation_Key|Observation Keys]] which are derived based on the inputs series in the calculation.  The [[#Observation_Key|Observation Key]] can be used to assign [[#Formatting_Cells|Formatting Rules]] in the same way as a 'standard key' can be used.   It is possible to assign an explicit key to the calculation, which will override the implicit key assigned.  The following table shows how the key assignment works.
@@ Line 347: / Line 349: @@
 ! Calculation !! Output Key || Explanation
 |-
-|:=[A:(UK+FR+DE):EMP] || A:#:EMP || The first and last dimension have a fixed value, the second dimension has a variable value and is replaced by '#'
+|:=[A:(UK+FR+DE):EMP] || A:#:EMP:2009 || The first and last dimension have a fixed value, the second dimension has a variable value and is replaced by '#'. The time period is added to the end of the key.
 |-
-|:=((100/[A:UK:EMP:(M+F):P-1])*[A:UK:EMP:(M+F)])-100  || A:UK:EMP:# || The first three dimensions have a fixed value, the last dimension has a variable value and is replaced by '#'
+|:=((100/[A:UK:EMP:(M+F):P-1])*[A:UK:EMP:(M+F)])-100  || A:UK:EMP:#:# || The first three dimensions have a fixed value, the last dimension has a variable value and is replaced by '#'. The time period is a variable as there are 2 time inputs to the calculation (P and P-1)
 |-
-|:=PCTOF([A:M:UK:P],[A:TOT:UK:P])  || A:#:UK || The first and last dimension have a fixed value, the second dimension has a variable value and is replaced by '#'
+|:=PCTOF([A:M:UK:P],[A:TOT:UK:P])  || A:#:UK:2009 || The first and last dimension have a fixed value, the second dimension has a variable value and is replaced by '#'. The time period is added to the end of the key.
 |-
-|:=[A:UK:EMP]+10  || A:UK:EMP || The input key is the same as the output key as none of the dimensions have a variable value
+|:=[A:UK:EMP]+10  || A:UK:EMP || The input key is the same as the output key as none of the dimensions have a variable value. The time period is added to the end of the key.
 |-
-|A:UK10:EMP:=[A:UK:EMP]+10  || A:UK10:EMP || The output key is explicitly assigned
+|A:UK10:EMP:=[A:UK:EMP]+10  || A:UK10:EMP:2009 || The output key is explicitly assigned. The time period is added to the end of the key.
 |}

@@ Line 308: / Line 308: @@
 == Calculated Observation Cells ==
-[[File:TableDefinition Calculations Variables.png|thumb|Publication Table with Calucated Cells and Variable Dimensions]]
+[[File:TableDefinition Calculations Variables.png|thumb|Publication Table with Calculated Cells and Variable Dimensions]]
 An Observation Cell may contain calculated values, which can consist of a mix of simple algebra (+, -, *, /) and a reference to one or more Observations which may come from multiple Dataflows.
@@ Line 315: / Line 315: @@
 * The Observation Key must start with :=
-* Any Observation Keys must appear within enclosing sequare brackets '[' and ']'
+* Any Observation Keys must appear within enclosing square brackets '[' and ']'
 * An Observation key may embed calculations on a single Dimension by using parenthesis '(' and ')' in the key part
-* The same rules for variable Dimensions and Time Period apply when resolving the Obseration Keys used in the calculation
+* The same rules for variable Dimensions and Time Period apply when resolving the Observation Keys used in the calculation
 Examples are shown in the table below
@@ Line 338: / Line 338: @@
 |-
 | :=[M:UK:EMP:M(P)] + [A:UK:EMP:A(P)] || Demonstrates the ability to calculate data where the period is converted from the base period
 |}