Dimension-specific dynamic text interface for data analytics

Patent metadata

Field	Value
Publication number	US-11314796-B2
Application number	US-201916708101-A
Country	US
Kind code	B2
Filing date	Dec 9, 2019
Priority date	Dec 9, 2019
Publication date	Apr 26, 2022
Grant date	Apr 26, 2022

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.

First claim

What is claimed is:

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.

Assignees

• Business Objects Ltd Ltd
• Sap Se

Inventors

• Qiu Xin
• Cheng Ivan
• Lloyd James

Classifications

• G06F16/83

  Querying · CPC title

• G06F16/953

  Querying, e.g. by the use of web search engines · CPC title

• G06F16/9538

  Presentation of query results · CPC title

• G06F16/835

  Query processing · CPC title

• G06F16/338

  Presentation of query results · CPC title