COLLECT() function issue

Jsdeloria21
Frequent Contributor

COLLECT() function issue

Hi Community,

 

Please see attachment for the details of the issue. Any feedback is appreciated

 

Regards,

2 ACCEPTED SOLUTIONS

Accepted Solutions
AntonMineev
Certified Master Anaplanner

Re: COLLECT() function issue

Hi @Jsdeloria21!

You don't have subset list "ss COS Recovery" in your target module.You need COLLECT() amount with them and after have mapping to your new list (or have top-level if you want have total summary of "ss COS Recovery").

View solution in original post

ChrisHeathcote
Community Boss

Re: COLLECT() function issue

@Jsdeloria21 

You should already have a systems module in which you are able to define properties of the list. 

Here would be the best place to set up the mapping into the line item subset. 

To make it a little easier when you add the list formatted line item to the system module change the applies to in the blueprint to the subset. When you enter the grid view to create the mapping only those list item that are part of the subset will be available to update. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

5 REPLIES 5
AntonMineev
Certified Master Anaplanner

Re: COLLECT() function issue

Hi @Jsdeloria21!

You don't have subset list "ss COS Recovery" in your target module.You need COLLECT() amount with them and after have mapping to your new list (or have top-level if you want have total summary of "ss COS Recovery").

View solution in original post

KirillKuznetsov
Certified Master Anaplanner

Re: COLLECT() function issue

@Jsdeloria21Hi

 

As the error says, one of the dimentions in the source does not have a top level element in "ss COS Recovery".

KirillKuznetsov_0-1632816945439.png

 

This is required because you don't have it in the target module. And this means Target will try automatically take data from the top level element of this list.

 

Jsdeloria21
Frequent Contributor

Re: COLLECT() function issue

Hi,

 

ss COS Recovery List is a subset from the list of GL codes that we have. see below.DO I need to put ALL GL on the configure tab? ALso appreciate the time for your feedback

 

Jsdeloria21_0-1632818060023.png

Regards,

ChrisHeathcote
Community Boss

Re: COLLECT() function issue

@Jsdeloria21 

You should already have a systems module in which you are able to define properties of the list. 

Here would be the best place to set up the mapping into the line item subset. 

To make it a little easier when you add the list formatted line item to the system module change the applies to in the blueprint to the subset. When you enter the grid view to create the mapping only those list item that are part of the subset will be available to update. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA

View solution in original post

ChrisHeathcote
Community Boss

Re: COLLECT() function issue

The error indicates that you are not defining how to SUM the ss COS Recovery list. 

As there is no mapping Anaplan is attempting to take the top level value and as it does not have one you are seeing this error. 

 

Therefore, you need to define how the two line item subset map into each other.

 

COLLECT() is not the correct function here. Set up a module only dimensioned by ss COS Recovery. Add a line item formatted as the target line item subset. Define how the mapping and use SUM to bridge the gap between them. 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA