Export Invalid intersections including validation messages

[AndreaF]

Hi,

I'm aware that from the Validate workflow step, the full list of invalid intersections can be exported as in the picture below (right click > Export):

The Validation messages are not included in the export.

Is there a way to export the full list of validation messages together with the invalid intersections?

Thank you

[SC · Accepted solution]

This should be available in the 'Intersection Errors' application report (under Validation)

Regards,

S

[AndreaF]

Yep, from Dashboards, I had to select Application Reports, then filter on Data Validation and then select the Intersection Errors report. Thank you for your help!

[bilbrandon]

Thank you. This seems like it will be extremely helpful. One additional question - I'm only seeing one workflow profile in the drop-down list. It's the first one in the Workflow Profiles page (shown below) .If I rearrange the order, whichever one is first is the only one in the drop-down list. Any ideas? Thanks.

[SC]

Hi,

I had noticed that one too. But fortunately, the actual report runs based on the workflow selection. So, if you have selected 'Sales_Volume_GL' in the WF and then go to the report, it will still show Trial_Balance in the selection, but when you run the report, it displays the errors for 'Sales_Volume_GL'

Regards,

S

[bilbrandon]

Thanks, SC. Confusing, but not the end of the world. The other thing worth noting is that you need to run the transformation in the Workflow first or the report won't show the invalid members. I was hoping this report could be run proactively but that doesn't appear to be the case.