List of Cube

Contents

sitearea_footfallcounting_minute

Description	Store minute level people counting data
Cube Name	sitearea_footfallcounting_minute
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC01_1_MAX FC01_1_MIN FC01_1_AVG FC02_1_SUM FC02_1_MAX FC02_1_MIN FC02_1_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) isoperating (string) FC01_1 (int) FC02_1 (int)

sitearea_footfallcounting_hour

Description	Store hour level people counting data
Cube Name	sitearea_footfallcounting_hour
Time Granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC01_1_MAX FC01_1_MIN FC01_1_AVG FC02_1_SUM FC02_1_MAX FC02_1_MIN FC02_1_AVG FC03_1_SUM FC03_1_MAX FC03_1_MIN FC03_1_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) isoperating (string) FC01_1 (int) FC02_1 (int) FC03_1 (double)

sitegroup_footfallcounting_day

Description	Site Group day level people counting data
Cube Name	sitegroup_footfallcounting_day
Time Granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC01_1_MAX FC01_1_MIN FC01_1_AVG FC02_1_SUM FC02_1_MAX FC02_1_MIN FC02_1_AVG FC03_1_SUM FC03_1_MAX FC03_1_MIN FC03_1_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) SiteGroupId (string) SiteGroupName (string) CompanyId (string) CompanyName (string) isoperating (string) FC01_1 (int) FC02_1 (int) FC03_1 (double)

sitegroup_footfallcounting_hour

Description	Site Group hour level people counting data
Cube Name	sitegroup_footfallcounting_hour
Time Granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC01_1_MAX FC01_1_MIN FC01_1_AVG FC02_1_SUM FC02_1_MAX FC02_1_MIN FC02_1_AVG FC03_1_SUM FC03_1_MAX FC03_1_MIN FC03_1_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) SiteGroupId (string) SiteGroupName (string) CompanyId (string) CompanyName (string) isoperating (string) FC01_1 (int) FC02_1 (int) FC03_1 (double)

site_footfallcounting_15minute

