Lookup () equivalent to return a property

Question

From Dimension B, How can I look up a property from Dimension A based on a Dimension A property which is in Dimension B? MS-Copilot told me to use Lookup (), which works in Anaplan but I cannot find Lookup in Pigment functions.  Thank you.

Stef · Accepted Answer

Hi ​@Kevin Leadbeater,This is actually super simple in Pigment, but because its so simple its sometimes overlooked! :)You can do DimensionB.PropertyfromB.PropertyA , you kan keep chaining these as far as you want with “.” dots in the middle.ExampleDimension A CityName - Country (property)Paris - FranceDimension B CountryName - RegionFrance- EuropeIf you want to have the Region of Paris, you simply do City.Country.Region

Kevin Leadbeater · Answer

I forgot the dimension chaining from earlier course. Simple is better, thank you.

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded