eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: BIM_EDW_EVENT_COST_V

Product:	BIM - Marketing Intelligence
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT AAM.ACT_METRIC_USED_BY_ID EVENT_OFFER_ID
, AAM.TRANSACTION_CURRENCY_CODE TRANSACTION_CURRENCY_CODE
, AAM.LAST_CALCULATED_DATE LAST_CALCULATED_DATE
, SUM(NVL(AAM.TRANS_FORECASTED_VALUE
, 0)) EVENT_OFFER_TOT_FRCST_COST
, SUM(NVL(AAM.TRANS_ACTUAL_VALUE
, 0)) EVENT_OFFER_TOT_ACTL_COST
FROM AMS_ACT_METRICS_ALL AAM
, AMS_METRICS_ALL_B AMT
WHERE AAM.ARC_ACT_METRIC_USED_BY ='EVEO'
AND AAM.METRIC_ID = AMT.METRIC_ID
AND AMT.SUMMARY_METRIC_ID IS NULL
AND AMT.METRIC_CATEGORY = 901 GROUP BY AAM.ACT_METRIC_USED_BY_ID
, AAM.TRANSACTION_CURRENCY_CODE
, AAM.LAST_CALCULATED_DATE WITH READ ONLY

Columns

Name
EVENT_OFFER_ID
TRANSACTION_CURRENCY_CODE
LAST_CALCULATED_DATE
EVENT_OFFER_TOT_FRCST_COST
EVENT_OFFER_TOT_ACTL_COST