About lauren.levine

Paul,   I tried your solution and got it to work! But, since we are using the anaplan generated number as the unique field instead some kind of description, we are going to be using a another list. When they update the non activity list, it will also update this 2D list where its name is the Activity and it has the property to link it to the list we are loading. Then we are using a line item for finditem that will take the activity and find the New list then a lookup to the property.    Thanks, Lauren ... View more

So we have 2 list, one Activity and the other is SKU. They both role up to Business Unit and are numbered list. When you create a new Activity you can either select an already existing SKU or say you want a SKU to be made in an external system. The Activity will have everything needed for the SKU in Properties except for SKU code, the SKU code is created outside of Anaplan. When the new SKU is imported into Anaplan, it needs to then be updated in the Activity automatically, but how do you find the SKU in the activity if you don't have the code. The Uniqie Property they do load is Anaplan generated Event number which is loaded in the SKU list. That would be the roperty needed to find the SKU for the Activity ... View more

This video gives you an idea of how to use alt hierarchies, such as for reporting. https://www.youtube.com/watch?v=AvbujFQoN8I&index=5&list=PLat1JW8TS3RlhZ2PF_vtoqeRBX7Jcy6JF ... View more

This may also be helpful. https://www.youtube.com/watch?v=xLXbZeyqmko&list=PLat1JW8TS3RlhZ2PF_vtoqeRBX7Jcy6JF&index=4 ... View more

If you want to watch a video on how numbered lists can be created and uses, go to https://www.youtube.com/watch?v=PXun8oLG5Ac&list=PLat1JW8TS3RlhZ2PF_vtoqeRBX7Jcy6JF&index=3 ... View more