Hello,
I am using SYS07 to load territory data in QUO07. I understand that they have different dimension however, Anaplan accepted the reference but not showing the info. any hint how can I solve it?
SYS07
QUO07
Thanks.
Hi @Gharbali , The formula you applied in QUO07 accepts the reference, but it isn't displaying the information because of the top-level hierarchy present in the list used in the QUO07 module. Since there is no summary assigned to the Territory line item, no values are being returned for it in the target module.
To resolve this, you need to use a lookup on the Account line item from SYS07 in the target line item. Therefore, the final formula in QUO07 should be: 'SYS07 Territory>Accounts Details'.Territory[FIRSTNONBLANK: 'SYS07 Territory>Accounts Details'.Account] (Also as there can be multiple territories assigned to single account and hence it would be better to use the count of territories as a sum instead of firstnonblank value) Hope this helps.
@Gharbali
Is there another module with the same dimension where you can get the territory?
Hello @R_Goza,
My other modules with same dimension don't have territory to refer here in this module.
Geometry vibes
I haven’t encountered this situation before, but I find it very difficult to convert like this.
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…
