Unable to retrieve base currency value based on the node data type property value

Summary:

In Department dimension UDA property, we need to concatenate Entity value with its corresponding Base Currency value from Entity dimension. For this we have created one custom node data type property and named as Entity, which is a user entry filed. In UDA we are planning to add derivation saying "node.properties.Entity.name.concat(",",node.properties.Entity.properties.basecurrency)". So that once user enters Entity property value then UDA will be auto populated.

Example: If user enter Entity value as E1234 and its corresponding base currency value is 'USD' in Entity dimension then UDA should be derive values as "1234,USD".