Plasma Data Objects
Structure And Calculations
detailed data objects structure and calculations: Plasma Data Objects Structure [Sharepoint]
KPIs provided by Bain (for Plasma_KPI DM): Plasma_KPIs [Sharepoint]
exchange Data Loads: Plasma Exchange Data Loads [Sharepoint]
- overrides the original items sourced from a DSvalidation rules: Plasma_Validations [Sharepoint]
Customer Partition
Transactions:
Plasma_TX (DS)
Plasma_Transactions (DM)
Plasma_Output_Transactions (DM)
Quotes:
Plasma_Quotes (DS)
Plasma_Quotes (DM)
Plasma_Output_Quotes (DM)
both:
Plasma_KPI (DM)
- data provided by Bain
Harvester Partition
Transactions:
Plasma_Transactions_Harvester (DS)
Plasma_Transactions_Harvester (DM)
- consists of fields from Plasma_Transactions_Harvester (DS), Plasma_Entities (DS) and Plasma_Taxonomy (DS)
Quotes:
Plasma_Quotes_Harvester (DS)
Plasma_Quotes_Harvester (DM)
- consists of fields from Plasma_Quotes_Harvester (DS), Plasma_Entities (DS) and Plasma_Taxonomy (DS)
both:
Plasma_Entities (DS)
Plasma_Taxonomy (DS)
Plasma_Currencies (DS)
Data Loads Engagement
DL Label | DL Type | Formula | Feeder (if any) | Config tables | Source | Target |
---|---|---|---|---|---|---|
Plasma_Transactions | Calculation | Plasma_Data_Extractor | Plasma_Data_Extractor_Feeder | Plasma_Config, | Customer transaction data | DMDS.Plasma_TX |
Plasma_Transactions_PreviousPrice | Calculation | Plasma_Transactions_PreviousPrice |
|
| DMDS.Plasma_TX | DMDS.Plasma_TX |
Plasma_Transactions_Exchange | Calculation | Plasma_Transactions_Exchange |
|
| DMDS.Plasma_TX, | DM.Plasma_Transactions |
Plasma_Output_Creation | Calculation | Plasma_Transactions_Creation |
| Plasma_Config | DM.Plasma_Transactions | DM.Plasma_Output_Transactions |
Plasma_Output_Enrichment | Calculation | Plasma_Transactions_Enrichment |
|
| DM.Plasma_Output_Transactions, | DM.Plasma_Output_Transactions |
Plasma Quotes Extractor | Calculation | Plasma_Quotes_Extractor | Plasma_Quotes_Extractor_Feeder | Plasma_Quotes_Extractor_Mapping | Customer quote data | DMDS.Plasma_Quotes |
Plasma Quotes Enrichment | Calculation | Plasma_Data_Extractor | Plasma_Data_Extractor_Feeder | Plasma_Config, | DMDS.Plasma_Quotes, | DMDS.Plasma_Quotes |
Plasma Quotes Exchange | Calculation | Plasma_Quotes_Exchange |
|
| DMDS.Plasma_Quotes, | DM.Plasma_Quotes |
Plasma Output Quotes Load | Calculation | Plasma_Quotes |
| Plasma_Config | DM.Plasma_Quotes | DM.Plasma_Output_Quotes |
Calculation Conditions
Plasma_Output_Transactions DM
(sourced by Plasma_Transactions_Creation DL)
Total_Sales_HC_Annual, Total_Sales_HC_TTM_Region, Total_Accounts_TTM, Total_Accounts_TTM_Region, Total_Products_TTM, Total_Products_TTM_Region:
- to have the value of these elements in Plasma_Output_Transactions DM, there must be data for last 12 months, otherwise, it will be null value. (E.g: UniqueId: 2020-M06 --> must have data in 2019, if you only have data from 2020-M01 --> M06, we don't show value for these elements.)