Universe automatic generation of business layer fragments

• US 10,922,275 B2
• Filed: 10/26/2018
• Issued: 02/16/2021
• Est. Priority Date: 10/26/2018
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Ricard, Christophe, Asghar, Naeem
• Primary Examiner(s): Nguyen, Kim T
• Application Number:
  US16/172,718
• Publication Number:
  US 20200134044A1
• Time in Patent Office: 844 Days
• Field of Search: None
• CPC Class Codes: G06F 16/168 Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs query results presentation G06F16/156
• CPC Class Codes: G06F 16/2219 Large Object storage; Management thereof
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/335 Filtering based on additional data, e.g. user or group profiles filtering in web context G06F16/9535, G06F16/9536
• CPC Class Codes: G06F 8/30 Creation or generation of source code
• CPC Class Codes: G06F 8/38 for implementing user interfaces

Abstract

A system, method, and computer-readable medium, including adding a dedicated data storage structure to a first set container, the added dedicated data storage structure to store business objects (BOs) constructed based on data foundation fragments injected into a data foundation of a semantic layer universe; generating, automatically, a BO based on a data foundation of the semantic layer universe; storing the automatically generated BO in the added storage structure and storing the added data storage structure in the first set container.

Claims

1. A system comprising:

a memory storing processor-executable instructions; and

a processor to execute the processor-executable instructions to cause the system to;

add a dedicated data storage structure to a first set container of a semantic layer universe, the first set container being a data structure hosting at least one set including one or more set tables and information stored in the first set container specifying each set table it contains and a structure of each set table contained in the first set container, the specified structure of each set table contained in the first set container being indicative a schema of a first database;

automatically create at least one data foundation table for each of the one or more set tables in the first set container based on the information stored in the first set container containing the one or more set tables;

automatically generate, at least one object consistent with the schema of the first database as indicated by the information stored in the first set container specifying the structure of each set table stored in the first set container based on the at least one automatically created data foundation table;

store the automatically generated at least one object in the dedicated storage structure; and

store the dedicated data storage structure in the first set container.

2. The system of claim 1, further comprising:

determining whether the dedicated data storage structure exists in the first set container; and

in an instance the dedicated data storage structure does not exist, creating the dedicated data storage structure anew.

3. The system of claim 1, wherein the dedicated data storage structure acts as a root directory structure for the automatically generated at least one object.

4. The system of claim 1, further comprising:

defining a user interface aspect to surface and customize at least one object created on a display device;

generating the user interface aspect, as defined; and

storing the generated user interface aspect in the dedicated data structure hosted by the first set container.

5. The system of claim 1, wherein an owner of the customer table defines one or more subjects and the dedicated data storage structure includes a folder for each subject.

6. The system of claim 1, further comprising generating one object per column for each subject table, and storing each generated object in a dedicated subject folder.

7. The system of claim 6, further comprising generating a filter to constrain query results based on the at least one object stored in the dedicated data storage structure, a description of the filter being saved in the dedicated data storage structure.

8. A computer-implemented method for authoring extensions to a semantic layer universe, the method comprising:

adding a dedicated data storage structure to a first set container of a semantic layer universe, the first set container being a data structure hosting at least one set including one or more set tables and information stored in the first set container specifying each set table it contains and a structure of each set table contained in the first set container, the specified structure of each set table contained in the first set container being indicative a schema of a first database;

automatically creating at least one data foundation table for each of the one or more set tables in the first set container based on the information stored in the first set container containing the one or more set tables;

automatically generating at least one object consistent with the schema of the first database as indicated by the information stored in the first set container specifying the structure of each set table stored in the first set container based on the at least one automatically created data foundation table;

storing the automatically generated at least one object in the dedicated storage structure; and

storing the dedicated data storage structure in the first set container.

9. The method of claim 8, further comprising:

determining whether the dedicated data storage structure exists in the first set container; and

in an instance the dedicated data storage structure does not exist, creating the dedicated data storage structure anew.

10. The method of claim 8, wherein the dedicated data storage structure acts as a root directory structure for the automatically generated at least one object.

11. The method of claim 8, further comprising:

defining a user interface aspect to surface and customize at least one object created on a display device;

generating the user interface aspect, as designed and

storing the generated user interface aspect in the dedicated data structure hosted by the first set container.

12. The method of claim 8, wherein an owner of the customer table defines one or more subjects and the dedicated data storage structure includes a folder for each subject.

13. The method of claim 12, further comprising generating one object per column for each subject table and storing each generated BO object in a dedicated subject folder.

14. The method of claim 8, further comprising generating a filter to constrain query results based on the at least one object stored in the dedicated data storage structure, a description of the filter being saved in the dedicated data storage structure.

15. A non-transitory computer readable medium having executable instructions stored therein, the medium comprising:

instructions to add a dedicated data storage structure to a first set container of a semantic layer universe, the first set container being a data structure hosting at least one set including one or more set tables and information stored in the first set container specifying each set table it contains and a structure of each set table contained in the first set container, the specified structure of each set table contained in the first set container being indicative a schema of a first database;

instructions to automatically create at least one data foundation table for each of the one or more set tables in the first set container based on the information stored in the first set container containing the one or more set tables;

instructions to automatically generate at least one object consistent with the schema of the first database as indicated by the information stored in the first set container specifying the structure of each set table stored in the first set container based on the at least one automatically created data foundation table;

instructions to store the automatically generated at least one object in the dedicated storage structure; and

instructions to store the dedicated data storage structure in the first set container.

16. The medium of claim 15, further comprising:

instructions to determine whether the dedicated data storage structure exists in the first set container; and

instructions to, in an instance the dedicated data storage structure does not exist, create the dedicated data storage structure anew.

17. The medium of claim 15, wherein the dedicated data storage structure acts as a root directory structure for the automatically generated at least one object.

18. The medium of claim 15, further comprising:

instructions to define a user interface aspect to surface and customize at least one object created on a display device;

instructions to generate the user interface aspect, as defined; and

instructions to store the generated user interface aspect in the dedicated data storage structure.

19. The medium of claim 15, wherein an owner of the customer table defines one or more subjects and the dedicated data storage structure includes a folder for each subject.

20. The medium of claim 15, further comprising generating one object per column and storing each generated object in a dedicated subject folder.