System and method for universe generation

• US 20090300061A1
• Filed: 12/03/2008
• Published: 12/03/2009
• Est. Priority Date: 12/03/2007
• Status: Abandoned Application

• Current Assignee: Infosys Technologies Limited (Infosys Limited)
• Original Assignee: Infosys Technologies Limited (Infosys Limited)
• Inventors: Khan, Farhana, Murthy, Bhanu Prashanthi
• Application Number:
  US12/315,499
• Publication Number:
  US 20090300061A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A system and method for automatically generating the universe from the documented MS-Excel file is disclosed. The methods for the Generate Universe, Migrate Universe, Update Universe and Document Universe are disclosed. The method helps in reduction of build effort of the project and removes the problem of corruption of the universe file of link being lost. The method provides easy maintenance of the universe versions and multi-user development environments and updating of universe files.

Claims

1. A method for automatically generating at least one universe using a computer system, the method comprising:

documenting a plurality of universe files in MS-Excel; and

generating the at least one universe from the documented MS-Excel files.

2. The method of claim 1, wherein documenting a plurality of universe files further comprising listing plurality of linked universes and universe connection parameters for exporting the universe to the repository.

3. The method of claim 1, wherein documenting a plurality of universe files further comprising listing a plurality of tables that are in use in the plurality of universe files and all the columns of respective tables for validating the existing of the tables and creating and establishing the tables and joins on the universe files and defining the object definition.

4. The method of claim 3, further comprising listing a plurality of joins defined for the tables for defining the joins on the universe.

5. The method of claim 2, further comprising listing contexts defined for the plurality of universe file.

6. The method of claim 2, further comprising listing classes and objects defined in the plurality of universe file for creating the classes and the objects on the universe with the respective defintions.

7. The method of claim 2, further comprising listing a plurality of conditions for creating at least one filter on the universe.

8. The method of claim 3, further comprising listing the incompatibility between the different tables and objects of the plurality of universe file.

9. The method of claim 1, wherein generating at least one universe further comprising adding universe parameters from the documented MS-Excel file onto the new universe file created.

10. The method of claim 1, wherein generating at least one universe further comprising adding the tables from the documented MS-Excel file onto the new Universe file for creating the new univerese with all the required tables.

11. The method of claim 10, further comprising adding columns to the tables from the documented MS-Excel file for adding the identified object definitions requried from the columns that are defined on the database.

12. The method of claim 10, further comprising adding joins between the tables from the documented MS-Excel file for establishing the relation between the selected tables on the universe.

13. The method of claim 9, further comprising adding contexts to the universe file for identifying different paths for reporting.

14. The method of claim 1, wherein generating at least one universe from the documented excel files further comprising adding classes to the universe file for grouping the objects that are identified under logical sections for easy understanding while creating the reports.

15. The method of claim 14, further comprising adding objects to the universe file for creating the objects for easy understanding without knowing which DB component is getting refered to.

16. The method of claim 10 and claim 15, further comprising adding incompatibility between the tables and objects from the doumented MS-Excel file for making the right use the objects.

17. The method of claim 1, wherein generating at least one universe from the documented MS-Excel files further comprising adding conditions to the universe file for identifying the filter conditions and to enable a list of values.

18. The method as recited in claim 1, further comprising updating of the generated universe.

19. A system for automatically generating at least one universe using a computer system, comprising:

means for documenting a plurality of universe files in MS-Excel; and

means for generating at least one universe from the documented MS-Excel files.

20. A computer program product comprising a computer usable medium having a computer readable program code embodied therein for automatic universe generation, the method comprising:

program codes adapted for documenting a plurality of universe files in MS-Excel; and

program codes adapted for generating at least one universe from the documented MS-Excel files.

21. The product of claim 21, further comprising program code adapted for updating of the generated universe.