公开(公告)号：US20210390120A1

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

申请号：US16897722

申请日：2020-06-10

Applicant: Business Objects Software Ltd.

Inventor： Olivier Tsoungui

IPC: G06F16/28 ,  G06F16/27

Abstract: Techniques for implementing nested group hierarchies for analytics applications are disclosed. In some embodiments, a computer-implemented method comprises: creating a hierarchy object in a semantic layer based on a request comprising a definition for a nested group hierarchy, the definition specifying a hierarchical relationship structure for non-leaf group nodes and at least one leaf node, the non-leaf group nodes and the leaf node(s) corresponding to data stored in a data source in a non-hierarchical structure, the hierarchy object specifying the hierarchical relationship structure based on the definition; generating a query result based on a request comprising an indication of the hierarchy object using the hierarchy object from the semantic layer to retrieve the data from the data source; and causing the query result to be displayed on a computing device using the hierarchy object to display the retrieved data in a hierarchical format indicating the hierarchical relationship structure.

公开(公告)号：US20180157731A1

公开(公告)日：2018-06-07

申请号：US15368719

申请日：2016-12-05

Applicant: Business Objects Software Ltd.

Inventor： Olivier Tsoungui

IPC: G06F17/30

CPC classification number: G06F16/28 ,  G06F16/2455

Abstract: A universe is created on top of a relational database. The relational database includes database tables with attributes to describe objects. The universe includes objects corresponding to attributes of database objects. Creating the universe on top of the relational database may include creating of a connection to the relational DB to define a data foundation for creating the universe. A hierarchy object is created as part of the universe. A hierarchy type for the hierarchy object is defined. The hierarchy object defines a hierarchy of dimension objects from the universe. An exemplary hierarchy object may be of a level-based hierarchy type or of a parent-child hierarchy type. The universe is saved to include the hierarchy object. The universe is published into a repository. The published universe serves requests to generate queries and to run reports based on data from the relational database.

公开(公告)号：US11734309B2

公开(公告)日：2023-08-22

申请号：US17696264

申请日：2022-03-16

Applicant: Business Objects Software Ltd.

Inventor： Olivier Tsoungui

IPC: G06F16/28 ,  G06F16/27

CPC classification number: G06F16/282 ,  G06F16/27 ,  G06F16/284

Abstract: Techniques for implementing nested group hierarchies for analytics applications are disclosed. In some embodiments, a computer-implemented method comprises: creating a hierarchy object in a semantic layer based on a request comprising a definition for a nested group hierarchy, the definition specifying a hierarchical relationship structure for non-leaf group nodes and at least one leaf node, the non-leaf group nodes and the leaf node(s) corresponding to data stored in a data source in a non-hierarchical structure, the hierarchy object specifying the hierarchical relationship structure based on the definition; generating a query result based on a request comprising an indication of the hierarchy object using the hierarchy object from the semantic layer to retrieve the data from the data source; and causing the query result to be displayed on a computing device using the hierarchy object to display the retrieved data in a hierarchical format indicating the hierarchical relationship structure.

公开(公告)号：US20220207058A1

公开(公告)日：2022-06-30

申请号：US17696264

申请日：2022-03-16

Applicant: Business Objects Software Ltd.

Inventor： Olivier Tsoungui

IPC: G06F16/28 ,  G06F16/27

Abstract: Techniques for implementing nested group hierarchies for analytics applications are disclosed. In some embodiments, a computer-implemented method comprises: creating a hierarchy object in a semantic layer based on a request comprising a definition for a nested group hierarchy, the definition specifying a hierarchical relationship structure for non-leaf group nodes and at least one leaf node, the non-leaf group nodes and the leaf node(s) corresponding to data stored in a data source in a non-hierarchical structure, the hierarchy object specifying the hierarchical relationship structure based on the definition; generating a query result based on a request comprising an indication of the hierarchy object using the hierarchy object from the semantic layer to retrieve the data from the data source; and causing the query result to be displayed on a computing device using the hierarchy object to display the retrieved data in a hierarchical format indicating the hierarchical relationship structure.

公开(公告)号：US11288288B2

公开(公告)日：2022-03-29

申请号：US16897722

申请日：2020-06-10

Applicant: Business Objects Software Ltd.

Inventor： Olivier Tsoungui

IPC: G06F16/28 ,  G06F16/2457 ,  G06F16/27

Abstract: Techniques for implementing nested group hierarchies for analytics applications are disclosed. In some embodiments, a computer-implemented method comprises: creating a hierarchy object in a semantic layer based on a request comprising a definition for a nested group hierarchy, the definition specifying a hierarchical relationship structure for non-leaf group nodes and at least one leaf node, the non-leaf group nodes and the leaf node(s) corresponding to data stored in a data source in a non-hierarchical structure, the hierarchy object specifying the hierarchical relationship structure based on the definition; generating a query result based on a request comprising an indication of the hierarchy object using the hierarchy object from the semantic layer to retrieve the data from the data source; and causing the query result to be displayed on a computing device using the hierarchy object to display the retrieved data in a hierarchical format indicating the hierarchical relationship structure.