3. If data exists, use the rollback function to delete the dates in question. This step is only needed if the report has some data. This is done to avoid duplicate values.
a. Open Online Monitoring and go to Tools > Reporting Settings.
b. In the DTE Reporting view, select the date/time and click Roll Back.
4. To recollect the data, run the Data Transformation Engine (DTE) job for the days:
a. Run Command Prompt as an administrator.
b. Locate the BCM_DTE.exe file. This should be under the Reporting database installation \contents\bin directory, for example C:\Sinch\Contact Pro\Reporting Database Server\contents\bin.
c. Change directory to the above path and enter the following in the command line: "BCM_DTE.exe [VU_Name] "YYYY-MM-DD HH:MM:SS" "YYYY-MM-DD HH:MM:SS".
For example: BCM_DTE.exe ACME_Reporting "2013-10-30 22:00:00" "2013-10-31 13:00:00”
The time period doesn’t have to be full hours. You can use a period of 15 minutes.
NOTE: The start and end time parameters are always UTC time, so when you are recollecting the data, you need to pay close attention and convert your local time to UTC or else you could be risking missing some data.
5. If you use Micorsoft Reporting Services reports, run database full process either by:
• Executing the "XXX: Reporting OLAP database management" found in Microsoft SQL Server Management Studio -> SQL Server Agent -> Jobs -> "XXX: Reporting OLAP database management". This will run the Process Full.
• Manually running the Process Full directly against the OLAP database:
a. Connect to the Analysis Services Engine using Microsoft SQL Management Studio.
b. Right-click on the OLAP database and then choose Process.
c. Make sure the process type is set as Process Full and then click OK.