Business intelligence dashboard generator

• US 9,275,122 B2
• Filed: 09/02/2009
• Issued: 03/01/2016
• Est. Priority Date: 07/28/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Lions, Philippe
• Primary Examiner(s): Reyes, Mariela
• Assistant Examiner(s): Almani, Mohsen
• Application Number:
  US12/552,583
• Publication Number:
  US 20110029579A1
• Time in Patent Office: 2,372 Days
• Field of Search: 707/613, 707/809, 709/213
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database

Abstract

A cloner is configured to assist users in deploying templates from a source environment into a target environment. The cloner includes a source identification module configured to identify source objects in a source environment from one or more business intelligence reports. The cloner also includes a mapping module configured to provide a declarative mapping screen showing the source objects and a list of available objects in a target environment to map the source objects against, and to receive mapping information selections from a user. The cloner further includes a duplication module configured to duplicate the one or more business intelligence reports into the target environment based on the mapping information selections.

Claims

1. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to generate a business intelligence dashboard, the generating comprising:

receive from a source environment a first interactive dashboard, wherein the first interactive dashboard comprises a first layout and first logical calculations that generate first data to be displayed in the first layout, wherein the source environment is a first business intelligence system repository;

identify a list of required source objects used in the first interactive dashboard that are required in a target environment, wherein the required source objects comprise one or more of the first logical calculations for displaying data on the first interactive dashboard;

provide a declarative mapping screen showing the list of required source objects including root arguments of logical formulas, and a list of available objects in the target environment to map the source objects against, wherein the target environment is a second business intelligence system repository that is different than the first business intelligence system repository, wherein the declarative mapping screen identifies one or more database columns that are required for duplicating the first interactive dashboard on the target environment, wherein associated logical formulas that are associated with the identified required database columns are reproduced in the target environment;

receive mapping information selections from a user, wherein each of the list of required source objects is mapped to an available object of the list of available objects in the target environment;

receive alterations to the logical formulas; and

generate the second interactive dashboard for use in the target environment based on the mapping information selections and the first interactive dashboard, wherein the second interactive dashboard comprises a second layout that is a duplicate of the first layout, and second logical calculations that are different than the first logical calculations and that are created based on the alterations to the logical formulas and that generate second data to be displayed in the second layout.

2. The computer-readable medium of claim 1, further comprising determining whether each of the list of required source objects has been mapped to an available object.

3. The computer-readable medium of claim 1, wherein the generating saves designated mappings for reuse.

4. The computer-readable medium of claim 1, wherein the generating:

bypasses non-critical source objects by ignoring the mapping of the non-critical source objects; and

warns the user of potential mismatches in data types in the mapping.

5. The computer-readable medium of claim 1, wherein the generating provides the user with control over which source and target environments to use, location of the second interactive dashboard in the target environment, and naming of the second interactive dashboard in the target environment.

6. The computer-readable medium of claim 1, wherein the generating creates logical calculations needed for the second interactive dashboard that are not present in the target environment.

7. The computer-readable medium of claim 1, wherein the generating:

provides a log of all tasks performed during duplication; and

marks the second interactive dashboard and associated objects that were created with a description that comprises a duplication time stamp.

8. The computer-readable medium of claim 1, wherein the source objects comprise required and optional objects.

9. The computer-readable medium of claim 1, wherein the generating duplicates logical calculation objects associated with the first interactive dashboard into the target environment based on the mapping information selections.

10. The computer-readable medium of claim 1, wherein the first logical calculations comprise a logical metric definition in the first business intelligence system repository, and logical ancestor objects that are used as arguments.

11. The computer-readable medium of claim 1, further comprising automatically updating repository object names for the second interactive dashboard.

12. A cloner configured to assist users in deploying templates from a source environment into a target environment, comprising:

a source identification module configured to identify source objects in a source environment from a received first interactive dashboard, wherein the source environment is a first business intelligence system repository, wherein the first interactive dashboard comprises a first layout, and first logical calculations that generate first data to be displayed in the first layout;

an identification module that identifies a list of required source objects used in the first interactive dashboard that are required in the target environment, wherein the required source objects comprise one or more of the first logical calculations for displaying data on the first interactive dashboard;

a mapping module configured to provide a declarative mapping screen showing the source objects including root arguments of logical formulas, and a list of available objects in the target environment to map the source objects against, and to receive mapping information selections from a user and receive alterations to the logical formulas, wherein the target environment is a second business intelligence system repository that is different than the first business intelligence system repository and each of the list of required source objects is mapped to an available object of the list of available objects in the target environment, wherein the declarative mapping screen identifies one or more database columns that are required for duplicating the first interactive dashboard on the target environment, wherein associated logical formulas that are associated with the identified required database columns are reproduced in the target environment; and

a duplication module stored in memory and executed by a processor and configured to generate the second interactive dashboard for use in the target environment based on the mapping information selections and the first interactive dashboard, wherein the second interactive dashboard comprises a second layout that is a duplicate of the first layout, and second logical calculations that are different than the first logical calculations and that are created based on the alterations to the logical formulas and that generate second data to be displayed in the second layout.