Description	Store site minute level people counting data which rolled up to 15 minutes
Cube Name	site_footfallcounting_15minute
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC02_1_SUM SO01_1_SUM
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) isoperating (string) IsSiteVerified (string) SiteVerifiedDate (datetime as string)
Body - JSON Example	{ "query": { "measures": [ "site_footfallcounting_15minute.FC01_1_SUM", "site_footfallcounting_15minute.FC02_1_SUM", "site_footfallcounting_15minute.SO01_1_SUM" ], "dimensions": [ "site_footfallcounting_15minute.CompanyId", "site_footfallcounting_15minute.CompanyName", "site_footfallcounting_15minute.BranchId", "site_footfallcounting_15minute.BranchName" ], "filters": [ { "member": "site_footfallcounting_15minute.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "site_footfallcounting_15minute.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_footfallcounting_15minute.isoperating", "operator": "equals", "values": [ "true" ] }, { "member": "site_footfallcounting_15minute.IsSiteVerified", "operator": "equals", "values": [ "true" ] } ], "timeDimensions": [ { "dimension": "site_footfallcounting_15minute.Time", "dateRange": [ "2022-01-01T00:00:00.000", "2022-01-02" ], "granularity": "minute" } ], "order": [ [ "site_footfallcounting_15minute.BranchId", "asc" ], [ "site_footfallcounting_15minute.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_footfallcounting_15minute.CompanyId": "12345", "site_footfallcounting_15minute.CompanyName": "DemoCompany", "site_footfallcounting_15minute.BranchId": "22222", "site_footfallcounting_15minute.BranchName": "DemoBranch", "site_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000", "site_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000", "site_footfallcounting_15minute.FC01_1_SUM": 0, "site_footfallcounting_15minute.FC02_1_SUM": 0, "site_footfallcounting_15minute.SO01_1_SUM": 0 }, { "site_footfallcounting_15minute.CompanyId": "12345", "site_footfallcounting_15minute.CompanyName": "DemoCompany", "site_footfallcounting_15minute.BranchId": "22222", "site_footfallcounting_15minute.BranchName": "DemoBranch", "site_footfallcounting_15minute.Time.minute": "2022-01-01T09:00:00.000", "site_footfallcounting_15minute.Time": "2022-01-01T09:00:00.000", "site_footfallcounting_15minute.FC01_1_SUM": 5, "site_footfallcounting_15minute.FC02_1_SUM": 2, "site_footfallcounting_15minute.SO01_1_SUM": 1 }, { "site_footfallcounting_15minute.CompanyId": "12345", "site_footfallcounting_15minute.CompanyName": "DemoCompany", "site_footfallcounting_15minute.BranchId": "22222", "site_footfallcounting_15minute.BranchName": "DemoBranch", "site_footfallcounting_15minute.Time.minute": "2022-01-01T09:30:00.000", "site_footfallcounting_15minute.Time": "2022-01-01T09:30:00.000", "site_footfallcounting_15minute.FC01_1_SUM": 3, "site_footfallcounting_15minute.FC02_1_SUM": 4, "site_footfallcounting_15minute.SO01_1_SUM": 0 } ], ... }

site_footfallcounting_30minute

Description	Store site minute level people counting data which rolled up to 30 minutes
Cube Name	site_footfallcounting_30minute
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC02_1_SUM
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) isoperating (string)
Body - JSON Example	{ "query": { "measures": [ "site_footfallcounting_30minute.FC01_1_SUM", "site_footfallcounting_30minute.FC02_1_SUM" ], "dimensions": [ "site_footfallcounting_30minute.CompanyId", "site_footfallcounting_30minute.CompanyName", "site_footfallcounting_30minute.BranchId", "site_footfallcounting_30minute.BranchName" ], "filters": [ { "member": "site_footfallcounting_30minute.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "site_footfallcounting_30minute.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_footfallcounting_30minute.isoperating", "operator": "equals", "values": [ "true" ] } ], "timeDimensions": [ { "dimension": "site_footfallcounting_30minute.Time", "dateRange": [ "2022-01-01T00:00:00.000", "2022-01-02" ], "granularity": "minute" } ], "order": [ [ "site_footfallcounting_30minute.BranchId", "asc" ], [ "site_footfallcounting_30minute.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_footfallcounting_30minute.CompanyId": "12345", "site_footfallcounting_30minute.CompanyName": "DemoCompany", "site_footfallcounting_30minute.BranchId": "22222", "site_footfallcounting_30minute.BranchName": "DemoBranch", "site_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000", "site_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000", "site_footfallcounting_30minute.FC01_1_SUM": 0, "site_footfallcounting_30minute.FC02_1_SUM": 0 }, { "site_footfallcounting_30minute.CompanyId": "12345", "site_footfallcounting_30minute.CompanyName": "DemoCompany", "site_footfallcounting_30minute.BranchId": "22222", "site_footfallcounting_30minute.BranchName": "DemoBranch", "site_footfallcounting_30minute.Time.minute": "2022-01-01T09:00:00.000", "site_footfallcounting_30minute.Time": "2022-01-01T09:00:00.000", "site_footfallcounting_30minute.FC01_1_SUM": 5, "site_footfallcounting_30minute.FC02_1_SUM": 2 }, { "site_footfallcounting_30minute.CompanyId": "12345", "site_footfallcounting_30minute.CompanyName": "DemoCompany", "site_footfallcounting_30minute.BranchId": "22222", "site_footfallcounting_30minute.BranchName": "DemoBranch", "site_footfallcounting_30minute.Time.minute": "2022-01-01T09:30:00.000", "site_footfallcounting_30minute.Time": "2022-01-01T09:30:00.000", "site_footfallcounting_30minute.FC01_1_SUM": 3, "site_footfallcounting_30minute.FC02_1_SUM": 4 } ], ... }

area_footfallcounting_15minute

Description	Store area minute level people counting data which rolled up to 15 minutes
Cube Name	area_footfallcounting_15minute
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC02_1_SUM SO01_1_SUM
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) isoperating (string)
Body - JSON Example	{ "query": { "measures": [ "area_footfallcounting_15minute.FC01_1_SUM", "area_footfallcounting_15minute.FC02_1_SUM", "area_footfallcounting_15minute.SO01_1_SUM" ], "dimensions": [ "area_footfallcounting_15minute.CompanyId", "area_footfallcounting_15minute.CompanyName", "area_footfallcounting_15minute.BranchId", "area_footfallcounting_15minute.BranchName", "area_footfallcounting_15minute.AreaId", "area_footfallcounting_15minute.AreaName" ], "filters": [ { "member": "area_footfallcounting_15minute.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "area_footfallcounting_15minute.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "area_footfallcounting_15minute.isoperating", "operator": "equals", "values": [ "true" ] } ], "timeDimensions": [ { "dimension": "area_footfallcounting_15minute.Time", "dateRange": [ "2022-01-01T00:00:00.000", "2022-01-02" ], "granularity": "minute" } ], "order": [ [ "area_footfallcounting_15minute.BranchId", "asc" ], [ "area_footfallcounting_15minute.AreaId", "asc" ], [ "area_footfallcounting_15minute.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_footfallcounting_15minute.CompanyId": "12345", "area_footfallcounting_15minute.CompanyName": "DemoCompany", "area_footfallcounting_15minute.BranchId": "22222", "area_footfallcounting_15minute.BranchName": "DemoBranch", "area_footfallcounting_15minute.AreaId": "-1", "area_footfallcounting_15minute.AreaName": null, "area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000", "area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000", "area_footfallcounting_15minute.FC01_1_SUM": 0, "area_footfallcounting_15minute.FC02_1_SUM": 0, "area_footfallcounting_15minute.SO01_1_SUM": 0 }, { "area_footfallcounting_15minute.CompanyId": "12345", "area_footfallcounting_15minute.CompanyName": "DemoCompany", "area_footfallcounting_15minute.BranchId": "22222", "area_footfallcounting_15minute.BranchName": "DemoBranch", "area_footfallcounting_15minute.AreaId": "10101", "area_footfallcounting_15minute.AreaName": "DemoArea1", "area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000", "area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000", "area_footfallcounting_15minute.FC01_1_SUM": 0, "area_footfallcounting_15minute.FC02_1_SUM": 0, "area_footfallcounting_15minute.SO01_1_SUM": 0 }, { "area_footfallcounting_15minute.CompanyId": "12345", "area_footfallcounting_15minute.CompanyName": "DemoCompany", "area_footfallcounting_15minute.BranchId": "22222", "area_footfallcounting_15minute.BranchName": "DemoBranch", "area_footfallcounting_15minute.AreaId": "20202", "area_footfallcounting_15minute.AreaName": "DemoArea2", "area_footfallcounting_15minute.Time.minute": "2022-01-01T00:00:00.000", "area_footfallcounting_15minute.Time": "2022-01-01T00:00:00.000", "area_footfallcounting_15minute.FC01_1_SUM": 0, "area_footfallcounting_15minute.FC02_1_SUM": 0, "area_footfallcounting_15minute.SO01_1_SUM": 0 } ], ... }

area_footfallcounting_30minute

Description	Store area minute level people counting data which rolled up to 30 minutes
Cube Name	area_footfallcounting_30minute
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC02_1_SUM
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) isoperating (string)
Body - JSON Example	{ "query": { "measures": [ "area_footfallcounting_30minute.FC01_1_SUM", "area_footfallcounting_30minute.FC02_1_SUM" ], "dimensions": [ "area_footfallcounting_30minute.CompanyId", "area_footfallcounting_30minute.CompanyName", "area_footfallcounting_30minute.BranchId", "area_footfallcounting_30minute.BranchName", "area_footfallcounting_30minute.AreaId", "area_footfallcounting_30minute.AreaName" ], "filters": [ { "member": "area_footfallcounting_30minute.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "area_footfallcounting_30minute.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "area_footfallcounting_30minute.isoperating", "operator": "equals", "values": [ "true" ] } ], "timeDimensions": [ { "dimension": "area_footfallcounting_30minute.Time", "dateRange": [ "2022-01-01T00:00:00.000", "2022-01-02" ], "granularity": "minute" } ], "order": [ [ "area_footfallcounting_30minute.BranchId", "asc" ], [ "area_footfallcounting_30minute.AreaId", "asc" ], [ "area_footfallcounting_30minute.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_footfallcounting_30minute.CompanyId": "12345", "area_footfallcounting_30minute.CompanyName": "DemoCompany", "area_footfallcounting_30minute.BranchId": "22222", "area_footfallcounting_30minute.BranchName": "DemoBranch", "area_footfallcounting_30minute.AreaId": "-1", "area_footfallcounting_30minute.AreaName": null, "area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000", "area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000", "area_footfallcounting_30minute.FC01_1_SUM": 0, "area_footfallcounting_30minute.FC02_1_SUM": 0 }, { "area_footfallcounting_30minute.CompanyId": "12345", "area_footfallcounting_30minute.CompanyName": "DemoCompany", "area_footfallcounting_30minute.BranchId": "22222", "area_footfallcounting_30minute.BranchName": "DemoBranch", "area_footfallcounting_30minute.AreaId": "10101", "area_footfallcounting_30minute.AreaName": "DemoArea1", "area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000", "area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000", "area_footfallcounting_30minute.FC01_1_SUM": 0, "area_footfallcounting_30minute.FC02_1_SUM": 0 }, { "area_footfallcounting_30minute.CompanyId": "12345", "area_footfallcounting_30minute.CompanyName": "DemoCompany", "area_footfallcounting_30minute.BranchId": "22222", "area_footfallcounting_30minute.BranchName": "DemoBranch", "area_footfallcounting_30minute.AreaId": "20202", "area_footfallcounting_30minute.AreaName": "DemoArea2", "area_footfallcounting_30minute.Time.minute": "2022-01-01T00:00:00.000", "area_footfallcounting_30minute.Time": "2022-01-01T00:00:00.000", "area_footfallcounting_30minute.FC01_1_SUM": 0, "area_footfallcounting_30minute.FC02_1_SUM": 0 } ], ... }

sitearea_footfallcounting_minute_accumulate

Description	Store minute level people counting accumulated data
Cube Name	sitearea_footfallcounting_minute_accumulate
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC05_1_MAX FC05_1_MIN FC05_11_MAX FC05_11_MIN SO05_1_MAX SO05_1_MIN SO05_11_MAX SO05_11_MIN SO05_12_MAX SO05_12_MIN SO05_21_MAX SO05_21_MIN
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) FC05_1 (int) FC05_11 (int) SO05_1 (int) SO05_11 (int) SO05_12 (int) SO05_21 (int)
Body - JSON Example	{ "query": { "measures": [ "sitearea_footfallcounting_minute_accumulate.SO05_1_MAX" ], "dimensions": [ "sitearea_footfallcounting_minute_accumulate.CompanyId", "sitearea_footfallcounting_minute_accumulate.CompanyName", "sitearea_footfallcounting_minute_accumulate.BranchId", "sitearea_footfallcounting_minute_accumulate.BranchName", "sitearea_footfallcounting_minute_accumulate.AreaId", "sitearea_footfallcounting_minute_accumulate.AreaName" ], "filters": [ { "member": "sitearea_footfallcounting_minute_accumulate.BranchId", "operator": "equals", "values": [ "12345" ] }, { "member": "sitearea_footfallcounting_minute_accumulate.AreaId", "operator": "equals", "values": [ "1111" ] } ], "timeDimensions": [ { "dimension": "sitearea_footfallcounting_minute_accumulate.Time", "dateRange": [ "2022-02-01T00:00:00.000", "2022-02-02" ], "granularity": "minute" } ], "order": [ [ "sitearea_footfallcounting_minute_accumulate.Time", "desc" ] ], "limit": 1 } }
Response - JSON Example	{ ... "data": [ { "sitearea_footfallcounting_minute_accumulate.CompanyId": "10101", "sitearea_footfallcounting_minute_accumulate.CompanyName": "DemoCompany", "sitearea_footfallcounting_minute_accumulate.BranchId": "12345", "sitearea_footfallcounting_minute_accumulate.BranchName": "DemoBranch", "sitearea_footfallcounting_minute_accumulate.AreaId": "1111", "sitearea_footfallcounting_minute_accumulate.AreaName": "DemoArea", "sitearea_footfallcounting_minute_accumulate.Time.minute": "2022-02-01T23:50:00.000", "sitearea_footfallcounting_minute_accumulate.Time": "2022-02-01T23:50:00.000", "sitearea_footfallcounting_minute_accumulate.SO05_1_MAX": 84 } ], ... }

sitearea_buscounting_minute

Description	Store site & area minute level bus counting data
Cube Name	sitearea_buscounting_minute
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'minute'. minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details FC01_1_SUM FC01_1_MAX FC01_1_MIN FC01_1_AVG FC02_1_SUM FC02_1_MAX FC02_1_MIN FC02_1_AVG SO01_1_SUM SO01_1_MAX SO01_1_MIN SO01_1_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" ScheduledStartTime (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" ActualArrivalDateTime (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchCode (string) BranchName (string) CompanyId (string) CompanyName (string) FC01_1 (int) FC02_1 (int) SO01_1 (int)
Body - JSON Example	{ "query": { "measures": [ "sitearea_buscounting_minute.FC01_1_SUM", "sitearea_buscounting_minute.FC02_1_SUM", "sitearea_buscounting_minute.SO01_1_SUM" ], "dimensions": [ "sitearea_buscounting_minute.TripId", "sitearea_buscounting_minute.ScheduledStartTime", "sitearea_buscounting_minute.Time", "sitearea_buscounting_minute.ActualArrivalDateTime", "sitearea_buscounting_minute.CompanyId", "sitearea_buscounting_minute.CompanyName", "sitearea_buscounting_minute.BranchId", "sitearea_buscounting_minute.BranchName", "sitearea_buscounting_minute.AreaId", "sitearea_buscounting_minute.AreaName" ], "timeDimensions": [ { "dimension": "sitearea_buscounting_minute.Time", "dateRange": [ "2022-03-10T00:00:00.000", "2022-03-11" ], "granularity": "minute" } ], "filters": [ { "member": "sitearea_buscounting_minute.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "sitearea_buscounting_minute.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "sitearea_buscounting_minute.AreaId", "operator": "equals", "values": [ "1101", "2202" ] }, { "member": "sitearea_buscounting_minute.AreaName", "operator": "equals", "values": [ "Area1", "Area2" ] } ], "order": [ [ "sitearea_buscounting_minute.TripId", "asc" ], [ "sitearea_buscounting_minute.AreaId", "asc" ], [ "sitearea_buscounting_minute.ScheduledStartTime", "asc" ] ] } }
Response - JSON Example	{ ... "data": [ { "sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7", "sitearea_buscounting_minute.StationId": "61025D6D-94A9-4DDE-AE23-BAD5D93BCC03", "sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:12:00.000", "sitearea_buscounting_minute.Time": "2022-03-10T18:18:46.000", "sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:18:46.000", "sitearea_buscounting_minute.CompanyId": 12345, "sitearea_buscounting_minute.CompanyName": "Company1", "sitearea_buscounting_minute.BranchId": 11111, "sitearea_buscounting_minute.BranchName": "Branch1", "sitearea_buscounting_minute.AreaId": 1101, "sitearea_buscounting_minute.AreaName": "Area1", "sitearea_buscounting_minute.Time.minute": "2022-03-10T18:18:00.000", "sitearea_buscounting_minute.FC01_1_SUM": 8, "sitearea_buscounting_minute.FC02_1_SUM": 6, "sitearea_buscounting_minute.SO01_1_SUM": 2 }, { "sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7", "sitearea_buscounting_minute.StationId": "2D931974-2423-457C-B057-92BD31B5E9FF", "sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:14:00.000", "sitearea_buscounting_minute.Time": "2022-03-10T18:21:10.000", "sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:21:10.000", "sitearea_buscounting_minute.CompanyId": 12345, "sitearea_buscounting_minute.CompanyName": "Company1", "sitearea_buscounting_minute.BranchId": 11111, "sitearea_buscounting_minute.BranchName": "Branch1", "sitearea_buscounting_minute.AreaId": 1101, "sitearea_buscounting_minute.AreaName": "Area1", "sitearea_buscounting_minute.Time.minute": "2022-03-10T18:21:00.000", "sitearea_buscounting_minute.FC01_1_SUM": 0, "sitearea_buscounting_minute.FC02_1_SUM": 0, "sitearea_buscounting_minute.SO01_1_SUM": 2 }, { "sitearea_buscounting_minute.TripId": "D5975107-F39E-49BC-A975-4016011EA0E7", "sitearea_buscounting_minute.StationId": "E24E9D16-D6D9-432D-ABC8-A9D71C1A4FB1", "sitearea_buscounting_minute.ScheduledStartTime": "2022-03-10T18:15:00.000", "sitearea_buscounting_minute.Time": "2022-03-10T18:22:02.000", "sitearea_buscounting_minute.ActualArrivalDateTime": "2022-03-10T18:22:02.000", "sitearea_buscounting_minute.CompanyId": 12345, "sitearea_buscounting_minute.CompanyName": "Company1", "sitearea_buscounting_minute.BranchId": 11111, "sitearea_buscounting_minute.BranchName": "Branch1", "sitearea_buscounting_minute.AreaId": 1101, "sitearea_buscounting_minute.AreaName": "Area1", "sitearea_buscounting_minute.Time.minute": "2022-03-10T18:22:00.000", "sitearea_buscounting_minute.FC01_1_SUM": 3, "sitearea_buscounting_minute.FC02_1_SUM": 0, "sitearea_buscounting_minute.SO01_1_SUM": 5 } ], ... }

site_area_1d_joined_data

Description	Site and Area data with different metrics
Cube Name	site_area_1d_joined_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details PFC01_11 PFC02_11 PFC01_3011 PFC01_5011 PFC27 SWA04 SWA05 SWA06 SWA07 PWA01 SWA02
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" OperateDate (datetime as string) AreaId (string) AreaName (string) BranchId (string) BranchName (string) BranchCode (string) CompanyId (string) CompanyName (string) AreaGroupId (string) AreaGroupName (string) SiteGroupId (string) SiteGroupdName (string)
Segments	Available segments to filter data: IsAreaLevel - Use this segment to query area level data IsSiteLevel - Use this segment to query site level data *Querying site level data without using IsSiteLevel may cause incorrect data returned.
Body - JSON Example	{ "query": { "measures": [ "site_area_1d_joined_data.PFC01_11", "site_area_1d_joined_data.PWA01", "site_area_1d_joined_data.SWA02", "site_area_1d_joined_data.PFC27", "site_area_1d_joined_data.SWA04", "site_area_1d_joined_data.SWA06" ], "dimensions": [ "site_area_1d_joined_data.CompanyId", "site_area_1d_joined_data.CompanyName", "site_area_1d_joined_data.BranchId", "site_area_1d_joined_data.BranchName", "site_area_1d_joined_data.Time" ], "filters": [ { "member": "site_area_1d_joined_data.BranchId", "operator": "equals", "values": [ "1" ] } ], "timeDimensions": [ { "dimension": "site_area_1d_joined_data.Time", "dateRange": [ "2024-01-19T00:00:00.000000", "2024-01-20T23:59:59.000000" ], "granularity": "day" } ], "segments": [ "site_area_1d_joined_data.IsSiteLevel" ], "order": { "site_area_1d_joined_data.Time": "asc" } } }
Response - JSON Example	{ ... "data": [ { "site_area_1d_joined_data.CompanyId": 1, "site_area_1d_joined_data.CompanyName": "DemoCompany", "site_area_1d_joined_data.BranchId": 1, "site_area_1d_joined_data.BranchName": "Shoppingmall", "site_area_1d_joined_data.Time": "2024-01-19T00:00:00.000", "site_area_1d_joined_data.Time.day": "2024-01-19T00:00:00.000", "site_area_1d_joined_data.PFC01_11": 4958, "site_area_1d_joined_data.PWA01": 6060, "site_area_1d_joined_data.SWA02": 0.45, "site_area_1d_joined_data.PFC27": 1234.56, "site_area_1d_joined_data.SWA04": 0.66, "site_area_1d_joined_data.SWA06": 0.34 }, { "site_area_1d_joined_data.CompanyId": 1, "site_area_1d_joined_data.CompanyName": "DemoCompany", "site_area_1d_joined_data.BranchId": 1, "site_area_1d_joined_data.BranchName": "Shoppingmall", "site_area_1d_joined_data.Time": "2024-01-20T00:00:00.000", "site_area_1d_joined_data.Time.day": "2024-01-20T00:00:00.000", "site_area_1d_joined_data.PFC01_11": 4929, "site_area_1d_joined_data.PWA01": 7070, "site_area_1d_joined_data.SWA02": 0.41, "site_area_1d_joined_data.PFC27": 706.61, "site_area_1d_joined_data.SWA04": 0.21, "site_area_1d_joined_data.SWA06": 0.79 } ], ... }

site_area_1h_joined_data

Description	Site and Area data with different metrics
Cube Name	site_area_1h_joined_data
Time granularities	The time granularity for this cube is 'hour'. Please use site_area_1d_joined_data for larger time granularities.
Measures	Available metrics for this cube, refer Metrics Definition for metric details PFC01_11 PFC02_11 PFC01_3011 PFC01_5011 PFC27 PWA01 SWA02
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" OperateDate (datetime as string) AreaId (string) AreaName (string) BranchId (string) BranchName (string) BranchCode (string) CompanyId (string) CompanyName (string) AreaGroupId (string) AreaGroupName (string) SiteGroupId (string) SiteGroupdName (string)
Segments	Available segments to filter data: IsAreaLevel - Use this segment to query area level data IsSiteLevel - Use this segment to query site level data *Querying site level data without using IsSiteLevel may cause incorrect data returned.
Body - JSON Example	{ "query": { "measures": [ "site_area_1h_joined_data.PFC01_11", "site_area_1h_joined_data.PWA01", "site_area_1h_joined_data.SWA02", "site_area_1h_joined_data.PFC27" ], "dimensions": [ "site_area_1h_joined_data.CompanyId", "site_area_1h_joined_data.CompanyName", "site_area_1h_joined_data.BranchId", "site_area_1h_joined_data.BranchName", "site_area_1h_joined_data.Time" ], "filters": [ { "member": "site_area_1h_joined_data.BranchId", "operator": "equals", "values": [ "25610" ] } ], "timeDimensions": [ { "dimension": "site_area_1h_joined_data.Time", "dateRange": [ "2024-01-19T10:00:00.000000", "2024-01-19T13:59:59.000000" ], "granularity": "hour" } ], "segments": [ "site_area_1h_joined_data.IsSiteLevel" ], "order": { "site_area_1h_joined_data.Time": "asc" } } }
Response - JSON Example	{ ... "data": [ { "site_area_1h_joined_data.CompanyId": 1, "site_area_1h_joined_data.CompanyName": "DemoCompany", "site_area_1h_joined_data.BranchId": 1, "site_area_1h_joined_data.BranchName": "Shoppingmall", "site_area_1h_joined_data.Time": "2024-01-19T10:00:00.000", "site_area_1h_joined_data.Time.hour": "2024-01-19T10:00:00.000", "site_area_1h_joined_data.PFC01_11": 325, "site_area_1h_joined_data.PWA01": 101, "site_area_1h_joined_data.SWA02": 0.76, "site_area_1h_joined_data.PFC27": 310.20 }, { "site_area_1h_joined_data.CompanyId": 18330, "site_area_1h_joined_data.CompanyName": "DemoCompany", "site_area_1h_joined_data.BranchId": 25610, "site_area_1h_joined_data.BranchName": "Shoppingmall", "site_area_1h_joined_data.Time": "2024-01-19T11:00:00.000", "site_area_1h_joined_data.Time.hour": "2024-01-19T11:00:00.000", "site_area_1h_joined_data.PFC01_11": 440, "site_area_1h_joined_data.PWA01": 202, "site_area_1h_joined_data.SWA02": 0.69, "site_area_1h_joined_data.PFC27": 322.21 }, ... ], ... }

site_area_occupancy_data

Description	Store site & area (space sense) occupancy data
Cube Name	site_area_occupancy_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'second'. second, minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details PSO05_MIN PSO05_MAX PSO05_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_area_occupancy_data.PSO05_MIN", "site_area_occupancy_data.PSO05_MAX", "site_area_occupancy_data.PSO05_AVG" ], "dimensions": [ "site_area_occupancy_data.CompanyId", "site_area_occupancy_data.CompanyName", "site_area_occupancy_data.BranchId", "site_area_occupancy_data.BranchName", "site_area_occupancy_data.AreaId", "site_area_occupancy_data.AreaName" ], "filters": [ { "member": "site_area_occupancy_data.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "site_area_occupancy_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_area_occupancy_data.AreaId", "operator": "equals", "values": [ "33333" ] } ], "timeDimensions": [ { "dimension": "site_area_occupancy_data.Time", "dateRange": [ "2022-01-01T00:00:00.000", "2022-01-02" ], "granularity": "minute" } ], "order": [ [ "site_area_occupancy_data.BranchId", "asc" ], [ "site_area_occupancy_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_area_occupancy_data.CompanyId": "12345", "site_area_occupancy_data.CompanyName": "DemoCompany", "site_area_occupancy_data.BranchId": "22222", "site_area_occupancy_data.BranchName": "DemoBranch", "site_area_occupancy_data.AreaId": "33333", "site_area_occupancy_data.AreaName": "DemoArea", "site_area_occupancy_data.Time.minute": "2022-01-01T00:00:00.000", "site_area_occupancy_data.Time": "2022-01-01T00:00:00.000", "site_area_occupancy_data.PSO05_MIN": 1, "site_area_occupancy_data.PSO05_MAX": 1, "site_area_occupancy_data.PSO05_AVG": 1 }, { "site_area_occupancy_data.CompanyId": "12345", "site_area_occupancy_data.CompanyName": "DemoCompany", "site_area_occupancy_data.BranchId": "22222", "site_area_occupancy_data.BranchName": "DemoBranch", "site_area_occupancy_data.AreaId": "33333", "site_area_occupancy_data.AreaName": "DemoArea", "site_area_occupancy_data.Time.minute": "2022-01-01T09:27:00.000", "site_area_occupancy_data.Time": "2022-01-01T09:27:00.000", "site_area_occupancy_data.PSO05_MIN": 0, "site_area_occupancy_data.PSO05_MAX": 1, "site_area_occupancy_data.PSO05_AVG": 0.6666666666666666 }, { "site_area_occupancy_data.CompanyId": "12345", "site_area_occupancy_data.CompanyName": "DemoCompany", "site_area_occupancy_data.BranchId": "22222", "site_area_occupancy_data.BranchName": "DemoBranch", "site_area_occupancy_data.AreaId": "33333", "site_area_occupancy_data.AreaName": "DemoArea", "site_area_occupancy_data.Time.minute": "2022-01-01T09:30:00.000", "site_area_occupancy_data.Time": "2022-01-01T09:30:00.000", "site_area_occupancy_data.PSO05_MIN": 0, "site_area_occupancy_data.PSO05_MAX": 2, "site_area_occupancy_data.PSO05_AVG": 1.2 } ], ... }

area_aggregate_occupancy_data_15m

Description	Store site & area (in out) occupancy data
Cube Name	area_aggregate_occupancy_data_15m
Time granularities	Following are available time granularities for this cube, minimum time granularity is 15 minutes (remain using 'minute' as the value for granularity parameter for the API). minute, hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details PSO05_MIN PSO05_MAX PSO05_AVG
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchName (string) CompanyId (number)
Body - JSON Example	{ "query": { "measures": [ "area_aggregate_occupancy_data_15m.PSO05_MIN", "area_aggregate_occupancy_data_15m.PSO05_MAX", "area_aggregate_occupancy_data_15m.PSO05_AVG" ], "dimensions": [ "area_aggregate_occupancy_data_15m.CompanyId", "area_aggregate_occupancy_data_15m.CompanyName", "area_aggregate_occupancy_data_15m.BranchId", "area_aggregate_occupancy_data_15m.BranchName", "area_aggregate_occupancy_data_15m.AreaId", "area_aggregate_occupancy_data_15m.AreaName" ], "filters": [ { "member": "area_aggregate_occupancy_data_15m.AreaId", "operator": "equals", "values": [ "333333" ] } ], "timeDimensions": [ { "dimension": "area_aggregate_occupancy_data_15m.Time", "dateRange": [ "2024-01-01T00:00:00.000", "2024-01-02" ], "granularity": "minute" } ], "order": [ [ "area_aggregate_occupancy_data_15m.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_area_occupancy_data.CompanyId": "12345", "site_area_occupancy_data.CompanyName": "DemoCompany", "site_area_occupancy_data.BranchId": "22222", "site_area_occupancy_data.BranchName": "DemoBranch", "site_area_occupancy_data.AreaId": "33333", "site_area_occupancy_data.AreaName": "DemoArea", "site_area_occupancy_data.Time.minute": "2022-01-01T00:00:00.000", "site_area_occupancy_data.Time": "2022-01-01T00:00:00.000", "site_area_occupancy_data.PSO05_MIN": 1, "site_area_occupancy_data.PSO05_MAX": 1, "site_area_occupancy_data.PSO05_AVG": 1 }, { "site_area_occupancy_data.CompanyId": "12345", "site_area_occupancy_data.CompanyName": "DemoCompany", "site_area_occupancy_data.BranchId": "22222", "site_area_occupancy_data.BranchName": "DemoBranch", "site_area_occupancy_data.AreaId": "33333", "site_area_occupancy_data.AreaName": "DemoArea", "site_area_occupancy_data.Time.minute": "2022-01-01T00:15:00.000", "site_area_occupancy_data.Time": "2022-01-01T00:15:00.000", "site_area_occupancy_data.PSO05_MIN": 0, "site_area_occupancy_data.PSO05_MAX": 1, "site_area_occupancy_data.PSO05_AVG": 0.6666666666666666 }, { "site_area_occupancy_data.CompanyId": "12345", "site_area_occupancy_data.CompanyName": "DemoCompany", "site_area_occupancy_data.BranchId": "22222", "site_area_occupancy_data.BranchName": "DemoBranch", "site_area_occupancy_data.AreaId": "33333", "site_area_occupancy_data.AreaName": "DemoArea", "site_area_occupancy_data.Time.minute": "2022-01-01T00:15:00.000", "site_area_occupancy_data.Time": "2022-01-01T00:15:00.000", "site_area_occupancy_data.PSO05_MIN": 0, "site_area_occupancy_data.PSO05_MAX": 2, "site_area_occupancy_data.PSO05_AVG": 1.2 } ], ... }

site_area_1h_queue_counting

Description	Store site & area queue counting data
Cube Name	site_area_1h_queue_counting
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube, refer Metrics Definition for metric details PQM01_MIN PQM01_MAX PQM01_AVG PQM01_SUM PQM03_MIN PQM03_MAX PQM03_AVG PQM03_SUM PQM04_MIN PQM04_MAX PQM04_AVG PQM04_SUM
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_area_1h_queue_counting.PQM01_MIN", "site_area_1h_queue_counting.PQM01_MAX", "site_area_1h_queue_counting.PQM01_AVG", "site_area_1h_queue_counting.PQM01_SUM", "site_area_1h_queue_counting.PQM03_MIN", "site_area_1h_queue_counting.PQM03_MAX", "site_area_1h_queue_counting.PQM03_AVG", "site_area_1h_queue_counting.PQM03_SUM", "site_area_1h_queue_counting.PQM04_MIN", "site_area_1h_queue_counting.PQM04_MAX", "site_area_1h_queue_counting.PQM04_AVG", "site_area_1h_queue_counting.PQM04_SUM" ], "dimensions": [ "site_area_1h_queue_counting.CompanyId", "site_area_1h_queue_counting.CompanyName", "site_area_1h_queue_counting.BranchId", "site_area_1h_queue_counting.BranchName", "site_area_1h_queue_counting.BranchCode", "site_area_1h_queue_counting.AreaId", "site_area_1h_queue_counting.AreaName", "site_area_1h_queue_counting.IsOperating", "site_area_1h_queue_counting.Time" ], "filters": [ { "member": "site_area_1h_queue_counting.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "site_area_1h_queue_counting.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_area_1h_queue_counting.AreaId", "operator": "equals", "values": [ "33333" ] } ], "timeDimensions": [ { "dimension": "site_area_1h_queue_counting.Time", "dateRange": [ "2023-01-01T00:00:00.000", "2023-01-02" ], "granularity": "minute" } ], "order": [ [ "site_area_1h_queue_counting.BranchId", "asc" ], [ "site_area_1h_queue_counting.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_area_1h_queue_counting.CompanyId": 12345, "site_area_1h_queue_counting.CompanyName": "DemoCompany", "site_area_1h_queue_counting.BranchId": 22222, "site_area_1h_queue_counting.BranchName": "DemoBranch", "site_area_1h_queue_counting.BranchCode": "demo", "site_area_1h_queue_counting.AreaId": 33333, "site_area_1h_queue_counting.AreaName": "DemoArea", "site_area_1h_queue_counting.IsOperating": 0, "site_area_1h_queue_counting.Time": "2023-01-01T00:00:00.000", "site_area_1h_queue_counting.PQM01_MIN": 6, "site_area_1h_queue_counting.PQM01_MAX": 23, "site_area_1h_queue_counting.PQM01_AVG": 19.3312, "site_area_1h_queue_counting.PQM01_SUM": 23, "site_area_1h_queue_counting.PQM03_MIN": 2, "site_area_1h_queue_counting.PQM03_MAX": 23, "site_area_1h_queue_counting.PQM03_AVG": 11.3434, "site_area_1h_queue_counting.PQM03_SUM": 29, "site_area_1h_queue_counting.PQM04_MIN": 2, "site_area_1h_queue_counting.PQM04_MAX": 12, "site_area_1h_queue_counting.PQM04_AVG": 11.2222, "site_area_1h_queue_counting.PQM04_SUM": 12333 }, { "site_area_1h_queue_counting.CompanyId": 12345, "site_area_1h_queue_counting.CompanyName": "DemoCompany", "site_area_1h_queue_counting.BranchId": 22222, "site_area_1h_queue_counting.BranchName": "DemoBranch", "site_area_1h_queue_counting.BranchCode": "demo", "site_area_1h_queue_counting.AreaId": 33333, "site_area_1h_queue_counting.AreaName": "DemoArea", "site_area_1h_queue_counting.IsOperating": 1, "site_area_1h_queue_counting.Time": "2023-01-01T00:00:00.000", "site_area_1h_queue_counting.PQM01_MIN": 0, "site_area_1h_queue_counting.PQM01_MAX": 12, "site_area_1h_queue_counting.PQM01_AVG": 14.433, "site_area_1h_queue_counting.PQM01_SUM": 234, "site_area_1h_queue_counting.PQM03_MIN": 1, "site_area_1h_queue_counting.PQM03_MAX": 212, "site_area_1h_queue_counting.PQM03_AVG": 12.3445, "site_area_1h_queue_counting.PQM03_SUM": 123, "site_area_1h_queue_counting.PQM04_MIN": 3, "site_area_1h_queue_counting.PQM04_MAX": 33, "site_area_1h_queue_counting.PQM04_AVG": 123, "site_area_1h_queue_counting.PQM04_SUM": 1234 } ], ... }

site_area_1h_demographic_data

Description	Store site & area demographic data
Cube Name	site_area_1h_demographic_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Gender_Male_SUM Gender_Female_SUM Emotion_Angry_SUM Emotion_Contempt_SUM Emotion_Disgust_SUM Emotion_Fear_SUM Emotion_Sad_SUM Emotion_Neutral_SUM Emotion_Happy_SUM Emotion_Surprised_SUM Children_Age Teenagers_Age Young_Adults_Age Middle_Aged_Adults_Age Elderly_Age Kids_And_Adults_Age
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (number) AreaName (string) BranchId (number) BranchCode (string) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_area_1h_demographic_data.Gender_Male_SUM", "site_area_1h_demographic_data.Gender_Female_SUM", "site_area_1h_demographic_data.Emotion_Angry_SUM", "site_area_1h_demographic_data.Emotion_Contempt_SUM", "site_area_1h_demographic_data.Emotion_Disgust_SUM", "site_area_1h_demographic_data.Emotion_Fear_SUM", "site_area_1h_demographic_data.Emotion_Sad_SUM", "site_area_1h_demographic_data.Emotion_Neutral_SUM", "site_area_1h_demographic_data.Emotion_Happy_SUM", "site_area_1h_demographic_data.Emotion_Surprised_SUM", "site_area_1h_demographic_data.Children_Age", "site_area_1h_demographic_data.Teenagers_Age", "site_area_1h_demographic_data.Young_Adults_Age", "site_area_1h_demographic_data.Middle_Aged_Adults_Age", "site_area_1h_demographic_data.Elderly_Age", "site_area_1h_demographic_data.Kids_And_Adults_Age" ], "dimensions": [ "site_area_1h_demographic_data.CompanyId", "site_area_1h_demographic_data.CompanyName", "site_area_1h_demographic_data.BranchId", "site_area_1h_demographic_data.BranchName", "site_area_1h_demographic_data.BranchCode", "site_area_1h_demographic_data.AreaId", "site_area_1h_demographic_data.AreaName", "site_area_1h_demographic_data.IsOperating", "site_area_1h_demographic_data.Time" ], "filters": [ { "member": "site_area_1h_demographic_data.CompanyId", "operator": "equals", "values": [ "12345" ] }, { "member": "site_area_1h_demographic_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_area_1h_demographic_data.AreaId", "operator": "equals", "values": [ "33333" ] } ], "timeDimensions": [ { "dimension": "site_area_1h_demographic_data.Time", "dateRange": [ "2023-01-01T00:00:00.000", "2023-01-02" ], "granularity": "minute" } ], "order": [ [ "site_area_1h_demographic_data.BranchId", "asc" ], [ "site_area_1h_demographic_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_area_1h_demographic_data.CompanyId": 12345, "site_area_1h_demographic_data.CompanyName": "DemoCompany", "site_area_1h_demographic_data.BranchId": 22222, "site_area_1h_demographic_data.BranchName": "DemoBranch", "site_area_1h_demographic_data.AreaId": 33333, "site_area_1h_demographic_data.AreaName": "DemoArea", "site_area_1h_demographic_data.IsOperating": 1, "site_area_1h_demographic_data.Time": "2023-01-01T00:00:00.000", "site_area_1h_demographic_data.Gender_Male_SUM": 22, "site_area_1h_demographic_data.Gender_Female_SUM": 13, "site_area_1h_demographic_data.Emotion_Angry_SUM": 1, "site_area_1h_demographic_data.Emotion_Contempt_SUM": 0, "site_area_1h_demographic_data.Emotion_Disgust_SUM": 4, "site_area_1h_demographic_data.Emotion_Fear_SUM": 2, "site_area_1h_demographic_data.Emotion_Sad_SUM": 4, "site_area_1h_demographic_data.Emotion_Neutral_SUM": 3, "site_area_1h_demographic_data.Emotion_Happy_SUM": 2, "site_area_1h_demographic_data.Emotion_Surprised_SUM": 5, "site_area_1h_demographic_data.Children_Age": 4, "site_area_1h_demographic_data.Teenagers_Age": 392, "site_area_1h_demographic_data.Young_Adults_Age": 12, "site_area_1h_demographic_data.Middle_Aged_Adults_Age": 14, "site_area_1h_demographic_data.Elderly_Age": 2, "site_area_1h_demographic_data.Kids_And_Adults_Age": 16 }, { "site_area_1h_demographic_data.CompanyId": 12345, "site_area_1h_demographic_data.CompanyName": "DemoCompany", "site_area_1h_demographic_data.BranchId": 22222, "site_area_1h_demographic_data.BranchName": "DemoBranch", "site_area_1h_demographic_data.AreaId": 33333, "site_area_1h_demographic_data.AreaName": "DemoArea", "site_area_1h_demographic_data.IsOperating": 1, "site_area_1h_demographic_data.Time": "2023-01-02T00:00:00.000", "site_area_1h_demographic_data.Gender_Male_SUM": 14, "site_area_1h_demographic_data.Gender_Female_SUM": 17, "site_area_1h_demographic_data.Emotion_Angry_SUM": 0, "site_area_1h_demographic_data.Emotion_Contempt_SUM": 3, "site_area_1h_demographic_data.Emotion_Disgust_SUM": 2, "site_area_1h_demographic_data.Emotion_Fear_SUM": 3, "site_area_1h_demographic_data.Emotion_Sad_SUM": 3, "site_area_1h_demographic_data.Emotion_Neutral_SUM": 4, "site_area_1h_demographic_data.Emotion_Happy_SUM": 7, "site_area_1h_demographic_data.Emotion_Surprised_SUM": 8, "site_area_1h_demographic_data.Children_Age": 22, "site_area_1h_demographic_data.Teenagers_Age": 12, "site_area_1h_demographic_data.Young_Adults_Age": 78, "site_area_1h_demographic_data.Middle_Aged_Adults_Age": 22, "site_area_1h_demographic_data.Elderly_Age": 10, "site_area_1h_demographic_data.Kids_And_Adults_Age": 100 } ], ... }

area_occupancy_live

Description	Store site & area live occupancy count
Cube Name	area_occupancy_live
Time granularities	No time granularities needed for live data
Measures	PSO05
Dimensions	Following fields can be used for applying filtering and ordering the data. AreaId (number) AreaName (string) BranchId (number) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "area_occupancy_live.PSO05" ], "dimensions": [ "area_occupancy_live.CompanyId", "area_occupancy_live.CompanyName", "area_occupancy_live.BranchId", "area_occupancy_live.BranchName", "area_occupancy_live.AreaId", "area_occupancy_live.AreaName", "area_occupancy_live.AreaType" ], "filters": [ { "member": "area_occupancy_live.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "area_occupancy_live.AreaId", "operator": "equals", "values": [ "33333", "44444" ] } ], "order": [ [ "area_occupancy_live.BranchId", "asc" ], [ "area_occupancy_live.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "area_occupancy_live.CompanyId": 12345, "area_occupancy_live.CompanyName": "DemoCompany", "area_occupancy_live.BranchId": 11111, "area_occupancy_live.BranchName": "DemoBranch", "area_occupancy_live.AreaId": 33333, "area_occupancy_live.AreaName": "DemoArea", "area_occupancy_live.AreaType": 1, "area_occupancy_live.PSO05": 5632 }, { "area_occupancy_live.CompanyId": 12345, "area_occupancy_live.CompanyName": "DemoCompany", "area_occupancy_live.BranchId": 22222, "area_occupancy_live.BranchName": "DemoBranch", "area_occupancy_live.AreaId": 44444, "area_occupancy_live.AreaName": "DemoArea", "area_occupancy_live.AreaType": 1, "area_occupancy_live.PSO05": 2224 } ], ... }

