Abstract: Approaches for integrating an operational reporting system with a warehouse based reporting system. The operational reporting system and the warehouse based reporting system may be offered and supported by different vendors, and so may be deployed in different clouds or as separate product installations in case of on-premise software, or these systems may be offered and supported by a single vendor, and so may be deployed in the same cloud or as part of a common product installation in case of on-premise software. The integrated system uses a common or consistent dimensional model to link related measures of the operational reporting system and the warehouse based reporting system, which allows for analysis of real time content with historical and cross subject perspective provided alongside in the same interface. The integration also facilitates trend analysis and predictive analytics in real time.

Abstract: Automatically determining time threshold guarantees for metrics like completion time or first response time for tasks or items. A system relies on the historical tasks data with completion or first response times. The system plots a graphical representation between completion time and a percentage of tasks completed and uses sophisticated analysis of slopes at different points of the graphical representation to determine time threshold guarantees below a specified maximum completion or first response time threshold, and above a specified minimum percentage of completion. The system also compensates for a variety of factors which may be changed from the time historical data was obtained to the present time for which time threshold guarantees are being determined. In absence of historical customer data, the system makes the recommendations based on available datasets of peer customers.

Abstract: An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.

Abstract: An automated system for validating and refining a template warehouse star schema for a customized data source.

Abstract: An automated system for validating and refining a template warehouse star schema for a customized data source.

Abstract: An automated system for defining a star schema for a data source. The system based on automatically gathered information from the data source such as entities and columns, entity column types and lengths, entity keys, relationships between and within entities, measures, workflow and correlated attributes, specialized entities, an update frequency of entities and columns, and grouping of entity and column updates associated with the source database automatically determines facts, dimensions, dimension hierarchies, measures, workflow specific measures (if data source has workflows) and workflow correlated attribute specific measures (if data source has temporal, priority, ownership and progress tracking attributes) to come up with a star schema for the data source.