-
公开(公告)号: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.
-
公开(公告)号:US10803065B1
公开(公告)日:2020-10-13
申请号:US16569091
申请日:2019-09-12
Applicant: BUSINESS OBJECTS SOFTWARE LTD.
Inventor: Justin Wong , Houman Ghaemi , Veljko Jovanovic
IPC: G06F16/2455 , G06F16/2458 , G06F16/28
Abstract: A system includes determination of a plurality of queries, each of the plurality of queries indicating a first object as a data source, generation of a first query on the first object based on a first two or more of the plurality of queries, modification of each of the first two or more queries to indicate the first query as the data source, requesting of execution of the first query and the modified first two or more queries, and reception of a result set associated with each of the first two or more queries.
-
公开(公告)号:US12229130B2
公开(公告)日:2025-02-18
申请号:US17696726
申请日:2022-03-16
Applicant: Business Objects Software Ltd.
Inventor: Justin Wong
IPC: G06F16/2453 , G06F16/242 , G06F16/26
Abstract: Some embodiments provide a program that receives a first selection of a first set of attributes in a first data model, a second selection of a second set of attribute in a second data model, a third selection of a first dimension in the first data model, and a fourth selection of a second dimension in second data model. The program further receives a request for data for a visualization. The program also generates a blend definition based on the first set of attributes, the second set of attributes, the first dimension in the first data model, and the second dimension in the second data model. The program further generates a blended query model based on the blend definition. The program also executes a query based on the blended query model to generate a result set of data. The program provides a visualization that includes the result set of data.
-
公开(公告)号: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.
-
公开(公告)号:US12130828B2
公开(公告)日:2024-10-29
申请号:US17529006
申请日:2021-11-17
Applicant: Business Objects Software Ltd.
Inventor: Justin Wong , Rui Liu , Clarence Chuahuico , Semuel Kadarusman , Veljko Jovanovic
IPC: G06F16/248 , G06F16/242 , G06F16/25 , G06F16/26
CPC classification number: G06F16/248 , G06F16/242 , G06F16/258 , G06F16/26
Abstract: Some embodiments provide a program that generates a first query for a first visualization based on a first query model associated with the first visualization. The first query model includes a first reference to a shared object. The program further sends the first query to a computing system. The program also receives from the computing system a first set of data. The program further generates the first visualization based on the first set of data. The program also generates a second query for a second visualization based on a second query model associated with the second visualization. The second query model includes a second reference to the shared object. The program further sends the second query to the computing system. The program also receives from the computing system a second set of data. The program further generates the second visualization based on the second set of data.
-
公开(公告)号: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.
-
公开(公告)号:US20230297571A1
公开(公告)日:2023-09-21
申请号:US17696726
申请日:2022-03-16
Applicant: Business Objects Software Ltd.
Inventor: Justin Wong
IPC: G06F16/2453 , G06F16/242 , G06F16/26
CPC classification number: G06F16/24539 , G06F16/2425 , G06F16/26
Abstract: Some embodiments provide a program that receives a first selection of a first set of attributes in a first data model, a second selection of a second set of attribute in a second data model, a third selection of a first dimension in the first data model, and a fourth selection of a second dimension in second data model. The program further receives a request for data for a visualization. The program also generates a blend definition based on the first set of attributes, the second set of attributes, the first dimension in the first data model, and the second dimension in the second data model. The program further generates a blended query model based on the blend definition. The program also executes a query based on the blended query model to generate a result set of data. The program provides a visualization that includes the result set of data.
-
公开(公告)号:US20230062012A1
公开(公告)日:2023-03-02
申请号:US17529006
申请日:2021-11-17
Applicant: Business Objects Software Ltd.
Inventor: Justin Wong , Rui Liu , Clarence Chuahuico , Semuel Kadarusman , Veljko Jovanovic
IPC: G06F16/248 , G06F16/26 , G06F16/242 , G06F16/25
Abstract: Some embodiments provide a program that generates a first query for a first visualization based on a first query model associated with the first visualization. The first query model includes a first reference to a shared object. The program further sends the first query to a computing system. The program also receives from the computing system a first set of data. The program further generates the first visualization based on the first set of data. The program also generates a second query for a second visualization based on a second query model associated with the second visualization. The second query model includes a second reference to the shared object. The program further sends the second query to the computing system. The program also receives from the computing system a second set of data. The program further generates the second visualization based on the second set of data.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-