Transaction Count and Sales

This InfoArea includes Objects, which are relevant for the transaction count and sales metrics.

With the transaction count and sales, you can count the number of distinct transactions in which a transaction count item appears.

Example Example

The transaction count item is the article "soup": if ten people buy soup at a given store in one week and each of them buys exactly three cans, the unit sales for the week is thirty, but the transaction count is ten, reflecting the fact that the article "soup" was purchased in the course of 10 buying transactions.

End of the example.

Process

The transaction count and sales is based on the following BI dataflow.

This graphic is explained in the accompanying text.

The POS data coming from the POS Inbound Processing Engine (PIPE) is extracted using the 0RT_PA_TRAN_CONTROL DataSource. Then the POS data is available through the 0RT_PA_TRAN_CONTROL InfoSource for BI analysis.The transaction count and sales analysis scenario gets the POS data from the 0RT_PA_TRAN_CONTROL InfoSource and performs a first transformation to determine what individual materials are involved in regular sale and promotion sale transactions.Then a second transformation is applied and the transaction count for each material is aggregated per posting date and location into the 0RPA_C06 InfoCube.Finally that InfoCube being part of the MultiProvider 0RPA_MC01, the Query0RPA_MC01_Q0004 can be run against the MultiProvider to get the transaction count for regular and promotion sales along with the corresponding sales figures.