THIS_SOURCE_KEY

The THIS.SOURCE_KEY function returns the value of the mentioned source key row from the data series.

Syntax

DS.(SERIES).THIS.SOURCE_KEY

Example

Consider the below scenario where we have the Sales values for a Parent node. The objective is to allocate the Sales value of 2020 to all periods of the child node.

Parent

Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2019	8744503	8599938	8642337	8430046	8537787.6	8635150.9	8751803.7	8530118	8546371.7	8397872.3	8596191.1	8379559.9
2020	8188477	7959189	7470250	7688532	8221765	7188152	7341150	8265013	7718777	8299877	8550181	8544909
2021	1890876	1959373	2204492	1809924	1889838	1676175	1844642	2209590	1702085	1650029	2048406	1879161

To achieve this, the following formula should be written in the Child node:

DS._Sum_of_2020.GETROWVALUE(THIS.PARENT.SOURCE_KEY).GET(CPI)

To know about GETROWVALUE function, click here.

Result

Child

Year	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2019	8188477	7959189	7470250	7688532	8221765	7188152	7341150	8265013	7718777	8299877	8550181	8544909
2020	8188477	7959189	7470250	7688532	8221765	7188152	7341150	8265013	7718777	8299877	8550181	8544909
2021	8188477	7959189	7470250	7688532	8221765	7188152	7341150	8265013	7718777	8299877	8550181	8544909

Explanation

PARENT.SOURCE_KEY allows the node to look into the source key value of the parent as mentioned in the formula and get the sum of 2020 value for all periods.