Abstract: In one embodiment the present invention includes a computer-implemented method for data cleansing using rule based formatting. The method includes tokenizing and parsing a first input data and a second input data. The method further includes including a first token in a first output data if a first formatting rule component in a formatting rule is a first valid index to said first tokenized input data. The method further includes including a second token in a second output data if said first formatting rule component in the formatting rule is a second valid index to said second tokenized input data. The method further includes formatting said first output data and said second output data according to the formatting rule.

Abstract: A computer readable storage medium includes executable instructions to supply, in an editor mode, a first set of data modeling objects in a document. A user request to enter a print preview mode is accepted. The print preview mode is entered while the editor mode remains active. The document is applied to a page layout with a set of pages. A set of pages to print are specified, where individual pages in the set of pages to print contain a subset of data modeling objects in the first set of data modeling objects.

Abstract: A computer readable medium stores executable instructions to specify a report with a report field for displaying information. An assessment of information that will be potentially displayed in the report field is performed. The report field is sized in accordance with the assessment.

Abstract: A computer readable storage medium includes executable instructions to receive a selection of two or more data source tables from one or more data sources, determine a data source table that defines keys, and receive mapping information that defines one or more column relationships between the data source table and a second data source table. Relationship structures between the data source tables are analyzed. The data source tables and the relationship structures are graphically represented in a sequential order where the order in which the data source tables are depicted is based on a depth of a relationship between the data source table that defines keys and a second data source table.

Abstract: A computer readable medium comprises executable instructions to form a list of parameters for a report. The list of parameters is compared to existing lists of parameters. A selected list of parameters is designated. A report is generated with the selected list of parameters.

Abstract: A computer readable storage medium includes executable instructions to receive context information specifying dimensional criteria defining a first value in a first data source. A context transfer to a second value in a second data source is generated based upon the dimensional criteria. The context transfer is performed in accordance with a translation model with a translation map for mapping between multiple data sources. The second value is supplied.

Abstract: An abstract query is received for querying data sources for a combined hierarchical dimension having at least one hierarchy. The abstract query is mapped into data source specific queries by generating context expressions according to the at least one hierarchy. The data source specific queries are executed in an order according to the at least one hierarchy to produce value results for the combined hierarchical dimension.

Abstract: A computer implemented method includes forming column range-bands, generating row range-bands, and establishing global range-bands in conjunction with the column range-bands and the row range-bands.

Abstract: A computer readable medium stores executable instructions to receive a Multidimensional Expressions (MDX) query. The MDX query is recursively rationalized to form a rationalized query. The rationalized query is applied to a multidimensional data source to produce query results. The query results are returned.

Abstract: A computer-readable medium is configured to receive a report processing request at a hierarchical report processor. The hierarchical report processor includes a parent process and at least one child process executing on a single processing unit, and is configured to process the report processing request as a task on the single processing unit.

Abstract: An apparatus to identify patterns in a multi-dimensional database is described. In particular, a computer-readable medium to direct a computer to function in a specified manner is provided. The computer-readable medium comprises instructions to automatically identify a plurality of patterns associated with data comprising the multi-dimensional database and instructions to indicate the plurality of patterns that are identified. Exemplary patterns that can be identified include an outlier pattern, a step pattern, a random pattern, a trend pattern, and a periodic pattern.

Abstract: A computer readable storage medium includes executable instructions to invoke a rapid application development graphical user interface to define fields associated with a set of objects. The creation of new objects derived from the set of objects is facilitated using the rapid application development graphical user interface to select existing fields of the set of objects and define new object fields. Tabs are associated with the new objects. A set of tabs is selected to create a new application.

Abstract: A report publication system includes a first set of report management servers defining a first cluster supporting a common report management architecture. A first set of client machines operate in accordance with the common report management architecture. The first client machines are configured to access the first cluster. A second set of report management servers defines a second cluster supporting the common report management architecture. A second set of client machines operate in accordance with the common report management architecture. The second client machines are configured to access the second cluster. A first client machine of the first set of client machines invokes a report on the first cluster to form a published report with a designated destination address. The published report is exchanged between the first cluster and the second cluster via the Internet in accordance with the destination address.

Abstract: A computer readable storage medium includes executable instructions to receive hierarchical data. A schema for the hierarchical data is also received. An entity relationship model for the hierarchical data is generated. A semantic abstraction associated with the entity relationship model is defined. An abstract term representing an underlying data element within the hierarchical data represented by the semantic abstraction is also defined.

Abstract: A Relational Database Management System (RDBMS) having any arbitrary structure is translated into a multi-dimensional data model suitable for performing OLAP operations upon. If a relational table defining the relational model includes any tables with cardinality of 1,1 or 0,1, the tables are merged into a single table. If the relational table is not normalized, then normalization is performed and a relationship between the original table and the normalized table is created. If the relational table is normalized, but not by dependence between columns, such as in the dimension table in a snowflake schema, the normalization process is performed using the foreign key in order to generate the normalized table. Once the normalized table is generated, OLAP measures are derived from the normalized relational table by an automated method.

Abstract: A computer readable medium is configured to receive an identification of a plurality of data records, where each data record corresponds to one of a plurality of data record schemas represented in COBOL, and each data record schema corresponds to one of a plurality of standardized data record schemas. The computer readable medium is further configured to specify one of the plurality of standardized data record schemas as a selected standardized data record schema, and to process the plurality of data records based on the selected standardized data record schema.

Abstract: A computer readable storage medium includes executable instructions to associate two or more data sets with two or more vertices in a Venn graph. An intersection of the two or more data sets is associated with a vertex in the Venn graph. A plurality of outliers is associated between the two or more data sets and the intersection of the two or more data sets with a plurality of vertices disposed between the two or more vertices and the vertex in the Venn graph.

Abstract: A computer-readable medium includes executable instructions to analyze a repository of individual reports to generate a consolidated data set, where the consolidated data set includes data from different individual reports. The consolidated data set is augmented with metadata. The consolidated data set and metadata are inserted within an electronic document.

Abstract: A computer readable medium stores computer executable instructions to receive a collection of composite objects. An aggregate dataset that includes a portion of the contents of object instances in the collection of objects is created. The aggregate dataset is passed to a report server. A report that includes data from the aggregate dataset is accepted.

Abstract: A computer readable storage medium includes executable instructions to retrieve a dataset from a data source, where the dataset includes a first set of categories. A data structure that represents the dataset is built. A first set of merit values for the first set of categories is calculated. The first set of categories is ordered based on a criterion. The first set of categories is returned.