Reuse Views in SAP HANA Content for On-Shelf Availability
View Grouping: OSA Results of calculations
The reuse views in this grouping obtain information about the results of analytical and operative calculations in On-Shelf Availability.
Structure
This view grouping contains the following reuse views:
SAP OSA Analysis (
MON_ANA_VIEW
)The view obtains data from OSA analysis results (MON_ANA and ANA_CONF).
SAP OSA Monitoring (
STATUS_LOG_VIEW
)The view obtains data from OSA monitoring results (STATUS_LOG).
Measures and Attributes
Some important measures and attributes are:
SAP OSA Analysis (
MON_ANA_VIEW
)This view provides data about products with detected potential alert situations during the analyzed time period.
The view provides alert data consisting of start and end of the potential out-of- shelf situation, probability and threshold for an alert.
The view provides also the execution time of the analysis step. With the execution time, you can distinguish two analysis runs that have been performed in the same time period.
The view provides measures for the product alert such as lost transactions, lost sales quantities, and lost turnover.
SAP OSA Monitoring (
STATUS_LOG_VIEW
)The view provides data for operative out-of-shelf alerts such as the status of the alert, time of status change and the user who changed the status. The alert data contains the information about the resolution like refill, immediate refill, damaged goods, out-of-stock, or false alert.
Used Tables and Views
The views select data from the following main tables:
/OSA/ANA_CONF
(configuration of the analysis step)/OSA/MON_ANA
(result of the analysis step)/OSA/STATUS_LOG
(result of the monitoring step and statuses of the alert resolutions)