Hybrid connectivity for reporting application

Patent metadata

Field	Value
Publication number	US-2019179972-A1
Application number	US-201715834411-A
Country	US
Kind code	A1
Filing date	Dec 7, 2017
Priority date	Dec 7, 2017
Publication date	Jun 13, 2019
Grant date	—

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; and display the updated first visualization on the display.

2 . A 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 . A 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 . A 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 . A system according to claim 1 , the processor to further execute processor-executable process steps of the client application to:
receive a third 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, second 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 second data; and display, on the display, the first visualization updated based on the retrieved second data.

6 . A system according to claim 1 , the processor to further execute processor-executable process steps of the client application to:
receive a third 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 . A system according to claim 6 , the processor to further execute processor-executable process steps of the client application to:
receive a fourth user instruction to associate the calculated measure with the first visualization; and store a document including metadata defining the first visualization in the memory.

8 . A system according to claim 1 , the processor to further execute processor-executable process steps of the client application to:
receive a third user instruction to save the visualization in the memory; in response to the third 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.

9 . 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; and displaying the updated first visualization on a display.

10 . A method according to claim 9 , 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.

11 . A method according to claim 10 , 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.

12 . A method according to claim 9 , 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.

13 . A method according to claim 9 , further comprising:
receiving a third 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, second 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 second data; and displaying, on the display, the first visualization updated based on the retrieved second data.

14 . A method according to claim 9 , further comprising:
receiving a third 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.

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

16 . A method according to claim 9 , further comprising:
receiving a third user instruction to save the visualization in the memory; in response to the third 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.

17 . A computer-readable medium storing computer-executable process steps which, when executed by a computing device, cause the computing device to:
receive a first user instru

Assignees

• Sap Se

Inventors

• Mavinakuli Prasanna Bhat
• Gupta Shanu
• Jain Nikita

Classifications

• G06F17/30994

  Physics · mapped topic

• G06F17/30997 Primary

  Physics · mapped topic

• G06F17/30958

  Physics · mapped topic

• G06F16/248 Primary

  Presentation of query results · CPC title

• G06F16/907 Primary

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