Client UDID Corrections in GDW (Validation 1 editing)
On occassion there are times when a clients UDID's are either missing or incorrectly listed in client reporting.
There is a facility available to change the UDID in the warehouse so it will return the correct/expected value in reporting from the CTM Data Hub (and reports).
A report can be obtained from the GDM team, the changes applied to the report and then returned to the GDM team who will arrange for the update.
Below are the steps required to request and update the report.
Request the file for the dk you’d like to edit and the date parameters,
Change the information in the UDID’s that you need to amend
Always remember to highlight the line you have edited and put a Y in the edited column-
Do not edit the fields highlighted in blue-
Save and rename the file so you remove all the underscores and at the end of the file you put your intials and the date you have edited the file,
Once you have made your changes send the file to MIS we will then save the file to the BI Editing location- \\Filebwh01\BI Editing
This will then sync within 24 hours and will update the changes you have made