bw spex data-load monitor overview - orbis system solutions
TRANSCRIPT
![Page 1: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/1.jpg)
Monitor BW/BI dataloadswithout compromise
![Page 2: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/2.jpg)
Introduction:Dataload errors
The error most feared by normal users of a BW system:
This is a simplistic view on reality, and this single cause of error is 100% covered by advanced error detecting algorithms*. In SAP this type of error is virtually impossible to occur undetected.
* Cyclic Redundancy Check, Parity, Block Parity and Checksum
Data from source system is mangled in some way so that figures are not correct
anymore in BW.
![Page 3: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/3.jpg)
Introduction: Dataload errors
Real errors regularly experienced in a practical BW system:Dataloads that where expected did not run at all. Scheduling was not correct.Dataloads that where expected did run multiple times.Double scheduling.
Both errors can not be detected by standard SAP monitor tools because they do not generate a red traffic-light.
* Cyclic Redundancy Check, Parity, Block Parity and Checksum
![Page 4: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/4.jpg)
Introduction: Dataload errors
Dataloads from R/3 to BI are vulnerable to several types of errors
TechnicalProceduralTiming/PerformanceScaleCustom
Standard SAP BI has some support for technical errors, limitedsupport for procedural errors and no support for timing, scale and customer related errors
![Page 5: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/5.jpg)
Technical errors
Technical errors occur in the network, server, database or the technical representation of the data.
Source systemRFC-connectionPSATechnical flagQuality flagActivationDatamart
Example:Illegal characters in the dataFirewall or network problemsALEREMOTE accounts
![Page 6: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/6.jpg)
Procedural errors
Procedural errors occur during the processing of the data. Theseinclude errors that occur in process chains.
OverlappingCompressionAggregationProcess Chains (metachain)
ExampleTwo dataloads with the same selectionLock on index tables (Starvation of processes)
![Page 7: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/7.jpg)
Timing and performance errors
Timing and performance errors occur due to mistakes in scheduling and in cross-linked dependencies between dataloads.
Time framePlanning versus actualDate or calendar planningEvent triggered
ExampleAfter a transport a process-chain is not scheduled anymoreDue to update in R/3 a datasource replication was neededCalendars are not maintained
![Page 8: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/8.jpg)
Scale and custom errors
Scale errors occur because dataloads depend on processes in other systems
Multiple BW systemsExample
Companies with HQ and daughter-plants.
Customer errors occur because a condition arises that the customer considers an error (but is not generally an error)
Customer specific load processesExample
Flat-file data was not updated, so old version was loaded againReporting from archives may need specific quality checks
![Page 9: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/9.jpg)
Risks
Depends on usage of reports:StockholdersBoard of directorsExecutiveManagementChief of operation…
The risks and costs of unreliable reporting can be hugeErrors are simply not allowed
![Page 10: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/10.jpg)
BWSPEX Monitor
Fully automatic detection of all known dataload errorsThis includes all error types mentioned before
Fully web-enabled technical, statistical and business grade reporting
For end-users, technical staff and managementNavigation through meta-chain structures
Provides insight in complex process chainsSource code is protected and therefore SOX-compliant
![Page 11: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/11.jpg)
Screenshots
![Page 12: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/12.jpg)
Screenshots
![Page 13: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/13.jpg)
Screenshots
![Page 14: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/14.jpg)
Screenshots
![Page 15: BW Spex Data-load Monitor overview - Orbis system solutions](https://reader030.vdocuments.us/reader030/viewer/2022021209/620639368c2f7b1730059c13/html5/thumbnails/15.jpg)
Screenshots