Traversing hierarchical dimensions for dimension-based visual elements

Patent metadata

Field	Value
Publication number	US-11275792-B2
Application number	US-201916671997-A
Country	US
Kind code	B2
Filing date	Nov 1, 2019
Priority date	Nov 1, 2019
Publication date	Mar 15, 2022
Grant date	Mar 15, 2022

Abstract

Some embodiments provide a non-transitory machine-readable medium that stores a program executable by at least one processing unit of a device. The program renders a visualization that includes a first set of visual elements. The program further receives a request for measure values categorized according to the first level of dimension values in the first hierarchy of dimension values and a second level of dimension values in the second hierarchy of dimension values. The program also generates a query for a second set of data from the dataset. The program further sends the query to a computing system configured to manage the dataset. The program also receives the second set of data from the computing system. The program further renders a second set of visual elements. The program also replaces the first set of visual elements in the visualization with the second set of visual elements.

First claim

What is claimed is:

1. A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:
rendering, based on a first set of data from a dataset, a visualization comprising a first set of visual elements, each visual element in the first set of visual elements configured to present a first set of measure values for a measure in the first set of data categorized according to a first level of dimension values in a first hierarchy of dimension values defined for a first dimension in the first set of data and a first level of dimension values in a second hierarchy of dimension values defined for a second dimension in the first set of data;
receiving a request for measure values categorized according to the first level of dimension values in the first hierarchy of dimension values and a second level of dimension values in the second hierarchy of dimension values, wherein the second level of dimension values in the second hierarchy of dimension values is lower than the first level of dimension values in the second hierarchy of dimension values;
generating a query for a second set of data from the dataset, the second set of data comprising the measure in the set of measures categorized according to the first level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values;
sending the query to a computing system configured to manage the dataset;
receiving the second set of data from the computing system;
rendering a second set of visual elements, each visual element in the second set of visual elements configured to present a second set of measure values for the measure in the second set of data categorized according to the first level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values; and
replacing the first set of visual elements in the visualization with the second set of visual elements.

2. The non-transitory machine-readable medium of claim 1 , wherein the request is a first request, wherein the query is a first query, wherein the program further comprises sets of instructions for:
receiving a second request for measure values categorized according to a second level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values, wherein the second level of dimension values in the first hierarchy of dimension values is lower than the first level of dimension values in the first hierarchy of dimension values;
generating a second query for a third set of data from the dataset, the third set of data comprising the measure in the set of measures categorized according to the second level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values;
sending the second query to the computing system;
receiving the third set of data from the computing system;
rendering a third set of visual elements, each visual element in the third set of visual elements configured to present a third set of measure values for the measure in the third set of data categorized according to the second level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values; and
replacing the second set of visual elements in the visualization with the third set of visual elements.

3. The non-transitory machine-readable medium of claim 1 , wherein the query is a first query, wherein the program further comprises a set of instructions for, before rendering the visualization, generating a second query for the first set of data from the dataset, the dataset comprising a set of measures and a plurality of dimensions for categorizing the set of measures, the first set of data comprising the measure in the set of measures categorized according to the first dimension in the plurality of dimensions and the second dimension in the plurality of dimensions.

4. The non-transitory machine-readable medium of claim 1 , wherein each visual element in the second set of visual elements is configured to present the second set of measure values for the measure in the second set of data categorized according to the first level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values in the form of a pie chart.

5. The non-transitory machine-readable medium of claim 4 , wherein the program further comprises sets of instructions for:
detecting a pointer hovering over a particular visual element in the set of visual elements for defined threshold amount of time; and
in response to the detection, providing for the particular visual element a display area configured to present the second set of measure values for the measure in the second set of data categorized according to the first level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values in the form of a table.

6. The non-transitory machine-readable medium of claim 1 , wherein receiving the request comprises:
receiving a selection of a dimension value in the first level of dimension values in the second hierarchy of dimension values; and
receiving a request to drill down on the second hierarchy of dimension values from the dimension value in the first level of dimension values in the second hierarchy of dimension values.

7. The non-transitory machine-readable medium of claim 1 , wherein the dataset comprises a set of measures and a plurality of dimensions for categorizing the set of measures, the first set of data comprising a measure in the set of measures categorized according to a first dimension in the plurality of dimensions and a second dimension in the plurality of dimensions.

8. A method comprising:
rendering, based on a first set of data from a dataset, a visualization comprising a first set of visual elements, each visual element in the first set of visual elements configured to present a first set of measure values for a measure in the first set of data categorized according to a first level of dimension values in a first hierarchy of dimension values defined for a first dimension in the first set of data and a first level of dimension values in a second hierarchy of dimension values defined for a second dimension in the first set of data;
receiving a request for measure values categorized according to the first level of dimension values in the first hierarchy of dimension values and a second level of dimension values in the second hierarchy of dimension values, wherein the second level of dimension values in the second hierarchy of dimension values is lower than the first level of dimension values in the second hierarchy of dimension values;
generating a query for a second set of data from the dataset, the second set of data comprising the measure in the set of measures categorized according to the first level of dimension values in the first hierarchy of dimension values and the second level of dimension values in the second hierarchy of dimension values;
sending the query to a computing system configured to manage the dataset;
receiving the second set of data from the computing system;
rendering a second set of visual elements, each visual element in the second set of visual elements configured to present a second set of measure values for the measure in the second set of data categorized according to the first level of dimen

Assignees

• Business Objects Software Ltd

Inventors

• Qiu Xin
• Jin Yang
• Sharma Sumedha
• Lloyd James

Classifications

• G06T11/26

  Drawing of charts or graphs · CPC title

• G06T11/00

  Two-dimensional [2D] image generation · CPC title

• G06F16/904 Primary

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

• G06F16/9038 Primary

  Presentation of query results · CPC title

• G06T11/206

  Physics · mapped topic