SYSTEM FOR ANALYSIS OF RESOURCE USAGE AND AVAILABILITY

• US 20170163565A1
• Filed: 12/04/2015
• Published: 06/08/2017
• Est. Priority Date: 12/04/2015
• Status: Abandoned Application

• Current Assignee: Bank of America Corp.
• Original Assignee: Bank of America Corp.
• Inventors: Moran, JR., William Louis
• Application Number:
  US14/959,704
• Publication Number:
  US 20170163565A1
• Time in Patent Office: Days
• CPC Class Codes: G06Q 10/0631 Resource planning, allocation, distributing or scheduling for enterprises or organisations
• CPC Class Codes: H04L 47/822 Collecting or measuring resource availability data
• CPC Class Codes: H04L 47/83 based on usage prediction

Abstract

Systems, computer products, and methods are described herein for allowing users to create and control reports that are utilized to determine usage and availability of resources for the organization or for units within the organization and/or to illustrate the usage and availability of resources to industries, sectors, clients, vendors, positions, projects, and/or the like. The report illustrates how the organization is using resources and/or the resources that are available to the organization, and to report resource usage and/or availability for forecasting for strategic planning and/or for regulatory compliance. It should be understood that the present invention may be utilized for any type of resource of an organization to illustrate resource usage and availability.

Claims

1. A system for monitoring and analyzing resource usage and availability for providing reports regarding the resource usage and availability, the system comprising:

one or more memory devices having computer readable code store thereon; and

one or more processing devices operatively coupled to the one or more memory devices, wherein the one or more processing devices are configured to execute the computer readable code to;

receive a request from a user to create a report for the resource usage and availability for an activity, wherein the report is created by the user by utilizing a logical data model and a schema;

receive a request from the user to utilize a reference data manger application to select the reference data utilized to create the report, wherein the reference data includes standardized data used by calculations to transform resource data for the reports;

receive a request from the user to utilize a manual adjustment application to adjust the resource data, wherein the resource data includes the data for forecasting, for scenarios, or for compliance regarding the resource usage and availability;

receive a request from the user to access a command and control center application to monitor reports, wherein the user may start, stop, or check the status of the reports being run;

receive a request from the user to run the report;

utilize the logical data model and the schema, the reference data, and the resource data to transform the reference data and the resource data to create the report; and

provide the report to the user regarding the activity on a user computer system.

2. The system of claim 1, wherein the logical data model comprises logical object tables and logical hierarchies, wherein the logical object tables correspond to physical stored tables of resource data or reference data, and wherein the logical hierarchies group attributes in the tables to reflect relationships and provide convenient drilling paths for the report.

3. The system of claim 1, wherein the logical data model comprises the attributes, facts, and transformations;

wherein the attributes represent qualitative information, provide context, and define the aggregation level of calculations on the report;

wherein the facts are quantitative information displayed on the report, and are determined from one or more fields in the resource data; and

the transformations allow the user to apply an attribute offset for fact comparison purposes.

4. The system of claim 1, wherein the schema comprises a map to the resource data or the reference data.

5. The system of claim 1, wherein the report is further based on a template providing a structure of how the report will be presented, wherein the template is populated with report objects including the attributes, metrics, and filters;

wherein the attributes represent qualitative information, provide context, and define the aggregation level of calculations on the report;

wherein the metrics include numbers that the user wants to include in the report and are associated with the attributes; and

the filters include view filters and report filters.

6. The system of claim 1, wherein the manual adjustment application is used by the user to adjust resource data using a structured query language (SQL) query or a comma separated value (CSV) file.

7. The system of claim 1, wherein the one or more processing devices are configured to execute the computer readable code to:

receive a request from the user to utilize a submission framework to add additional data to the resource data; and

wherein the report is further based on the additional data added to the resource data.

8. A computer implemented method for monitoring and analyzing resource usage and availability for providing reports regarding the resource usage and availability, the method comprising:

receiving, by one or more processing components, a request from a user to create a report for the resource usage and availability for an activity, wherein the report is created by the user by utilizing a logical data model and a schema;

receiving, by the one or more processing components, a request from the user to utilize a reference data manger application to select the reference data utilized to create the report, wherein the reference data includes standardized data used by calculations to transform resource data for the reports;

