Computer-implemented system and method for visualizing OLAP and multidimensional data in a calendar format
AssigneeSAS Institute Inc.
InventorLina Clover
Life of this patent
Estimating the term…
Abstract
Computer-implemented systems and methods for displaying multidimensional data as graphical time-based objects. A system and method could include associating actual calendar units with time dimension members. The association can be based on the time periods and the corresponding time-level information in the cube's time dimension hierarchies. Query results involving time periods and time period analysis are displayed as graph chart objects within the time period's visual presentation.
Claims20
A computer-implemented method for displaying time-based data retrieved from a multidimensional database, comprising:
- receiving a query for retrieving data from a multidimensional database;
- wherein the multidimensional database contains data that is categorized into one or more numerical measures;
- wherein the multidimensional database contains a time dimension which characterizes the one or more numerical measures;
- wherein the time dimension is hierarchically arranged;
- wherein the query contains hierarchical information in order to specify which data is to be retrieved with respect to the hierarchically arranged time dimension;
- associating calendar time units with members of the time dimension;
- wherein the calendar time units are for depiction in a display of a calendar-based graphical display;
- wherein the associating between calendar time units and members of the time dimension is based on time periods of the calendar units and time-level information in the time dimension hierarchy;
- generating display information based upon results obtained through the query upon the multidimensional database;
- wherein the generated display information is for use in providing the calendar-based graphical display that shows the query results as the time periods of the calendar units.
A computer-implemented system for displaying time-based data retrieved from a multidimensional database, comprising:
- a database engine configured to receive a query for retrieving data from a multidimensional database;
- wherein the multidimensional database contains data that is categorized into one or more numerical measures;
- wherein the multidimensional database contains a time dimension which characterizes the one or more numerical measures;
- wherein the time dimension is hierarchically arranged;
- wherein the query contains hierarchical information in order to specify which data is to be retrieved with respect to the hierarchically arranged time dimension;
- software instructions configured to associate calendar units with members of the time dimension;
- wherein the associating between calendar units and members of the time dimension is based on time periods of the calendar units and time-level information in the time dimension hierarchy;
- software instructions configured to generate display information based upon results obtained through the query upon the multidimensional database;
- wherein the generated display information is for use in providing a calendar-based graphical display that shows the query results as the time periods of the calendar units.
A data signal that is transmitted using a network and which is for displaying time-based data retrieved from a multidimensional database, wherein the data signal includes display that is generated by performing steps comprising:
- receiving a query for retrieving data from a multidimensional database;
- wherein the multidimensional database contains data that is categorized into one or more numerical measures;
- wherein the multidimensional database contains a time dimension which characterizes the one or more numerical measures;
- wherein the time dimension is hierarchically arranged;
- wherein the query contains hierarchical information in order to specify which data is to be retrieved with respect to the hierarchically arranged time dimension;
- associating calendar units with members of the time dimension;
- wherein the associating between calendar units and members of the time dimension is based on time periods of the calendar units and time-level information in the time dimension hierarchy;
- generating display information based upon results obtained through the query upon the multidimensional database;
- wherein the generated display information is for use in providing a calendar-based graphical display that shows the query results as the time periods of the calendar units;
- wherein the data signal comprises packetized data that is transmitted through the network;
- wherein the generated display is for display within a browser on a client computer.
Dependencies are inferred from the claim text.