Skip to main content
A
AndreaF
April 22, 2022
Solved

Export Invalid intersections including validation messages

  • April 22, 2022
  • 5 replies
  • 0 views

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):


SC1.png

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?


SC2.png

 

 

Thank you

Best answer by SC8

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

Regards,

S

 

5 replies

S
SC8Answer
April 24, 2022

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

Regards,

S

 

A
AndreaFAuthor
April 24, 2022

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!

B
bilbrandon
April 25, 2022

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.

 


2022-04-25_16-04-07.png

S
SC8
April 25, 2022

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

B
bilbrandon
April 26, 2022

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.

B
BobM
February 17, 2026

I too use the Navigation Center > Data Validation > Intersection Errors report to get a list of errors to fix.  But, the big "however" is the Intersection Error column just says "Invalid member name." but does not identify what member is invalid.  Is there a report that will actually identify the invalid member?

Terms & ConditionsAccessibility statement