Abstract: A system may include a database of physical data tables, a logical database schema of logical entities associated with the physical data tables, and an abstraction layer comprising a plurality of dimension objects mapped to the logical entities, at least one of the plurality of dimension objects comprising one or more properties associating the at least one of the plurality of dimension objects to one or more others of the plurality of dimension objects.

Abstract: A system includes reception of text, extraction of a plurality of linguistic entities and associated linguistic entity categories based on the text; determination of one or more semantic objects of a semantic layer based on the linguistic entity categories, and generation of a query of the semantic layer based on the plurality of linguistic entities, the associated linguistic entity categories, and the one or more semantic objects.

Abstract: A system includes determination of a name of a semantic object associated with a semantic layer, determination of a linguistic entity category associated with the name, and storage, in association with the semantic layer, of an association between the semantic object and the linguistic entity category. Also included may be determination of a plurality of values associated with the semantic object, and creation of a custom linguistic entity category associated with the semantic object and comprising a plurality of entities, wherein each of the plurality of entities corresponds to a respective one of the plurality of values.

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 storage medium includes executable instructions to receive a semantic abstraction describing at least one underlying data source. The semantic abstraction includes at least one dimension with at least one dimension value. Unstructured text is parsed into parsed text units. A dimension value is matched to a parsed text unit to form matched content. An indication of the matched content is stored.

Abstract: An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.

Abstract: A computer readable medium with executable instructions to analyze a report value, includes executable instructions to select a report value and identify the formula evaluated to produce the report value. Formal parameters associated with the formula are determined. The actual parameters used to compute the report value are located. The formula, the formal parameters and the actual parameters are then displayed.

Abstract: A computer readable medium is configured to receive a query, to map the query to an unstructured data source, to dispatch a request based on the query to the unstructured data source, to aggregate data returned by the unstructured data source in a structured data store, and to issue the query against the structured data store.

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 system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.

Abstract: A system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.

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 includes a report generator configured to process a current version of a data set to generate a report including a data item. The computer-readable medium also includes a report data change tracker configured to identify a change in the data item with respect to a previous version of the data set. The computer-readable medium further includes a report data change presenter configured to superimpose an indication of the change onto the report.

Abstract: An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.

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: An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.

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 system and a method for creating an analytical report on top of a multidimensional data model built on top of a relational or multidimensional database. The database operates in a computer system and provides returned values responsive to queries. Such a query is generated automatically and is deduced from a report definition. According to one embodiment, a report specification is used by the system and method of the present invention is able to defer the initial query of the data source, as is the case with conventional reporting tools and methods, until after the report has been defined. That is, the manner in which a analytic report is defined provides for an automatically generated query. Once the report has been defined, the data to populate such a report is retrieved to build the document.

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: An analytical reporting functionality provides full-fledged dynamic reporting capabilities on top of a multidimensional data model. A GUI facilitates replicating the same reporting data for various elements of a dimension. Additionally, direct interaction with the report to perform OLAP-style is enabled.