Average Sales per Transaction 
MultiProvider: 0RPM_MC08
This MultiProvider enables POS reporting on the average sales per transaction. All average sales per transaction queries delivered as part of the POS In-Memory Analytics content are based on the definition of this MultiProvider. This is why we recommend you use 0RPM_MC08 as your source for reporting.
This MultiProvider is constructed in the same way as the corresponding InfoCube 0RPM_VP08.
Data Modeling
Object Type | Name | Technical Name |
|---|---|---|
InfoObject | Change Run ID | 0CHNGID |
InfoObject | Document currency | 0DOC_CURRCY |
InfoObject | Material | 0MATERIAL |
InfoObject | Material group | 0MATL_GROUP |
InfoObject | Record type | 0RECORDTP |
InfoObject | Request ID | 0REQUID |
InfoObject | Business Transaction | 0RPA_BTY |
InfoObject | Qualifier for Article Identifier | 0RPA_IQU |
InfoObject | Item ID | 0RPA_ITI |
InfoObject | Credit/Debit Items Indicator | 0RPA_RDF |
InfoObject | Classification of Sales Item: Category | 0RPA_RIC |
InfoObject | Classification of Sales Item: Subcategory | 0RPA_RISC |
InfoObject | Sales Item Type | 0RPA_RTC |
InfoObject | Credit/Debit Transaction Indicator | 0RPA_TRD |
InfoObject | Transaction Type | 0RPA_TTC |
InfoObject | Retailstrid, Bussdaydate & TransIndx | 0RPM_ALLKEY |
InfoObject | Start Date | 0RPM_BTS1 |
InfoObject | Start Time Stamp (Time) | 0RPM_BTS2 |
InfoObject | Task Canceled | 0RPM_CANC |
InfoObject | Data Status | 0RPM_DAT |
InfoObject | Calendar Day | 0RPM_DAY |
InfoObject | Distributed Discount | 0RPM_DID |
InfoObject | Distributed Included Transaction Tax | 0RPM_DITXI |
InfoObject | Hour | 0RPM_HOR |
InfoObject | Calendar Month | 0RPM_MTH |
InfoObject | Normal Sales Value | 0RPM_NSA |
InfoObject | Discount Value | 0RPM_REA |
InfoObject | Tax Included | 0RPM_TXI |
InfoCube | Average Sales per Txn | 0RPM_VP08 |
InfoObject | Calendar Week | 0RPM_WEK |
InfoObject | Calendar Year | 0RPM_YER |
InfoObject | Retail location | 0RT_LOCATIO |