13. The cloner of claim 12, wherein the first interactive dashboard comprises a first report that is duplicated as a second report for use with the second interactive dashboard.

14. The cloner of claim 12, wherein the mapping module is further configured to bypass non-critical source objects by ignoring the mapping of the non-critical source objects and to warn the user of potential mismatches in data types in the mapping.

15. The cloner of claim 12, wherein the source objects comprise required and optional objects.

16. The cloner of claim 12, wherein the duplication module is further configured to duplicate logical calculation objects associated with the first interactive dashboard into the target environment based on the mapping information selections.

17. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to generate a business intelligence dashboard, the generating comprising:

determine from a source environment a first interactive dashboard existing in a target web catalog to analyze for repository changes, wherein the first interactive dashboard comprises a first layout, and first logical calculations that generate first data to be displayed in the first layout, wherein the source environment is a first business intelligence system;

compare an original repository of the first business intelligence system and a modified repository of the second business intelligence system;

identify a list of required source objects used in the first interactive dashboard that are required in a target environment, wherein the required source objects comprise one or more of the first logical calculations for displaying data on the first interactive dashboard;

provide a declarative mapping screen showing the list of required source objects including root arguments of logical formulas, and a list of available objects in the target environment to map the source objects against, wherein the target environment is the second business intelligence system repository that is different than the first business intelligence system repository, wherein the declarative mapping screen identifies one or more database columns that are required for duplicating the first interactive dashboard on the target environment, wherein associated logical formulas that are associated with the identified required database columns are reproduced in the target environment;

receive alterations to the logical formulas; and

implement fixes for the first interactive dashboard in the target web catalog, wherein the fixes allow the first interactive dashboard to be duplicated as the second interactive dashboard for the second business intelligence system, wherein the second interactive dashboard comprises a second layout that is a duplicate of the first layout, and second logical calculations that are different than the first logical calculations and that are created based on the alterations to the logical formulas and that generate second data to be displayed in the second layout;

wherein the fixes comprise receiving mapping information selections, wherein each of the list of required source objects is mapped to an available object of the list of available objects in the target environment.

18. The computer-readable medium of claim 17, wherein the one or more identified repository changes comprise a name change, presentation layer moving or deletions.

19. The computer-readable medium of claim 17, to the generating further comprising:

create a backup of an original version of the first interactive dashboard that is affected by the one or more repository changes; and

create a log file indicating the changes that were made and the first interactive dashboard that was affected.

20. A system, comprising:

a cloner, comprising;

a source identification module configured to identify source objects in a source environment from a received first interactive dashboard, wherein the source environment is a first business intelligence system repository, wherein the first interactive dashboard comprises a first layout, and first logical calculations that generate first data to be displayed in the first layout, wherein the source environment is a first business intelligence system repository,

an identification module that identifies a list of required source objects used in the first interactive dashboard that are required in a target environment, wherein the required source objects comprise one or more of the first logical calculations for displaying data on the first interactive dashboard;

a mapping module configured to provide a declarative mapping screen showing the list of required source objects including root arguments of logical formulas, and a list of available objects in the target environment to map the source objects against, and to receive mapping information selections from a user and receive alterations to the logical formulas, wherein the target environment is a second business intelligence system repository that is different than the first business intelligence system repository, and each of the source objects of the list of required source objects is mapped to an available object of the list of available objects in the target environment, wherein the declarative mapping screen identifies one or more database columns that are required for duplicating the first interactive dashboard on the target environment, wherein associated logical formulas that are associated with the identified required database columns are reproduced in the target environment; and

a duplication module stored in memory and executed by a processor and configured to generate the second interactive dashboard for use in the target environment based on the mapping information selections and the first interactive dashboard, wherein the second interactive dashboard comprises a second layout that is a duplicate of the first layout, and second logical calculations that are different than the first logical calculations and that are created based on the alterations to the logical formulas and that generate second data to be displayed in the second layout; and

a synchronizer, comprising;

a report determining module configured to determine one or more business intelligence reports existing in a target web catalog to analyze for repository changes,

a repository comparison module configured to compare an original repository and a modified repository,

a change identification module configured to identify one or more repository changes impacting at least one of the one or more business intelligence reports, and

a repair module configured to implement fixes for the one or more at least one impacted business intelligence report in the target web catalog.

21. The system of claim 20, wherein the first interactive dashboard comprises a first report that is duplicated as a second report for use with the second interactive dashboard.

22. The system of claim 20, wherein the one or more identified repository changes comprise a name change, a folder change, presentation layer moving or deletions.

23. The system of claim 20, wherein the source objects comprise required and optional objects.

24. The system of claim 20, wherein the duplication module is further configured to duplicate logical calculation objects associated with the first interactive dashboard into the target environment based on the mapping information selections.