cancel
Showing results for 
Search instead for 
Did you mean: 

Opportunities Report - Inconsistency in involved parties information with left outer join DS

raul-gonzalezg
Explorer
0 Kudos

Hi,

I'm doing some testing with the opportunity functionality using the involved parties information. In this case I have an opportunity without the involved party role ”ZDIS-Distribuidor” and another that has 2 records with this involved party role (see next image).

As part of the monitoring and management, I need a report to visualize the information of the opportunities with its involved party “ZDIS-Distribuidor”, for this I created a "left outer join" data source having CODOPPU as anchor data source and CODOPPPTYB as secondary data source, with the opportunity field (DOC_UUID) as the join element.

After this, I created a report related this data source, but when I launch this report filtering “ZDIS-Distribuidor” party role, it only shows me the second opportunity with the corresponding records (see next image)

In this scenario due to the configuration of the data source I was also expecting to see the first opportunity with the “ZDIS-Distribuidor” party role and with part "#-Not assigned" (see next image)

but the result is not what was expected. I checked "BusinessAnalyticsGuide.pdf" file documentation of the latest release (May-2020) and aplied the corresponding steps to build the left outer join data source, but I can not get the expected behaivor.

I will aprecciate your help with this case.

Regards,

Raúl

chitkaraankit
Discoverer
0 Kudos

Hello Raul Gonzalez,

Did you manage to display the other opportunity with #(Not Assigned) in the report where custom party role is not ZDIS.

Actually I have a similar requirement wherein I need to show all opportunities and in 1 column I need to show the custom party id but after applying the filter, it hides all the opportunities which doesnt have this custom party role and #(Not assigned) values are not coming.

Appreciate if could advise if you manage to handle this scenario.

Thanks in advance.

Regards,

Ankit Chitkara

Accepted Solutions (0)

Answers (0)