IP Library Granted Patent US 11,314,796
Granted Patent B2
US 11,314,796 · App. 16/708,101 · Granted Apr 26, 2022

Dimension-specific dynamic text interface for data analytics

Inventors: Xin Qiu (Vancouver, CA); Ivan Cheng (Vancouver, CA); James Lloyd (Vancouver, CA)
Assignee: SAP SE
G06F16/3346G06F16/337G06F16/338G06F16/83G06F16/835G06F16/8373G06F16/953G06F16/9538
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,314,796
App. No.
16/708,101
Granted
Apr 26, 2022
Kind
B2
Abstract

Embodiments relate to a dynamic text provider that generates and communicates a text object to a text consumer (e.g., a table with a text header, a chart having text axis labels and/or title). An engine is positioned between a dynamic text service, and an underlying data set organized according to a model with hierarchical elements (e.g., measures, dimensions, pages). The engine receives an input from the text consumer. The input includes at least a first identifier of the text consumer, a second identifier of the data set, and a third identifier of a specific element (e.g., dimension) of the model. The engine references the model to create a context. Based upon that context, the engine queries the data set to generate a dynamic text object including a list of values (LOV) for the dimension. The dynamic text object including the LOV is communicated to the text consumer.

Claims (61)

1. A computer-implemented method comprising:

receiving from a text consumer via a text service, a first input including,

a first identifier of the text consumer,

a second identifier of a data set stored in a database and organized according to a model, and

a third identifier of a dimension in the data set;

in response to the first input, an engine referencing the model defining a story-dimension hierarchy including the dimension, to provide a context;

the engine creating a query based upon the context;

the engine issuing the query to the data set;

the engine receiving a query result comprising a list of values for the dimension;

the engine generating a first dynamic text object including the query result;

the engine communicating the first dynamic text object to the text consumer via the text service;

the engine receiving a broadcast update event;

in response to the broadcast update event, the engine generating a second dynamic text object comprising an updated list of values from the data set;

in response to an updated input received from the text consumer via the text service, the engine communicating the second dynamic text object;

receiving from the text consumer via the text service, a second input including a story filter; and

in response to the second input, bypassing the engine to return a relevant story from the model, wherein:

the first input further comprises a first configuration option selecting a specific level of the hierarchy, and a second configuration option specifying whether or not to show a hierarchy path; and

the first dynamic text object is generated according to the first configuration option and the second configuration option.

2. A method as in claim 1 wherein the updated input is triggered by the text consumer receiving an additional broadcast event.

3. A method as in claim 1 wherein:

the database comprises an in-memory database; and

the dynamic text object is generated by an in-memory database engine of the in-memory database.

4. A non-transitory computer readable storage medium embodying a computer program for performing a method, said method comprising:

receiving from a text consumer via a text service, first input including,

a first identifier of the text consumer,

a second identifier of a data set stored in a database and organized according to a model, and

a third identifier of a dimension in the data set;

in response to the first input, an engine referencing the model defining a story-dimension hierarchy including the dimension, to provide a context;

the engine creating a query based upon the context;

the engine issuing the query to the dataset;

the engine receiving a query result comprising a list of values for the dimension;

the engine generating a first dynamic text object including the query result;

the engine communicating the first dynamic text object to the text consumer via the text service;

the engine receiving a broadcast update event broadcast;

in response to the broadcast update event, generating a second dynamic text object comprising an updated list of values from the data set;

in response to an updated input received from the text consumer via the text service, the engine communicating the second dynamic text object;

receiving from the text consumer via the text service, a second input including a story filter; and

in response to the second input, bypassing the engine to return a relevant story from the model, wherein:

the first input further comprises a first configuration option selecting a specific level of the hierarchy, and a second configuration option specifying whether or not to show a hierarchy path; and

the first dynamic text object is generated according to the first configuration option and the second configuration option.

5. A non-transitory computer readable storage medium as in claim 4 wherein the updated input is triggered by the text consumer receiving an additional event.

6. A computer system comprising:

one or more processors;

a software program, executable on said computer system, the software program configured to cause an in-memory database engine of an in-memory database to:

receive from a text consumer via a text service, an input including,

a first identifier of the text consumer,

a second identifier of a data set stored in a database and organized according to a model, and

a third identifier of a dimension in the data set;

in response to the input, reference the model defining a story-dimension hierarchy including the dimension, to provide a context;

create a query based upon the context;

issue the query to the dataset;

receive a query result comprising a list of values for the dimension;

generating a first dynamic text object including the query result;

communicating the first dynamic text object to the text consumer via the text service;

receiving a broadcast update event;

in response to the broadcast update event, the in-memory database engine generating a second dynamic text object comprising an updated list of values from the data set; and

in response to an updated input received from the text consumer via the text service, the in-memory database engine communicating the second dynamic text object;

wherein the engine is bypassed in returning a relevant story from the model in response to a story filter input received from a user interface, wherein:

the first input further comprises a first configuration option selecting a specific level of the hierarchy, and a second configuration option specifying whether or not to show a hierarchy path; and

the first dynamic text object is generated according to the first configuration option and the second configuration option.

7. A computer system as in claim 6 wherein the updated input is triggered by the text consumer receiving an additional event.

Assignments (2)
CHANGE OF NAME Recorded Jan 26, 2026
From: BUSINESS OBJECTS SOFTWARE LIMITED
To: SAP IRELAND LIMITED
Reel/Frame 074510/0354 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 4, 2022
From: QIU, XIN; CHENG, IVAN; LLOYD, JAMES
To: BUSINESS OBJECTS SOFTWARE LTD
Reel/Frame 058545/0661 →
Continuity (1)
Related Publication 20210173861A1 · Jun 10, 2021