公开(公告)号：US20170357693A1

公开(公告)日：2017-12-14

申请号：US15182374

申请日：2016-06-14

Applicant: SAP SE

Inventor： Viren Kumar ,  Amir Hajizadeh

IPC: G06F17/30 ,  G06F3/0484 ,  G06T11/20

CPC classification number: G06T11/206 ,  G06F16/24556 ,  G06F16/248 ,  G06T11/00 ,  G06T2200/24

Abstract: Overlay visualizations are implemented utilizing data of a data layer. A table comprises a measure and two or more different dimensions mapping to a same value range. For visualization, the measure for those dimensions may be plotted along a common axis in a same chart. Accordingly, a query executes a UNION of multiple subqueries. A first subquery aggregates the first dimension over the value range, injecting a constant formula field to identify the original first dimension. A second subquery aggregates the second dimension over the value range, again injecting the constant formula field to identify the original second dimension. UNION of these subquery results presents one larger dataset for input to the overlying visualization layer. The constant formula field may be relied upon to differentiate between the combined dimensions on the common axis, allowing association of the measure values with the original dimensions in the displayed plot (e.g., via coloring).

公开(公告)号：US20180173707A1

公开(公告)日：2018-06-21

申请号：US15382920

申请日：2016-12-19

Applicant: SAP SE

Inventor： Teresa Su ,  Jan Rittinger ,  Amir Hajizadeh

IPC: G06F17/30

CPC classification number: G06F16/252 ,  G06F16/242 ,  G06F16/2455 ,  G06F16/248

Abstract: A system includes determination of a query context comprising a measure and one or more dimension values of a data source, generation of a query of the data source for the measure over time and aggregated over the one or more dimension values, reception of a result set of the query, providing of the result set to a predictive analysis engine, and reception of forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values.

公开(公告)号：US20170357679A1

公开(公告)日：2017-12-14

申请号：US15182399

申请日：2016-06-14

Applicant: SAP SE

Inventor： Viren Kumar ,  Amir Hajizadeh

IPC: G06F17/30 ,  G06F3/0484 ,  G06F17/27 ,  G06F21/62 ,  G06T11/20

CPC classification number: G06F16/23 ,  G06F16/22 ,  G06F16/245 ,  G06F21/62 ,  G06T11/206

Abstract: Embodiments implement contextual styling of chart elements based upon metadata stored in the data layer associated with chart data. In creating a chart for the associated data, a visualization engine references the metadata to render appearance of a chart element according to the relevant metadata. This maintains consistent appearance of chart elements depicting the same data, across different chart types (e.g., bar chart and pie chart). The metadata may be stored in the data layer as a JavaScript Object Notation (JSON) object, together with a corresponding identifier (e.g., representing a unique —story/-page/-chart/-chart element combination). Metadata within the data layer may determine appearance of chart data, chart axes, chart legends, and/or chart borders. The visualization engine may consult precedence rules governing application of different metadata (e.g., as between the appearance of a dimension vs. the appearance of a specific tuple including that dimension).

公开(公告)号：US10529099B2

公开(公告)日：2020-01-07

申请号：US15182374

申请日：2016-06-14

Applicant: SAP SE

Inventor： Viren Kumar ,  Amir Hajizadeh

IPC: G06F16/30 ,  G06T11/20 ,  G06F16/248 ,  G06F16/2455

Abstract: Overlay visualizations are implemented utilizing data of a data layer. A table comprises a measure and two or more different dimensions mapping to a same value range. For visualization, the measure for those dimensions may be plotted along a common axis in a same chart. Accordingly, a query executes a UNION of multiple subqueries. A first subquery aggregates the first dimension over the value range, injecting a constant formula field to identify the original first dimension. A second subquery aggregates the second dimension over the value range, again injecting the constant formula field to identify the original second dimension. UNION of these subquery results presents one larger dataset for input to the overlying visualization layer. The constant formula field may be relied upon to differentiate between the combined dimensions on the common axis, allowing association of the measure values with the original dimensions in the displayed plot (e.g., via coloring).

公开(公告)号：US10380134B2

公开(公告)日：2019-08-13

申请号：US15382920

申请日：2016-12-19

Applicant: SAP SE

Inventor： Teresa Su ,  Jan Rittinger ,  Amir Hajizadeh

IPC: G06F17/30 ,  G06F16/25 ,  G06F16/242 ,  G06F16/248 ,  G06F16/2455

Abstract: A system includes determination of a query context comprising a measure and one or more dimension values of a data source, generation of a query of the data source for the measure over time and aggregated over the one or more dimension values, reception of a result set of the query, providing of the result set to a predictive analysis engine, and reception of forecast data based on the result set, the forecast data comprising forecast values of the measure over time, aggregated over the one or more dimension values.