公开(公告)号：US20210165828A1

公开(公告)日：2021-06-03

申请号：US16700434

申请日：2019-12-02

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Ping Xiang ,  Semuel Kadarusman ,  Patrick Wang ,  Justin Wong ,  Veljko Jovanovic

IPC: G06F16/9035 ,  G06F16/22 ,  G06F16/2455

Abstract: Some embodiments provide execution of a query on a target data model which is filtered on a measure of a source data model, even if the source data model and the target data model are not logically linked. Some embodiments further support execution of a query on a target data model which is filtered on a measure of a source data model and on a dimension filter of another data model. Some embodiments provide for a substantial amount of query execution to occur on the backend, thereby freeing client resources in comparison to prior approaches.

公开(公告)号：US20210073230A1

公开(公告)日：2021-03-11

申请号：US16563200

申请日：2019-09-06

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Ping Xiang ,  Semuel Kadarusman ,  Patrick Wang ,  Justin Wong ,  Veljko Jovanovic

IPC: G06F16/2453 ,  G06F16/248 ,  G06F16/21 ,  G06F16/22 ,  G06F16/2455

Abstract: A system includes reception of a filter on a first dimension of a first data model, determination of an association between a second dimension of the first data model and a first dimension of a second data model, generation of a calculated dimension based on the second dimension, the rows of the calculated dimension being identical to the rows of the first dimension, application of the filter to the rows of the calculated dimension to generate filtered rows of the calculated dimension, execution of an inner join between the filtered rows of the calculated dimension and a fact table of the second data model to generate a result table including one or more measure values of the second data model, and generation of a visualization including the result table.

公开(公告)号：US11093504B2

公开(公告)日：2021-08-17

申请号：US16700434

申请日：2019-12-02

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Ping Xiang ,  Semuel Kadarusman ,  Patrick Wang ,  Justin Wong ,  Veljko Jovanovic

IPC: G06F15/16 ,  G06F16/2455

Abstract: Some embodiments provide execution of a query on a target data model which is filtered on a measure of a source data model, even if the source data model and the target data model are not logically linked. Some embodiments further support execution of a query on a target data model which is filtered on a measure of a source data model and on a dimension filter of another data model. Some embodiments provide for a substantial amount of query execution to occur on the backend, thereby freeing client resources in comparison to prior approaches.

公开(公告)号：US11790008B2

公开(公告)日：2023-10-17

申请号：US16569040

申请日：2019-09-12

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Justin Wong ,  JianHong Tan ,  Kyoung Woo Nam ,  Patrick Wang ,  Ruoxin Zhou ,  Veljko Jovanovic

IPC: G06F16/00 ,  G06F16/904 ,  G06F16/903 ,  G06F16/9038 ,  G06F16/908

CPC classification number: G06F16/904 ,  G06F16/908 ,  G06F16/9038 ,  G06F16/90335

Abstract: A system includes reception of a user request for a set of data visualizations, execution, in response to the user request, of a main thread to request metadata associated with the set of data visualizations from a remote system, execution of a worker thread to request a set of persisted queries associated with the set of data visualizations from the remote system, to issue the set of persisted queries to the remote system, to receive query results associated with the set of persisted queries from the remote system, and to initiate storage of the query results in a local memory, and execution of the main thread to retrieve the query results stored in the local memory and render the set of data visualizations based on the retrieved query results.

公开(公告)号：US11200236B2

公开(公告)日：2021-12-14

申请号：US16563200

申请日：2019-09-06

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Ping Xiang ,  Semuel Kadarusman ,  Patrick Wang ,  Justin Wong ,  Veljko Jovanovic

IPC: G06F3/048 ,  G06F16/2453 ,  G06F16/248 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/21

Abstract: A system includes reception of a filter on a first dimension of a first data model, determination of an association between a second dimension of the first data model and a first dimension of a second data model, generation of a calculated dimension based on the second dimension, the rows of the calculated dimension being identical to the rows of the first dimension, application of the filter to the rows of the calculated dimension to generate filtered rows of the calculated dimension, execution of an inner join between the filtered rows of the calculated dimension and a fact table of the second data model to generate a result table including one or more measure values of the second data model, and generation of a visualization including the result table.

公开(公告)号：US20210081451A1

公开(公告)日：2021-03-18

申请号：US16569040

申请日：2019-09-12

Applicant: BUSINESS OBJECTS SOFTWARE LTD.

Inventor： Justin Wong ,  JianHong Tan ,  Kyoung Woo Nam ,  Patrick Wang ,  Ruoxin Zhou ,  Veljko Jovanovic

IPC: G06F16/904 ,  G06F16/908 ,  G06F16/9038 ,  G06F16/903

Abstract: A system includes reception of a user request for a set of data visualizations, execution, in response to the user request, of a main thread to request metadata associated with the set of data visualizations from a remote system, execution of a worker thread to request a set of persisted queries associated with the set of data visualizations from the remote system, to issue the set of persisted queries to the remote system, to receive query results associated with the set of persisted queries from the remote system, and to initiate storage of the query results in a local memory, and execution of the main thread to retrieve the query results stored in the local memory and render the set of data visualizations based on the retrieved query results.