Saltar al contenido

Integre SAP IoT con SAP Analytics Cloud

Uso de la definición de caso: en función de las necesidades comerciales, el usuario puede configurar las dimensiones y medidas en función de los tipos de conjuntos de propiedades disponibles en el modelo de objetos.

Configuremos un gráfico en SAP Analytics Cloud para mapear la temperatura promedio de cada silo durante los últimos 7 días de datos en los que los datos se agregan diariamente.

Modelo de datos de muestra con agregados diarios en los últimos 7 días:


{ "Name": "TrainingModelXX", "AggregationWindow": "DAILY", "TimeWindowIdentifier": "day", "TimeWindowValue": 7, "Descriptions": [ { "Description": "Daily Silo Temperature Analysis XX", "LanguageCode": "en" } ], "Fields": [ { "FriendlyName": "EQUI", "AnalyticType": "Dimension", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_process_data", "DatasetType": "MasterData", "Name": "EQUI" }, { "FriendlyName": "HANU", "AnalyticType": "Dimension", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_process_data", "DatasetType": "MasterData", "Name": "HANU" }, { "FriendlyName": "HumidityMAX", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "humidity", "AggregationType": "MAX" }, { "FriendlyName": "HumidityMIN", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "humidity", "AggregationType": "MIN" }, { "FriendlyName": "HumidityCOUNT", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "humidity", "AggregationType": "COUNT" }, { "FriendlyName": "HumiditySUM", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "humidity", "AggregationType": "SUM" }, { "FriendlyName": "TemperatureMAX", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "temperature", "AggregationType": "MAX" }, { "FriendlyName": "TemperatureMIN", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "temperature", "AggregationType": "MIN" }, { "FriendlyName": "TemperatureCOUNT", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "temperature", "AggregationType": "COUNT" }, { "FriendlyName": "TemperatureSUM", "AnalyticType": "Measure", "CatalogName": "{{TenantPackageNamespace}}.{{PackageName}}:silo_type_1", "CatalogType": "ThingType", "DatasetName": "silo_status", "DatasetType": "TimeSeriesData", "Name": "temperature", "AggregationType": "SUM" } ] }

Este modelo tiene una medida de serie de tiempo y dimensión configurada para sus propiedades. “Temperatura” con todos los agregados posibles: SUM, COUNT, MIN, MAX. Actualmente, puede configurar agregados por medidas, pero no por dimensiones.