VIEW: BIM.BIM_R_EVEN_DIM_SUM_MV_TEMP1#

Source

View Text - Preformatted

select EVENT_HEADER_AREA2 EVENT_HEADER_AREA2, EVENT_COUNTRY EVENT_COUNTRY, EVENT_TYPE EVENT_TYPE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, HEADER_COUNT HEADER_COUNT, REGISTRATIONS REGISTRATIONS, CANCELLATIONS CANCELLATIONS, LEADS_OPEN LEADS_OPEN, LEADS_OPEN_AMT LEADS_OPEN_AMT, LEADS_CLOSED LEADS_CLOSED, LEADS_CLOSED_AMT LEADS_CLOSED_AMT, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITY_AMT OPPORTUNITY_AMT, ATTENDANCE ATTENDANCE, FORECASTED_COST FORECASTED_COST, FORECASTED_REVENUE FORECASTED_REVENUE, ACTUAL_COST ACTUAL_COST, REVENUE REVENUE, ORDER_AMT ORDER_AMT, BUDGET_REQUESTED BUDGET_REQUESTED, BUDGET_APPROVED BUDGET_APPROVED, RESOURCE_ID RESOURCE_ID from "BIM"."BIM_R_EVEN_DIM_SUM_MV_TEMP1"

View Text - HTML Formatted

SELECT EVENT_HEADER_AREA2 EVENT_HEADER_AREA2
, EVENT_COUNTRY EVENT_COUNTRY
, EVENT_TYPE EVENT_TYPE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, HEADER_COUNT HEADER_COUNT
, REGISTRATIONS REGISTRATIONS
, CANCELLATIONS CANCELLATIONS
, LEADS_OPEN LEADS_OPEN
, LEADS_OPEN_AMT LEADS_OPEN_AMT
, LEADS_CLOSED LEADS_CLOSED
, LEADS_CLOSED_AMT LEADS_CLOSED_AMT
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, ATTENDANCE ATTENDANCE
, FORECASTED_COST FORECASTED_COST
, FORECASTED_REVENUE FORECASTED_REVENUE
, ACTUAL_COST ACTUAL_COST
, REVENUE REVENUE
, ORDER_AMT ORDER_AMT
, BUDGET_REQUESTED BUDGET_REQUESTED
, BUDGET_APPROVED BUDGET_APPROVED
, RESOURCE_ID RESOURCE_ID
FROM "BIM"."BIM_R_EVEN_DIM_SUM_MV_TEMP1"