NAVIGATION ACROSS DATASETS FROM MULTIPLE DATA SOURCES BASED ON A COMMON REFERENCE DIMENSION

• US 20090228485A1
• Filed: 03/07/2008
• Published: 09/10/2009
• Est. Priority Date: 03/07/2008
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Wilson, Brent, Arimilli, Ramesh, Handy, Stephen, Hulen, Corey
• Granted Patent: US 8,880,459 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: Y10S 715/963 Calendar or scheduling

Abstract

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.

Claims

1. A computer-implemented system, comprising:

a mapping component for mapping dimensions of datasets from data sources to a common dimension reference to obtain mapped datasets; and

a filter component for filtering the mapped datasets simultaneously based in part on offsets to the common dimension reference.

2. The system of claim 1, wherein the datasets are at least one of reports or scorecards presented as part of a dashboard.

3. The system of claim 1, wherein the dimensions of the datasets have a characteristic of atomically increasing entailment.

4. The system of claim 1, wherein the data sources include tabular data and OLAP (online analytical processing) data.

5. The system of claim 1, wherein the datasets are mapped to a common time dimension reference.

6. A computer-implemented system, comprising:

a mapping component for mapping time dimensions of datasets from data sources to a common time reference to obtain mapped datasets;

a language component for specifying a time period relative to the common time reference over which to filter the mapped datasets; and

a filter component for filtering the mapped datasets simultaneously based on the time period.

7. The system of claim 6, wherein the mapped datasets are at least one of reports or scorecards processed as part of a dashboard, the datasets obtained from data sources that include tabular data and multidimensional data.

8. The system of claim 7, wherein the mapping component maps existing time dimensions of the multidimensional data to a common calendar and time aggregation.

9. The system of claim 6, wherein the language component facilitates specifying time dimensionality of a date-time column in the tabular data.

10. The system of claim 6, wherein the filter component employs time intelligence for filtering the mapped datasets over the time period relative to a current date based on a calendar as the common time reference.

11. The system of claim 6, wherein the filter component filters the mapped datasets based on at least one of the data sources.

12. The system of claim 6, wherein the language component facilitates specifying of an offset from a current date, time periods, parallel periods, and sets or ranges of time periods.

13. A computer-implemented method of processing data, comprising:

mapping time dimensions of datasets from data sources to a common time reference to obtain mapped datasets; and

filtering the mapped datasets simultaneously based on a time period and using time intelligence.

14. The method of claim 13, further comprising specifying the time period relative to the common time reference over which to filter the mapped datasets.

15. The method of claim 13, further comprising extracting the datasets from both a multidimensional data source and a tabular data source.

16. The method of claim 13, further comprising mapping the time dimensions to a common set of time aggregations and to a common calendar.

17. The method of claim 13, further comprising mapping a single time member to a reference date and configuring offsets from the reference date for multidimensional data.

18. The method of claim 13, further comprising defining time dimensionality on data-time columns in tabular data.

19. The method of claim 13, further comprising simultaneously slicing the datasets using a same time intelligence filter and choosing one or more data sources on which to base the filter.

20. The method of claim 13, further comprising inputting syntax to filter, parsing the syntax, resolving the syntax to an expression for the data sources relative to a current date.