site_area_1d_kid_counting_data

Description	Store site & area kid & adult counting data
Cube Name	site_area_1d_kid_counting_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	PFC01_3001 PFC02_3001 PFC01_5001 PFC02_5001
Dimensions	Following fields can be used for applying filtering and ordering the data. AreaId (number) AreaName (string) BranchId (number) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_area_1d_kid_counting_data.PFC01_3001", "site_area_1d_kid_counting_data.PFC02_3001", "site_area_1d_kid_counting_data.PFC01_5001", "site_area_1d_kid_counting_data.PFC02_5001" ], "dimensions": [ "site_area_1d_kid_counting_data.CompanyId", "site_area_1d_kid_counting_data.CompanyName", "site_area_1d_kid_counting_data.BranchId", "site_area_1d_kid_counting_data.BranchName", "site_area_1d_kid_counting_data.AreaId", "site_area_1d_kid_counting_data.AreaName", "site_area_1d_kid_counting_data.AreaType" ], "filters": [ { "member": "site_area_1d_kid_counting_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_area_1d_kid_counting_data.AreaId", "operator": "equals", "values": [ "33333", "44444" ] } ], "order": [ [ "site_area_1d_kid_counting_data.BranchId", "asc" ], [ "site_area_1d_kid_counting_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_area_1d_kid_counting_data.CompanyId": 12345, "site_area_1d_kid_counting_data.CompanyName": "DemoCompany", "site_area_1d_kid_counting_data.BranchId": 11111, "site_area_1d_kid_counting_data.BranchName": "DemoBranch", "site_area_1d_kid_counting_data.AreaId": 33333, "site_area_1d_kid_counting_data.AreaName": "DemoArea", "site_area_1d_kid_counting_data.AreaType": 1, "site_area_1d_kid_counting_data.PFC01_3001": 5422, "site_area_1d_kid_counting_data.PFC02_3001": 5420, "site_area_1d_kid_counting_data.PFC01_5001": 12532, "site_area_1d_kid_counting_data.PFC02_5001": 12529 }, { "site_area_1d_kid_counting_data.CompanyId": 12345, "site_area_1d_kid_counting_data.CompanyName": "DemoCompany", "site_area_1d_kid_counting_data.BranchId": 22222, "site_area_1d_kid_counting_data.BranchName": "DemoBranch", "site_area_1d_kid_counting_data.AreaId": 44444, "site_area_1d_kid_counting_data.AreaName": "DemoArea", "site_area_1d_kid_counting_data.AreaType": 1, "site_area_1d_kid_counting_data.PFC01_3001": 5428, "site_area_1d_kid_counting_data.PFC02_3001": 5315, "site_area_1d_kid_counting_data.PFC01_5001": 35147, "site_area_1d_kid_counting_data.PFC02_5001": 32362 } ], ... }

