Navigation across datasets from multiple data sources based on a common reference dimension

摘要

Architecture for slicing data defined on both tabular data sources and in OLAP (online analytical processing) multidimensional data sources by time relative to the current date simultaneously with the same time intelligence (TI) filter on a dashboard page. The architecture employs a simple time period specification (STPS) language used to specify time periods in monitoring server TI filters, and key performance indicator (KPI) filters. The architecture maps all time dimensions to a common set of time aggregations (hierarchy) and to a common calendar.

主权项

1. A computer-implemented system, comprising:
a mapping component configured to map existing time dimensions of multidimensional datasets from multiple different data sources having different time stamps to align the data sources with a common dimension reference of a common calendar with common properties and common levels of dynamic time aggregation defined against a current time to obtain mapped datasets, to compute absolute positions of the time stamps; a filter component configured to filter the mapped datasets simultaneously based in part on offsets to the common calendar and levels of dynamic time aggregation, to enable viewing of portions of the datasets based on any time period implemented; and a processor that executes computer-executable instructions associated with at least one of the mapping component or the filter component.