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

YearJanFebMarAprMayJunJulAugSepOctNovDec

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

YearJanFebMarAprMayJunJulAugSepOctNovDec

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.

Last updated