It is also possible to extract data directly from the Qlik dashboard. It is to be noted that the fields are named differently because of the additional "transformation layer" of the dashboard.
Also, when extracting from the dashboard, there will not be any information of potential deselections that could happen in the WebApp. For this reason, it is advised to use the WebApp extraction whenever possible.
Indeed, in this extract you will find the "recalculate" fields described in a specific section below. You are able to use either these columns with deselections applied or the initial ones afterwards.
General sources information :
Main SAP BW object (used by default if no other source specified) : MVSDSO45/BW_QRY_MVSDSO45_SD0001
SalesForce mentions the iCare system containing SpP data.
For all the "dimension type" data (region, segment, etc.), we only keep the most recent value found if not specified.
target_cpc : CPC code for which the recommendation is being done.
source : scope of CPCs is coming from SAP BW. The CPC code is built like this : material_group_code & '_' & sold_to_code. Please refer to these fields below for exact source field.
product_family : Family of the CPC.
source : SalesForce => HPAM__c field from Product2 object.
material_group : Part of the product hierarchy, lower level of granularity used in the AI engine.
source : SAP BW => [C_PROD]
material_group_code : Code of the material_group used in the target_cpc creation.
source : SAP BW => [C_PROD].[2C_PROD]
soldto_party : Customer sold to name.
source : SAP BW field [C_SOLDID]
soldto_party_code : Code of the soldto_party used in the target_cpc creation.
source : SAP BW => [C_SOLDID].[8C_SOLDID]
product_h4_sf : The H4 is a product hierarchy level specific to SpP.
source : SalesForce => Hierarchy_4_Name__c field from Product2 object.
SpP_adjusted_region : Region of the CPC. We have a dedicated mapping on the back-end to transform SAP region into the ones SpP is familiar with.
source : SAP BW => [C_SOLDID].[1C_MZONE]. Mapped in DataIku afterwards.
popular_end_use_cat : End use related to the CPC.
source : SalesForce => End_Use__c field from End_Use__c object.
market_cluster : Market cluster of the CPC.
source : SalesForce => Market_Cluster__c field from End_Use_Maping__mdt object.
customer_segment : Customer segment related to the soldto.
source : SAP BW => specifically comes from the MVCOPA01/QVSBS_BW_QRY_MVCOPA01_0004 query. field is : [C_CUSTSAL__0CUST_GRP2]
cpc_revenue : Based on the sum of last 12 month sales of the CPC. Sales used can be either gross or net depending on the choice made for each specific campaign. The gross sales are used by default.
source : SAP BW => [Measures].[AKLI1L2RFKV5X0JSWTP1L9M1T] for net sales, [Measures].[AKLI1L2RFKV5X0JSWTOZRO0RL] for gross sales.
cpc_volume : Sum of the volume of sales for the CPC during the last 12 monthes.
source : SAP BW => [Measures].[BW_RKF_MVSDSO45_0015]
original_price_euro_kg : Calculated original price of the CPC.
The calculation is based on the sales using following rules. Price used is, as the revenue, either gross or net depending on the choice made for each specific campaign.
source : SAP BW => [Measures].[AKLI1L2RFKV5X0JSWTP1L9M1T] for net sales, [Measures].[AKLI1L2RFKV5X0JSWTOZRO0RL] for gross sales.
post_overlay_recommended_price : Principal recommended price to use. It is the result of the engine that is displayed in the WebApp.
source : This is a result of the AI engine calculations.
post_overlay_relative_price_diff_pct : Relative price change due to the recommended price. It is directly calculated from original_price_euro_kg and post_overlay_recommended_price
source : This is a result of the AI engine calculations.
post_overlay_recommended_price_local : post_overlay_recommended_price displayed in local_unit and local_ccy (you will find more informations in the "price conversions field" section)
source : This is a result of the AI engine calculations. Uses the ccy_rate field to exchange rates.
These columns are only filled if a deselection has been made on the WebApp for the target CPC.
recalculated_recommended_price : Contains the new recommended price based on the last comparable set after deselection. You can chose to use either this field or post_overlay_recommended_price depending on the need.
source : This is a result of a WebApp deselection.
recalculated_relative_price_diff_pct : Contains the new relative price diff based on the last comparable set after deselection. You can chose to use either this field or post_overlay_relative_price_diff_pct depending on the need.
source : This is a result of a WebApp deselection.
recalculated_recommended_price_local : Contains the new relative price diff based on the last comparable set after deselection. You can chose to use either this field or post_overlay_relative_price_diff_pct depending on the need.
source : This is a result of a WebApp deselection.
ccy_rate : Exhange rate used to convert our recommendation from EUR to other currencies. Rates are updated monthly and we use the most recent one available.
source : connection : BigQuery_predict-credit-mgt-v2, table : currency_data and dataset : raw_data
local_unit : Local unit of the CPC coming from its most recent quote. Can be left empty if we did not find an active quote for the CPC.
source : SalesForce => Unit_of_Measurement__c field from Opportunity_Bracket__c object
local_ccy : Local currency of the CPC coming from its most recent quote. Can be left empty if we did not find an active quote for the CPC.
source : CurrencyIsoCode field from Opportunity_Bracket__c object
url : Generated link to access the WebApp directly on this CPC.
source : This is generated automatically by the WebApp.