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
This should be available in the 'Intersection Errors' application report (under Validation)
Regards,
S
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?
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.
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
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.
This should be available in the 'Intersection Errors' application report (under Validation)
Regards,
S
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!
