I_MKT_WebVisitsCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_MKT_WebVisitsCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IMKT_VISITSCUBE
-- Parameters: P_StartDate : cuan_start_date, P_EndDate : cuan_end_date

CREATE VIEW I_MKT_WebVisitsCube AS
SELECT
  _MKT_CountryMarket.Market AS Market,
  visits.CountryCode AS CountryCode,
  visits.Brand AS Brand,
  visits.MarketingAudience AS MarketingAudience,
  _MKT_CalendarDate.CalendarWeek AS CalendarWeek,
  sum(visits.NumberOfWebsiteVisits) AS NumberOfWebsiteVisits,
  sum(visits.NumberOfUniqueWebsiteVisitors) AS NumberOfUniqueWebsiteVisitors,
  sum(visits.NumberOfPageViews) AS NumberOfPageViews
FROM I_MKT_WebVisits AS visits
LEFT OUTER JOIN I_MKT_Brand AS _MKT_Brand ON Brand = _MKT_Brand.Brand  -- association [1..1]
LEFT OUTER JOIN I_MKT_Country AS _MKT_Country ON CountryCode = _MKT_Country.Country  -- association [1..1]
LEFT OUTER JOIN I_MKT_CountryMarket AS _MKT_CountryMarket ON CountryCode = _MKT_CountryMarket.Country  -- association [1..1]
LEFT OUTER JOIN I_MKT_Market AS _MKT_Market ON Market = _MKT_Market.Market  -- association [1..1]
LEFT OUTER JOIN I_MKT_Audience AS _MKT_Audience ON MarketingAudience = _MKT_Audience.MarketingAudience  -- association [1..1]
LEFT OUTER JOIN I_MKT_CalendarDate AS _MKT_CalendarDate ON visits.MktgKPIDate = _MKT_CalendarDate.CalendarDate  -- association [1..1]
;