Dynamic extension of semantic layer universes

Patent metadata

Field	Value
Publication number	US-10936979-B2
Application number	US-201615294076-A
Country	US
Kind code	B2
Filing date	Oct 14, 2016
Priority date	Aug 12, 2016
Publication date	Mar 2, 2021
Grant date	Mar 2, 2021

Abstract

A system, method, and computer-readable medium, including authoring and consolidating a semantic layer universe and at least one semantic layer extension (e.g., a collection of semantic layer entities) created on top of the objects of the semantic layer universe, the semantic layer universe and the one or more semantic layer extensions being linked via a repository relationship; and dynamically presenting a consolidated view of relevant objects from the semantic layer universe and possibly entities of the at least one semantic layer extension to provide a user with additional querying metadata.

First claim

What is claimed is:

1. A system to author extensions to a semantic layer universe, the system comprising:
a memory storing processor-executable instructions; and
a processor to execute the processor-executable instructions to cause the system to, during a design time:
publish a semantic layer universe to expose objects of the universe, each of the objects being a semantic layer entity representative of a data structure having fields and attributes defined by metadata;
create one or more set containers, the one or more one set containers each being a semantic layer entity that is separate and distinct from the semantic layer universe;
link the semantic layer universe to at least one of the one or more set containers via a repository relationship;
create one or more sets on top of the semantic layer universe's objects, the one or more sets being grouped into the at least one of the one or more set containers linked to the semantic layer universe;
receive a request to query the semantic layer universe including the one or more set containers;
determine, based on an examination of the repository relationships for the semantic layer universe, set containers linked to the semantic layer universe;
retain, in accordance with a security access policy, set containers available to the query;
retain, in accordance with the security access policy, objects available in the retained set containers;
retain, in accordance with the security access policy, available sets including the retained objects; and
present a consolidated result of the query based on the available set containers, objects, and sets in response to the request.

2. The system of claim 1 , wherein each of the one or more sets includes at least some of the fields, attributes, and metadata of the objects on which it is based.

3. The system of claim 1 , wherein the repository relationship defines an association between the semantic layer universe and the at least one of the one or more linked set containers including the one or more sets.

4. The system of claim 1 , wherein a set defines a method to produce a data-mart identifier.

5. The system of claim 1 , wherein the one or more sets are stored in a location separate and distinct from the semantic layer universe.

6. A computer-implemented method for authoring extensions to a semantic layer universe, the method comprising:
publishing a semantic layer universe to expose objects of the universe, each of the objects being a semantic layer entity representative of a data structure having fields and attributes defined by metadata;
creating, during a design time, one or more set containers, the one or more set containers each being a semantic layer entity;
linking, during the design time, the semantic layer universe to at least one of the one or more set containers via a repository relationship;
creating, during the design time, one or more sets on top of the semantic layer universe's objects, the one or more sets being grouped into the at least one of the one or more set containers linked to the semantic layer universe;
receiving a request to query the semantic layer universe including the one or more set containers;
determining, based on an examination of the repository relationships for the semantic layer universe, set containers linked to the semantic layer universe;
retaining, in accordance with a security access policy, set containers available to the query;
retaining, in accordance with the security access policy, objects available in the retained set containers;
retaining, in accordance with the security access policy, available sets including the retained objects; and
presenting a consolidated result of the query based on the available set containers, objects, and sets in response to the request.

7. The method of claim 6 , wherein each of the one or more sets includes at least some of the fields, attributes, and metadata of the objects on which is based.

8. The method of claim 6 , wherein the repository relationship defines an association between the semantic layer universe and the at least one of the one or more linked set containers including the one or more sets.

9. The method of claim 6 , wherein a set defines a method to produce a data-mart identifier.

10. The method of claim 6 , wherein the at least one set is stored in a location separate and distinct from the semantic layer universe.

Assignees

• Sap Se

Inventors

• Ricard Christophe
• Asghar Naeem
• Millet Frederic

Classifications

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• G06Q10/067

  Enterprise or organisation modelling · CPC title

• G06Q10/06313 Primary

  Resource planning in a project environment · CPC title

• G06F16/289

  Object oriented databases · CPC title

• G06F16/256

  in federated or virtual databases · CPC title