Hi Community. I have the following couple of models. In green you'll find the dimensions and in yellow the line items. I need based on the Rank from module 1, to pull the geo into module 2.
Thanks.
Sorry…Module 2 formula i suggested is wrong…For timebeing u can import data from module 1 to module 2…That should work without any issue
Formula would be Geo = Source Module.'Geo'[Lookup: Account Name, Lookup: Rank]
Hi @sansergi
Umang's formula is the one you need to apply. Make sure that Rank is list formatted line item, if not then create a list with (1-3) numbers in it. And use that in line item, then use lookup
Cheers!!
Thank you guys. So far, the first lookup is working (Lookup: Account Name) but when I try to look up for Rank, I get: "Format of mapping used for lookup doesn't match any dimension of the source".
Rank is a list formatted line item in both modules. Is there anything I am missing? Thanks a lot in advance.
@sansergi In order to apply formula what Umang suggested… First you need to create a Intermediate module whose dimensions are Rank, Account and line item will be Geo [Geo = Table1.Geo(lookup:Rank)]
From this intermediate module u can pull Geo to your Opportunities module based on logic suggested by Umang
Thanks V.Sai. But still no working. "Format of mapping used for lookup doesn't match any dimension of the source". Let me bring the full picture of what I have so far:
Thanks a lot.
XL3SetProperty to navigate
Hi, Where are the member properties for lists defined in Anaplan XL? In the training documentation there is an example showing a property such as “Birth Date”, which appears to be a list-item attribute. That suggests you can create custom list properties from the Anaplan list. However, when I connect through Anaplan XL, I…
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
