So, DVAlert is failing, the message is something like this:
"IdBatch: 658 The
numbers of records between tmpfactPMSBOB and incfactPMSBOB not match for cube
PMS BOB"
The problem is most likely that one of more of the dimensions has duplicate All Elements.
Oh no!
Finding that will be super tedious! If only there was a utility for determining WHICH dimension has the duplicates...
No worries, there is a utility, it is called DVDimChecker.exe. If you don't have a copy in the \Datavision\Tools\ folder or the \Datavision\Programs\Util\ folder on the local computer, a copy can be found here:
\\thepolice\support\_Latest Interface\DVDimChecker\
Run the utility, it will automatically connect to the current server, but if you need to point to another server, like at Alys Beach, or if you need to add an instance, change the server name. Then click the button to the right of the Database drop down. This will populate the drop down, allowing you to select the appropriate database. At this point, click the Run button. A report will be generated and when it finishes, you may click the Notepad button to have the report automatically opened with Notepad for review.
Each dimension table will be scanned, and problems notated. If you jump to the very end of the report, there is a recap section that will list the problem dimensions found.
Are there any caveats?
Why yes, there are two.
First, running the report a second time, will append the new report to the end of the old report. This is a feature. If you don't want both when you are running it a second time to check if you've resolved any problems, then you must clear the old file by either deleting it manually or removing the contents and saving.
Second, the utility may show you dimension back up tables. So if there is a table dimPMSTransactions_Bak_20180122, you see the problems in it as well. Just be aware that the problem you are looking at may be in a backup table and not the actual table.