site_area_1h_kid_counting_data

Description	Store site & area kid & adult counting data
Cube Name	site_area_1h_kid_counting_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	PFC01_3001 PFC02_3001 PFC01_5001 PFC02_5001
Dimensions	Following fields can be used for applying filtering and ordering the data. AreaId (number) AreaName (string) BranchId (number) BranchName (string) CompanyId (number) CompanyName (string)
Body - JSON Example	{ "query": { "measures": [ "site_area_1h_kid_counting_data.PFC01_3001", "site_area_1h_kid_counting_data.PFC02_3001", "site_area_1h_kid_counting_data.PFC01_5001", "site_area_1h_kid_counting_data.PFC02_5001" ], "dimensions": [ "site_area_1h_kid_counting_data.CompanyId", "site_area_1h_kid_counting_data.CompanyName", "site_area_1h_kid_counting_data.BranchId", "site_area_1h_kid_counting_data.BranchName", "site_area_1h_kid_counting_data.AreaId", "site_area_1h_kid_counting_data.AreaName", "site_area_1h_kid_counting_data.AreaType" ], "filters": [ { "member": "site_area_1h_kid_counting_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] }, { "member": "site_area_1h_kid_counting_data.AreaId", "operator": "equals", "values": [ "33333", "44444" ] } ], "order": [ [ "site_area_1h_kid_counting_data.BranchId", "asc" ], [ "site_area_1h_kid_counting_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Example	{ ... "data": [ { "site_area_1h_kid_counting_data.CompanyId": 12345, "site_area_1h_kid_counting_data.CompanyName": "DemoCompany", "site_area_1h_kid_counting_data.BranchId": 11111, "site_area_1h_kid_counting_data.BranchName": "DemoBranch", "site_area_1h_kid_counting_data.AreaId": 33333, "site_area_1h_kid_counting_data.AreaName": "DemoArea", "site_area_1h_kid_counting_data.AreaType": 1, "site_area_1h_kid_counting_data.PFC01_3001": 5422, "site_area_1h_kid_counting_data.PFC02_3001": 5420, "site_area_1h_kid_counting_data.PFC01_5001": 12532, "site_area_1h_kid_counting_data.PFC02_5001": 12529 }, { "site_area_1h_kid_counting_data.CompanyId": 12345, "site_area_1h_kid_counting_data.CompanyName": "DemoCompany", "site_area_1h_kid_counting_data.BranchId": 22222, "site_area_1h_kid_counting_data.BranchName": "DemoBranch", "site_area_1h_kid_counting_data.AreaId": 44444, "site_area_1h_kid_counting_data.AreaName": "DemoArea", "site_area_1h_kid_counting_data.AreaType": 1, "site_area_1h_kid_counting_data.PFC01_3001": 5428, "site_area_1h_kid_counting_data.PFC02_3001": 5315, "site_area_1h_kid_counting_data.PFC01_5001": 35147, "site_area_1h_kid_counting_data.PFC02_5001": 32362 } ], ... }

site_area_wifi_counting_metric_day_data

Description	Store site wifi counting data
Cube Name	site_area_wifi_counting_metric_day_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	Available metrics for this cube PWA01 SWA02 PWA03 SWA04 SWA06
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T00:00:00.000", "2021-10-03T00:00" BranchId (string) BranchName (string) CompanyId (string) CompanyName (string)
Body - JSON Examples	{ "queryType": "multi", "query": { "measures": [ "site_area_wifi_counting_metric_day_data.PWA01", "site_area_wifi_counting_metric_day_data.SWA02", "site_area_wifi_counting_metric_day_data.PWA03", "site_area_wifi_counting_metric_day_data.SWA04", "site_area_wifi_counting_metric_day_data.SWA06" ], "dimensions": [ "site_area_wifi_counting_metric_day_data.Time", "site_area_wifi_counting_metric_day_data.BranchId", "site_area_wifi_counting_metric_day_data.BranchName", "site_area_wifi_counting_metric_day_data.CompanyId", "site_area_wifi_counting_metric_day_data.CompanyName" ], "filters": [ { "member": "site_area_wifi_counting_metric_day_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "site_area_wifi_counting_metric_day_data.BranchId", "asc" ], [ "site_area_wifi_counting_metric_day_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON EXamples	{ ... "data": [ { "site_area_wifi_counting_metric_day_data.Time": "2022-01-01T00:00:00.000", "site_area_wifi_counting_metric_day_data.BranchId": 11111, "site_area_wifi_counting_metric_day_data.BranchName": "DemoBranch", "site_area_wifi_counting_metric_day_data.CompanyId": 12345, "site_area_wifi_counting_metric_day_data.CompanyName": "DemoCompany", "site_area_wifi_counting_metric_day_data.PWA01": 204, "site_area_wifi_counting_metric_day_data.SWA02": 1.22, "site_area_wifi_counting_metric_day_data.PWA03": 23.12, "site_area_wifi_counting_metric_day_data.SWA04": 0.2367, "site_area_wifi_counting_metric_day_data.SWA06": 0.7633 }, { "site_area_wifi_counting_metric_day_data.Time": "2022-01-02T00:00:00.000", "site_area_wifi_counting_metric_day_data.BranchId": 11111, "site_area_wifi_counting_metric_day_data.BranchName": "DemoBranch", "site_area_wifi_counting_metric_day_data.CompanyId": 12345, "site_area_wifi_counting_metric_day_data.CompanyName": "DemoCompany", "site_area_wifi_counting_metric_day_data.PWA01": 137, "site_area_wifi_counting_metric_day_data.SWA02": 4.16, "site_area_wifi_counting_metric_day_data.PWA03": 15.18, "site_area_wifi_counting_metric_day_data.SWA04": 0.1418, "site_area_wifi_counting_metric_day_data.SWA06": 0.8582 } ], ... }

site_area_wifi_counting_metric_hour_data

Description	Store site wifi counting data
Cube Name	site_area_wifi_counting_metric_hour_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube PWA01 SWA02
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" BranchId (string) BranchName (string) CompanyId (string) CompanyName (string)
Body - JSON Examples	{ "query": { "measures": [ "site_area_wifi_counting_metric_hour_data.PWA01", "site_area_wifi_counting_metric_hour_data.SWA02" ], "dimensions": [ "site_area_wifi_counting_metric_hour_data.Time", "site_area_wifi_counting_metric_hour_data.BranchId", "site_area_wifi_counting_metric_hour_data.BranchName", "site_area_wifi_counting_metric_hour_data.CompanyId", "site_area_wifi_counting_metric_hour_data.CompanyName" ], "filters": [ { "member": "site_area_wifi_counting_metric_hour_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "site_area_wifi_counting_metric_hour_data.BranchId", "asc" ], [ "site_area_wifi_counting_metric_hour_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "site_area_wifi_counting_metric_hour_data.Time": "2022-01-01T00:00:00.000", "site_area_wifi_counting_metric_hour_data.BranchId": 11111, "site_area_wifi_counting_metric_hour_data.BranchName": "DemoBranch", "site_area_wifi_counting_metric_hour_data.CompanyId": 12345, "site_area_wifi_counting_metric_hour_data.CompanyName": "DemoCompany", "site_area_wifi_counting_metric_hour_data.PWA01": 204, "site_area_wifi_counting_metric_hour_data.SWA02": 1.22 }, { "site_area_wifi_counting_metric_hour_data.Time": "2022-01-01T01:00:00.000", "site_area_wifi_counting_metric_hour_data.BranchId": 11111, "site_area_wifi_counting_metric_hour_data.BranchName": "DemoBranch", "site_area_wifi_counting_metric_hour_data.CompanyId": 12345, "site_area_wifi_counting_metric_hour_data.CompanyName": "DemoCompany", "site_area_wifi_counting_metric_hour_data.PWA01": 137, "site_area_wifi_counting_metric_hour_data.SWA02": 4.16 } ], ... }

site_1d_footfall_wifi_sales_data

Description	Store daily footfall data
Cube Name	site_1d_footfall_wifi_sales_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'day'. day, week, month, year
Measures	Available metrics for this cube PFC01_11 PFC27 PWA01 SWA02 SWA04 SWA06
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T00:00:00.000", "2021-10-01T00:00" BranchId (string) BranchName (string) CompanyId (string) CompanyName (string)
Body - JSON Examples	{ "query": { "measures": [ "site_1d_footfall_wifi_sales_data.PFC01_11", "site_1d_footfall_wifi_sales_data.PFC27", "site_1d_footfall_wifi_sales_data.PWA01", "site_1d_footfall_wifi_sales_data.SWA02", "site_1d_footfall_wifi_sales_data.SWA04", "site_1d_footfall_wifi_sales_data.SWA06" ], "dimensions": [ "site_1d_footfall_wifi_sales_data.Time", "site_1d_footfall_wifi_sales_data.BranchId", "site_1d_footfall_wifi_sales_data.BranchName", "site_1d_footfall_wifi_sales_data.CompanyId", "site_1d_footfall_wifi_sales_data.CompanyName" ], "filters": [ { "member": "site_1d_footfall_wifi_sales_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "site_1d_footfall_wifi_sales_data.BranchId", "asc" ], [ "site_1d_footfall_wifi_sales_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "site_1d_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000", "site_1d_footfall_wifi_sales_data.BranchId": 11111, "site_1d_footfall_wifi_sales_data.BranchName": "DemoBranch", "site_1d_footfall_wifi_sales_data.CompanyId": 12345, "site_1d_footfall_wifi_sales_data.CompanyName": "DemoCompany", "site_1d_footfall_wifi_sales_data.PFC01_11": 2366, "site_1d_footfall_wifi_sales_data.PFC27": 1195.209, "site_1d_footfall_wifi_sales_data.PWA01": 649, "site_1d_footfall_wifi_sales_data.SWA02": 0.7847, "site_1d_footfall_wifi_sales_data.SWA04": 0.6124, "site_1d_footfall_wifi_sales_data.SWA06": 0.3876 }, { "site_1d_footfall_wifi_sales_data.Time": "2022-01-02T00:00:00.000", "site_1d_footfall_wifi_sales_data.BranchId": 11111, "site_1d_footfall_wifi_sales_data.BranchName": "DemoBranch", "site_1d_footfall_wifi_sales_data.CompanyId": 12345, "site_1d_footfall_wifi_sales_data.CompanyName": "DemoCompany", "site_1d_footfall_wifi_sales_data.PFC01_11": 2171, "site_1d_footfall_wifi_sales_data.PFC27": 937.0556, "site_1d_footfall_wifi_sales_data.PWA01": 861, "site_1d_footfall_wifi_sales_data.SWA02": 0.7160, "site_1d_footfall_wifi_sales_data.SWA04": 0.6106, "site_1d_footfall_wifi_sales_data.SWA06": 0.3894 } ], ... }

site_area_1h_customer_journeys

Description	Store hourly customer journeys
Cube Name	site_area_1h_customer_journeys
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube JourneyCount
Dimensions	Following fields can be used for applying filtering and ordering the data. DateTime (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchName (string) CompanyId (string) CompanyName Journey (string) JourneyIds (string)
Segments	Following segments can be used to query the corresponding data based on the granularity needed. IsAreaLevel ("true") IsSiteLevel ("true")
Body - JSON Exampels	{ "query": { "measures": [ "site_area_1h_customer_journeys.JourneyCount" ], "dimensions": [ "site_area_1h_customer_journeys.DateTime", "site_area_1h_customer_journeys.AreaId", "site_area_1h_customer_journeys.AreaName", "site_area_1h_customer_journeys.BranchId", "site_area_1h_customer_journeys.BranchName", "site_area_1h_customer_journeys.CompanyId", "site_area_1h_customer_journeys.CompanyName", "site_area_1h_customer_journeys.Journey", "site_area_1h_customer_journeys.JourneyIds" ], "segments" : [ "site_area_1h_customer_journeys.IsAreaLevel" ] "filters": [ { "member": "site_area_1h_customer_journeys.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "site_area_1h_customer_journeys.BranchId", "asc" ], [ "site_area_1h_customer_journeys.DateTime", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "site_area_1h_customer_journeys.DateTime": "2022-01-01T00:00:00.000", "site_area_1h_customer_journeys.AreaId": 13131, "site_area_1h_customer_journeys.AreaName": "DemoArea", "site_area_1h_customer_journeys.BranchId": 11111, "site_area_1h_customer_journeys.BranchName": "DemoBranch", "site_area_1h_customer_journeys.CompanyId": 12345, "site_area_1h_customer_journeys.CompanyName": "DemoCompany", "site_area_1h_customer_journeys.Journey": "DemoZone2", "site_area_1h_customer_journeys.JourneyIds": "[2]", "site_area_1h_customer_journeys.JourneyCount": 46 }, { "site_area_1h_customer_journeys.DateTime": "2022-01-01T00:00:00.000", "site_area_1h_customer_journeys.AreaId": 13131, "site_area_1h_customer_journeys.AreaName": "DemoArea", "site_area_1h_customer_journeys.BranchId": 11111, "site_area_1h_customer_journeys.BranchName": "DemoBranch", "site_area_1h_customer_journeys.CompanyId": 12345, "site_area_1h_customer_journeys.CompanyName": "DemoCompany", "site_area_1h_customer_journeys.Journey": "DemoZone1 -> DemoZone2", "site_area_1h_customer_journeys.JourneyIds": "[1,2]", "site_area_1h_customer_journeys.JourneyCount": 27 } ], ... }

site_area_1h_counting_data_ext

Description	Store hourly counting data and dwell time
Cube Name	site_area_1h_counting_data_ext
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube FC01_11 PFC27
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchName (string) CompanyId (string) CompanyName (string)
Segments	Following segments can be used to query the corresponding data based on the granularity needed. IsAreaLevel ("true") IsSiteLevel ("true")
Body - JSON Examples	{ "query": { "measures": [ "site_area_1h_counting_data_ext.FC01_11", "site_area_1h_counting_data_ext.PFC27" ], "dimensions": [ "site_area_1h_counting_data_ext.Time", "site_area_1h_counting_data_ext.AreaId", "site_area_1h_counting_data_ext.AreaName", "site_area_1h_counting_data_ext.BranchId", "site_area_1h_counting_data_ext.BranchName", "site_area_1h_counting_data_ext.CompanyId", "site_area_1h_counting_data_ext.CompanyName" ], "filters": [ { "member": "site_area_1h_counting_data_ext.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "site_area_1h_counting_data_ext.BranchId", "asc" ], [ "site_area_1h_counting_data_ext.Time", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "site_area_1h_counting_data_ext.Time": "2022-01-01T00:00:00.000", "site_area_1h_counting_data_ext.AreaId": 13131, "site_area_1h_counting_data_ext.AreaName": "DemoArea", "site_area_1h_counting_data_ext.BranchId": 11111, "site_area_1h_counting_data_ext.BranchName": "DemoBranch", "site_area_1h_counting_data_ext.CompanyId": 12345, "site_area_1h_counting_data_ext.CompanyName": "DemoCompany", "site_area_1h_counting_data_ext.FC01_11": 204, "site_area_1h_counting_data_ext.PFC27": 1320.34 }, { "site_area_1h_counting_data_ext.Time": "2022-01-01T01:00:00.000", "site_area_1h_counting_data_ext.AreaId": 13131, "site_area_1h_counting_data_ext.AreaName": "DemoArea", "site_area_1h_counting_data_ext.BranchId": 11111, "site_area_1h_counting_data_ext.BranchName": "DemoBranch", "site_area_1h_counting_data_ext.CompanyId": 12345, "site_area_1h_counting_data_ext.CompanyName": "DemoCompany", "site_area_1h_counting_data_ext.FC01_11": 137, "site_area_1h_counting_data_ext.PFC27": 1201.31 } ], ... }

area_1h_footfall_wifi_sales_data

Description	Store hourly area footfall WiFi counting data
Cube Name	area_1h_footfall_wifi_sales_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube PFC01_11 PFC27 PFH05
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchName (string) CompanyId (string) CompanyName (string) IsOperating (string)
Body - JSON Examples	{ "query": { "measures": [ "area_1h_footfall_wifi_sales_data.PFC01_11", "area_1h_footfall_wifi_sales_data.PFC27", "area_1h_footfall_wifi_sales_data.PFH05" ], "dimensions": [ "area_1h_footfall_wifi_sales_data.Time", "area_1h_footfall_wifi_sales_data.AreaId", "area_1h_footfall_wifi_sales_data.AreaName", "area_1h_footfall_wifi_sales_data.BranchId", "area_1h_footfall_wifi_sales_data.BranchName", "area_1h_footfall_wifi_sales_data.CompanyId", "area_1h_footfall_wifi_sales_data.CompanyName", "area_1h_footfall_wifi_sales_data.IsOperating" ], "filters": [ { "member": "area_1h_footfall_wifi_sales_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "area_1h_footfall_wifi_sales_data.BranchId", "asc" ], [ "area_1h_footfall_wifi_sales_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "area_1h_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000", "area_1h_footfall_wifi_sales_data.AreaId": 13131, "area_1h_footfall_wifi_sales_data.AreaName": "DemoArea", "area_1h_footfall_wifi_sales_data.BranchId": 11111, "area_1h_footfall_wifi_sales_data.BranchName": "DemoBranch", "area_1h_footfall_wifi_sales_data.CompanyId": 12345, "area_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany", "area_1h_footfall_wifi_sales_data.IsOperating": 1, "area_1h_footfall_wifi_sales_data.PFC01_11": 204, "area_1h_footfall_wifi_sales_data.PFC27": 1320.34, "area_1h_footfall_wifi_sales_data.PFH05": 19.7288 }, { "area_1h_footfall_wifi_sales_data.Time": "2022-01-01T01:00:00.000", "area_1h_footfall_wifi_sales_data.AreaId": 13131, "area_1h_footfall_wifi_sales_data.AreaName": "DemoArea", "area_1h_footfall_wifi_sales_data.BranchId": 11111, "area_1h_footfall_wifi_sales_data.BranchName": "DemoBranch", "area_1h_footfall_wifi_sales_data.CompanyId": 12345, "area_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany", "area_1h_footfall_wifi_sales_data.IsOperating": 0, "area_1h_footfall_wifi_sales_data.PFC01_11": 137, "area_1h_footfall_wifi_sales_data.PFC27": 1201.31, "area_1h_footfall_wifi_sales_data.PFH05": 21.4473 } ], ... }

area_1h_footfall_wifi_sales_data_new

Description	Store hourly area footfall WiFi counting data
Cube Name	area_1h_footfall_wifi_sales_data_new
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube VisitorIn
Dimensions	Following fields can be used for applying filtering and ordering the data. __time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" AreaId (string) AreaName (string) BranchId (string) BranchName (string) CompanyId (string) CompanyName (string) Dwelltime (float as string) IsOperating (string)
Body - JSON Examples	{ "query": { "measures": [ "area_1h_footfall_wifi_sales_data_new.VisitorIn" ], "dimensions": [ "area_1h_footfall_wifi_sales_data_new.__time", "area_1h_footfall_wifi_sales_data_new.AreaId", "area_1h_footfall_wifi_sales_data_new.AreaName", "area_1h_footfall_wifi_sales_data_new.BranchId", "area_1h_footfall_wifi_sales_data_new.BranchName", "area_1h_footfall_wifi_sales_data_new.CompanyId", "area_1h_footfall_wifi_sales_data_new.CompanyName", "area_1h_footfall_wifi_sales_data_new.Dwelltime", "area_1h_footfall_wifi_sales_data_new.IsOperating" ], "filters": [ { "member": "area_1h_footfall_wifi_sales_data_new.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "area_1h_footfall_wifi_sales_data_new.BranchId", "asc" ], [ "area_1h_footfall_wifi_sales_data_new.__time", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "area_1h_footfall_wifi_sales_data_new.__time": "2022-01-01T00:00:00.000", "area_1h_footfall_wifi_sales_data_new.AreaId": 13131, "area_1h_footfall_wifi_sales_data_new.AreaName": "DemoArea", "area_1h_footfall_wifi_sales_data_new.BranchId": 11111, "area_1h_footfall_wifi_sales_data_new.BranchName": "DemoBranch", "area_1h_footfall_wifi_sales_data_new.CompanyId": 12345, "area_1h_footfall_wifi_sales_data_new.CompanyName": "DemoCompany", "area_1h_footfall_wifi_sales_data_new.VisitorIn": 204, "area_1h_footfall_wifi_sales_data_new.Dwelltime": 1320.34, "area_1h_footfall_wifi_sales_data_new.IsOperating": 1 }, { "area_1h_footfall_wifi_sales_data_new.__time": "2022-01-01T01:00:00.000", "area_1h_footfall_wifi_sales_data_new.AreaId": 13131, "area_1h_footfall_wifi_sales_data_new.AreaName": "DemoArea", "area_1h_footfall_wifi_sales_data_new.BranchId": 11111, "area_1h_footfall_wifi_sales_data_new.BranchName": "DemoBranch", "area_1h_footfall_wifi_sales_data_new.CompanyId": 12345, "area_1h_footfall_wifi_sales_data_new.CompanyName": "DemoCompany", "area_1h_footfall_wifi_sales_data_new.VisitorIn": 137, "area_1h_footfall_wifi_sales_data_new.Dwelltime": 1201.31, "area_1h_footfall_wifi_sales_data_new.IsOperating": 0 } ], ... }

customer_journeys

Description	Store customer journeys
Cube Name	customer_journeys
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'second'. second, minute, hour, day, week, month, year
Measures	Available metrics for this cube Count
Dimensions	Following fields can be used for applying filtering and ordering the data. DateTime (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" BranchId (string) CompanyId (string) IsOperating (string) Journey (string) JourneyIds (string)
Body - JSON Examples	{ "query": { "measures": [ "customer_journeys.Count" ], "dimensions": [ "customer_journeys.DateTime", "customer_journeys.BranchId", "customer_journeys.CompanyId", "customer_journeys.IsOperating", "customer_journeys.Journey", "customer_journeys.JourneyIds" ], "filters": [ { "member": "customer_journeys.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "customer_journeys.BranchId", "asc" ], [ "customer_journeys.DateTime", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "customer_journeys.Time": "2022-01-01T00:00:00.000", "customer_journeys.BranchId": 11111, "customer_journeys.CompanyId": 12345, "customer_journeys.IsOperating": 1, "customer_journeys.Journey": "Cashier", "customer_journeys.JourneyIds": "[1]", "customer_journeys.Count": 1 }, { "customer_journeys.Time": "2022-01-01T01:00:00.000", "customer_journeys.BranchId": 11111, "customer_journeys.CompanyId": 12345, "customer_journeys.IsOperating": 0, "customer_journeys.Journey": "Fridge A -> Cashier", "customer_journeys.JourneyIds": "[2]", "customer_journeys.Count": 2 } ], ... }

site_1h_footfall_wifi_sales_data

Description	Store hourly footfall data
Cube Name	site_1h_footfall_wifi_sales_data
Time granularities	Following are available time granularities for this cube, minimum time granularity is 'hour'. hour, day, week, month, year
Measures	Available metrics for this cube PFC01_11 PFC27 PWA01 SWA02
Dimensions	Following fields can be used for applying filtering and ordering the data. Time (datetime as string) : Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" BranchId (string) BranchName (string) CompanyId (string) CompanyName (string)
Body - JSON Examples	{ "query": { "measures": [ "site_1h_footfall_wifi_sales_data.PFC01_11", "site_1h_footfall_wifi_sales_data.PFC27", "site_1h_footfall_wifi_sales_data.PWA01", "site_1h_footfall_wifi_sales_data.SWA02" ], "dimensions": [ "site_1h_footfall_wifi_sales_data.Time", "site_1h_footfall_wifi_sales_data.BranchId", "site_1h_footfall_wifi_sales_data.BranchName", "site_1h_footfall_wifi_sales_data.CompanyId", "site_1h_footfall_wifi_sales_data.CompanyName" ], "filters": [ { "member": "site_1h_footfall_wifi_sales_data.BranchId", "operator": "equals", "values": [ "11111", "22222" ] } ], "order": [ [ "site_1h_footfall_wifi_sales_data.BranchId", "asc" ], [ "site_1h_footfall_wifi_sales_data.Time", "asc" ] ], "limit": 10 } }
Response - JSON Examples	{ ... "data": [ { "site_1h_footfall_wifi_sales_data.Time": "2022-01-01T00:00:00.000", "site_1h_footfall_wifi_sales_data.BranchId": 11111, "site_1h_footfall_wifi_sales_data.BranchName": "DemoBranch", "site_1h_footfall_wifi_sales_data.CompanyId": 12345, "site_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany", "site_1h_footfall_wifi_sales_data.PFC01_11": 204, "site_1h_footfall_wifi_sales_data.PFC27": 1320.34, "site_1h_footfall_wifi_sales_data.PWA01": 649, "site_1h_footfall_wifi_sales_data.SWA02": 0.7847 }, { "site_1h_footfall_wifi_sales_data.Time": "2022-01-01T01:00:00.000", "site_1h_footfall_wifi_sales_data.BranchId": 11111, "site_1h_footfall_wifi_sales_data.BranchName": "DemoBranch", "site_1h_footfall_wifi_sales_data.CompanyId": 12345, "site_1h_footfall_wifi_sales_data.CompanyName": "DemoCompany", "site_1h_footfall_wifi_sales_data.PFC01_11": 2171, "site_1h_footfall_wifi_sales_data.PFC27": 937.0556, "site_1h_footfall_wifi_sales_data.PWA01": 861, "site_1h_footfall_wifi_sales_data.SWA02": 0.7160 } ], ... }

site_1h_counting_prediction

Description	Hourly historical footfall and predicted footfall for 14-day before and after the input date. For past dates, historical footfall and predicted footfall are returned to compare the accuracy. For future dates, only predicted footfall are returned, historical footfall are unknown. 56-day hourly historical data (minimum 14 days) are used to predict the next 14-day hourly footfall.
Cube Name	site_1h_counting_prediction
Time Granularities	Hour
Measures	Available metrics for this cube: PFC01 PFC01 Prediction (PFC23)
Dimensions	Following fields can be used for applying filtering and ordering the data. CompanyId (number) BranchId (string) BranchName (string) DayOfWeek (number) Time (datetime as string): Example "2021-10-01T10:00:00.000", "2021-10-01T10:00" StartDateTime (datetime as string) CurrentLocalTime (datetime as string) IsOperating (string)
Body - JSON Examples	{ "query": { "dimensions": [ "site_1h_counting_prediction.CompanyId", "site_1h_counting_prediction.BranchId", "site_1h_counting_prediction.BranchName", "site_1h_counting_prediction.DayOfWeek", "site_1h_counting_prediction.Time", "site_1h_counting_prediction.StartDateTime", "site_1h_counting_prediction.CurrentLocalTime", "site_1h_counting_prediction.IsOperating", "site_1h_counting_prediction.PFC01", "site_1h_counting_prediction.PFC01_Prediction" ], "filters": [ { "member": "site_1h_counting_prediction.BranchId", "operator": "equals", "values": [ "11111" ] }, { "member": "site_1h_counting_prediction.StartDateTime", "operator": "equals", "values": [ "2024-03-11" ] }, { "member": "site_1h_counting_prediction.IsOperating", "operator": "equals", "values": [ "1" ] } ], "order": [ [ "site_1h_counting_prediction.Time", "asc" ] ], "limit": 50000, "renewQuery": "TRUE" } }
Response - JSON Examples	{ ... "data": [ { "site_1h_counting_prediction.CompanyId": 12345, "site_1h_counting_prediction.BranchId": 11111, "site_1h_counting_prediction.BranchName": "DemoBranch", "site_1h_counting_prediction.DayOfWeek": 1, "site_1h_counting_prediction.Time": "2024-02-26T09:00:00.000", "site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000", "site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000", "site_1h_counting_prediction.IsOperating": "1", "site_1h_counting_prediction.PFC01": 7, "site_1h_counting_prediction.PFC01_Prediction": 24 }, ... { "site_1h_counting_prediction.CompanyId": 12345, "site_1h_counting_prediction.BranchId": 11111, "site_1h_counting_prediction.BranchName": "DemoBranch", "site_1h_counting_prediction.DayOfWeek": 1, "site_1h_counting_prediction.Time": "2024-03-11T09:00:00.000", "site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000", "site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000", "site_1h_counting_prediction.IsOperating": "1", "site_1h_counting_prediction.PFC01": 22, "site_1h_counting_prediction.PFC01_Prediction": 15 }, ... { "site_1h_counting_prediction.CompanyId": 12345, "site_1h_counting_prediction.BranchId": 11111, "site_1h_counting_prediction.BranchName": "DemoBranch", "site_1h_counting_prediction.DayOfWeek": 7, "site_1h_counting_prediction.Time": "2024-03-24T18:00:00.000", "site_1h_counting_prediction.StartDateTime": "2024-03-11T00:00:00.000", "site_1h_counting_prediction.CurrentLocalTime": "2024-03-11T16:05:58.000", "site_1h_counting_prediction.IsOperating": "1", "site_1h_counting_prediction.PFC01": null, "site_1h_counting_prediction.PFC01_Prediction": 288 } ], ... }

Updated on March 15, 2024