receiving, by the one or more processing components, a request from the user to utilize a manual adjustment application to adjust the resource data, wherein the resource data includes the data for forecasting, for scenarios, or for compliance regarding the resource usage and availability;

receiving, by the one or more processing components, a request from the user to access a command and control center application to monitor reports, wherein the user may start, stop, or check the status of the reports being run;

receiving, by the one or more processing components, a request from the user to run the report;

utilizing, by the one or more processing components, the logical data model and the schema, the reference data, and the resource data to transform the reference data and the resource data to create the report; and

providing, by the one or more processing components, the report to the user regarding the activity on a user computer system.

9. The method of claim 8, wherein the logical data model comprises logical object tables and logical hierarchies, wherein the logical object tables correspond to physical stored tables of resource data or reference data, and wherein the logical hierarchies group attributes in the tables to reflect relationships and provide convenient drilling paths for the report.

10. The method of claim 8, wherein the logical data model comprises the attributes, facts, and transformations;

wherein the attributes represent qualitative information, provide context, and define the aggregation level of calculations on the report;

wherein the facts are quantitative information displayed on the report, and are determined from one or more fields in the resource data; and

the transformations allow the user to apply an attribute offset for fact comparison purposes.

11. The method of claim 8, wherein the schema comprises a map to the resource data or the reference data.

12. The method of claim 8, wherein the report is further based on a template providing a structure of how the report will be presented, wherein the template is populated with report objects including the attributes, metrics, and filters;

wherein the attributes represent qualitative information, provide context, and define the aggregation level of calculations on the report;

wherein the metrics include numbers that the user wants to include in the report and are associated with the attributes; and

the filters include view filters and report filters.

13. The method of claim 8, wherein the manual adjustment application is used by the user to adjust resource data using a structured query language (SQL) query or a comma separated value (CSV) file.

14. The method of claim 8, further comprising:

receiving, by the one or more processing devices, a request from the user to utilize a submission framework to add additional data to the resource data; and

wherein the report is further based on the additional data added to the resource data.

15. A computer program product for monitoring and analyzing resource usage and availability for providing reports regarding the resource usage and availability, the computer program product comprising at least one non-transitory computer-readable medium having computer-readable program code portions embodied therein, the computer-readable program code portions comprising:

an executable portion configured to receive a request from a user to create a report for the resource usage and availability for an activity, wherein the report is created by the user by utilizing a logical data model and a schema;

an executable portion configured to receive a request from the user to utilize a reference data manger application to select the reference data utilized to create the report, wherein the reference data includes standardized data used by calculations to transform resource data for the reports;

an executable portion configured to receive a request from the user to utilize a manual adjustment application to adjust the resource data, wherein the resource data includes the data for forecasting, for scenarios, or for compliance regarding the resource usage and availability;

an executable portion configured to receive a request from the user to access a command and control center application to monitor reports, wherein the user may start, stop, or check the status of the reports being run;

an executable portion configured to receive a request from the user to run the report;

an executable portion configured to utilize the logical data model and the schema, the reference data, and the resource data to transform the reference data and the resource data to create the report; and

an executable portion configured to provide the report to the user regarding the activity on a user computer system.

16. The computer program product of claim 15, wherein the logical data model comprises logical object tables and logical hierarchies, wherein the logical object tables correspond to physical stored tables of resource data or reference data, and wherein the logical hierarchies group attributes in the tables to reflect relationships and provide convenient drilling paths for the report.

17. The computer program product of claim 15, wherein the logical data model comprises the attributes, facts, and transformations;

wherein the attributes represent qualitative information, provide context, and define the aggregation level of calculations on the report;

wherein the facts are quantitative information displayed on the report, and are determined from one or more fields in the resource data; and

the transformations allow the user to apply an attribute offset for fact comparison purposes.

18. The computer program product of claim 15, wherein the schema comprises a map to the resource data or the reference data.

19. The computer program product of claim 15, wherein the report is further based on a template providing a structure of how the report will be presented, wherein the template is populated with report objects including the attributes, metrics, and filters;

wherein the attributes represent qualitative information, provide context, and define the aggregation level of calculations on the report;

wherein the metrics include numbers that the user wants to include in the report and are associated with the attributes; and

the filters include view filters and report filters.

20. The computer program product of claim 15, wherein the manual adjustment application is used by the user to adjust resource data using a structured query language (SQL) query or a comma separated value (CSV) file.