Hybrid connectivity for reporting application

Patent metadata

Field	Value
Publication number	US-10817570-B2
Application number	US-201715834411-A
Country	US
Kind code	B2
Filing date	Dec 7, 2017
Priority date	Dec 7, 2017
Publication date	Oct 27, 2020
Grant date	Oct 27, 2020

Abstract

A system includes reception of a first user instruction to access a dataset stored in a data source, retrieval of metadata of the dataset from the data source in response to the first user instruction, the metadata defining a plurality of dimensions and measures associated with the dataset, reception of a second user instruction to associate a first one of the plurality of dimensions and measures with a first visualization, determination of a first one or more dimensions or measures associated with the first one of the plurality of dimensions and measures, retrieval, from the data source, of data of the dataset associated with the determined first one or more dimensions or measures and the first one of the plurality of dimensions and measures, updating of the first visualization based on the retrieved data, and display the updated first visualization on a display.

First claim

What is claimed is:

1. A system comprising:
a display;
a memory storing processor-executable process steps of a client application; and
a processor to execute processor-executable process steps of the client application to:
receive a first user instruction to access a dataset stored in a data source;
retrieve metadata of the dataset from the data source, the metadata defining a plurality of dimensions and measures associated with the dataset;
receive a second user instruction to associate a first one of the plurality of dimensions and measures with a first visualization;
determine a first one or more dimensions or measures associated with the first one of the plurality of dimensions and measures;
retrieve, from the data source, data of the dataset associated with the determined first one or more dimensions or measures and the first one of the plurality of dimensions and measures;
update the first visualization based on the retrieved data;
display the updated first visualization on the display;
receive a third user instruction to save the first visualization in the memory;
in response to the third user instruction, store a document comprising visualization metadata in the memory, the visualization metadata defining the first visualization and indicating the dataset;
receive a fourth user instruction to open the document;
in response to the fourth user instruction, query the data source for second data from the dataset associated with the visualization metadata;
receive the second data;
update the first visualization based on the second data; and
display the first visualization updated based on the second data.

2. The system according to claim 1 , wherein determination of the first one or more dimensions or measures comprises:
determination of the first one or more dimensions or measures based on usage data stored in the memory.

3. The system according to claim 2 , the processor to further execute processor-executable process steps of the client application to:
update the usage data based on the second user instruction to associate the first one of the plurality of dimensions and measures with the first visualization.

4. The system according to claim 1 , wherein determination of the first one or more dimensions or measures comprises:
determination of the first one or more dimensions or measures based a repository of column associations stored in the memory.

5. The system according to claim 1 , the processor to further execute processor-executable process steps of the client application to:
receive a fifth user instruction to associate a second one of the plurality of dimensions and measures with the first visualization;
determine a second one or more dimensions or measures associated with the second one of the plurality of dimensions and measures;
retrieve, from the data source, third data of the dataset associated with the determined second one or more dimensions or measures and the second one of the plurality of dimensions and measures; and
update the first visualization based on the retrieved third data; and
display, on the display, the first visualization updated based on the retrieved third data.

6. The system according to claim 1 , the processor to further execute processor-executable process steps of the client application to:
receive a sixth user instruction to modify the metadata of the dataset to define a calculated measure; and
store the modified metadata of the dataset in the memory.

7. The system according to claim 6 , the processor to further execute processor-executable process steps of the client application to:
receive a seventh user instruction to associate the calculated measure with the first visualization; and
store the document including metadata defining the first visualization in the memory.

8. A computer-implemented method for a client application executing on a client device, the method comprising:
receiving a first user instruction to access a dataset stored in a data source;
retrieving metadata of the dataset from the data source in response to the first user instruction, the metadata defining a plurality of dimensions and measures associated with the dataset;
receiving a second user instruction to associate a first one of the plurality of dimensions and measures with a first visualization;
determining a first one or more dimensions or measures associated with the first one of the plurality of dimensions and measures;
retrieving, from the data source, data of the dataset associated with the determined first one or more dimensions or measures and the first one of the plurality of dimensions and measures;
updating the first visualization based on the retrieved data;
displaying the updated first visualization on a display;
receiving a third user instruction to save the first visualization in the memory;
in response to the third user instruction, storing a document comprising visualization metadata in the memory, the visualization metadata defining the first visualization and indicating the dataset;
receiving a fourth user instruction to open the document;
in response to the fourth user instruction, querying the data source for second data from the dataset associated with the visualization metadata;
receiving the second data; and
displaying the first visualization updated with the second data.

9. The method according to claim 8 , wherein determining the first one or more dimensions or measures comprises:
determining the first one or more dimensions or measures based on usage data stored in a memory.

10. The method according to claim 9 , further comprising:
updating the usage data based on the second user instruction to associate the first one of the plurality of dimensions and measures with the first visualization.

11. The method according to claim 8 , wherein determining the first one or more dimensions or measures comprises:
determining the first one or more dimensions or measures based a repository of column associations stored in a memory.

12. The method according to claim 8 , further comprising:
receiving a fifth user instruction to associate a second one of the plurality of dimensions and measures with the first visualization;
determining a second one or more dimensions or measures associated with the second one of the plurality of dimensions and measures;
retrieving, from the data source, third data of the dataset associated with the determined second one or more dimensions or measures and the second one of the plurality of dimensions and measures; and
updating the first visualization based on the retrieved third data; and
displaying, on the display, the first visualization updated based on the retrieved third data.

13. The method according to claim 8 , further comprising:
receiving a sixth user instruction to modify the metadata of the dataset to define a calculated measure; and
storing the modified metadata of the dataset in a memory.

14. The method according to claim 13 , further comprising:
receiving a seventh user instruction to associate the calculated measure with the first visualization; and
storing the document including metadata defining the first visualization in a memory.

15. A non-transitory computer-readable medium storing computer-executable process steps which, when executed by a computing device, cause the computing device to:
receive a first user instruction to access a dataset stored in a data source;
retrieve metadata of the dataset from the data source in response to the first user instruction, the metadata defining a plurality of dimensions and measures associated with the da

Assignees

• Sap Se

Inventors

• Mavinakuli Prasanna Bhat
• Gupta Shanu
• Jain Nikita

Classifications

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/904

  Browsing; Visualisation therefor (for navigating the web G06F16/954; browsing optimisation for the web G06F16/957) · CPC title

• G06F16/907 Primary

  Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually · CPC title

• G06F16/9024

  Graphs; Linked lists (G06F16/9027 takes precedence) · CPC title