Collect() function results zero values - why?

Dominika_Dudzinska

Hello,

I used collect() function to take data from the source module.

I created LISS from the source module and then used as dimension in the target module.

The dimension are the same in the both module, unfortunately I see zero values after using collect().

Can you help me understand why?

Thank you.

Best regards,
Dominika

Accepted answers

All comments

anand.shekhawat

@Dominika_Dudzinska

Is it possible to please share some snips of your build

~Anand

KirillKuznetsov

Most probably you are missing some dimensions from your source in your target model.

The target must have the source dimensions OR all missing dimensions have to have Total list element and summary of the line item in the source have to be turned on.

Bruce986

Likewise, we may want to collect() some things from matched paths when there The other aggregation functions can produce similar results when run on 0 rows. a grouping key is NOT the same as having a grouping key of null values).

ePayitonline

Dominika_Dudzinska

Hello,

OK, I already understood where the problem is.

I had LISS in the source model and corresponding line items in the target model to map to.

The mapping is not possible, because the dimension is different, so it was giving 0.

Thank you all for your help.

Best regards,
Dominika

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…