41 results about "MultiDimensional eXpressions" patented technology

A method of transforming queries based upon an entity / relationship schema into multi-dimensional expression queries is provided. The method comprises matching an object referenced in an entity / relationship schema based report specification to a corresponding object in the entity / relationship schema, the corresponding object adorned with associated multidimensional metadata; adding the associated multi-dimensional metadata to the object referenced in the entity / relationship schema based report specification; translating the entity / relationship schema based report specification into a multi-dimensional expression query; and retrieving directly all data required to populate a report output of the entity / relationship schema report specification.

The subject invention pertains to systems and methods that facilitate development and debugging of calculations in a multidimensional data environment or model. Data cube calculation scripts, including those provided in MDX (Multidimensional Expressions), can be executed or applied incrementally. Breakpoints can be set with respect to a calculation script and the cube state can be viewed and queried via a user interface. Users are enabled by the subject systems and methods to step through calculation scripts, identify the effects on a cube, and alter the script if the desired results failed to occur. In addition to debugging, the systems and methods can be employed for initial development of scripts.

A business intelligence (BI) system which includes the ability to extend its functionality outside of the project life cycle by means of specific content. Complex multidimensional queries are interpreted as trees of atomic sub-expressions that are combined in a parse-tree-like structure to form the overall query. Each sub tree is valid in isolation when provided with the proper context. Any sub tree can be an expression template, stored as application content, which at generation time uses simple text substitution with instance specific parameters to produce multidimensional expression syntax. The system includes a sophisticated type system and semantic layer that hides the user from the complexities inherent in working with OLAP databases. A business intelligence expert can provide type and semantic cues for each expression template, held as content. The content expression templates are then exposed in the application primarily through a context menu that is filtered for appropriateness, but also in an explorer tree, toolbars, menus and submenus. The functionality from a users perspective is integral to the application. An iterative processing capability to complement these expressions is provided by means of OLAP database stored procedures held as application content. Building on the above, workflow content allows business users to extend the application by creating expert-system-like guided analyses and processes. Of key significance to this innovation is the concept that the expression templates, stored procedures and workflows are application content, and therefore redistributable and unshackled from the classic software development lifecycle and the cost and expertise associated.

A method and program product for automatically generating reports matching user interests represented in a dynamically adjusted user interest analytic model (UIAM). A Multidimensional Expressions (MDX) query is generated based on a user visit to a business intelligence application. Based on initial user visit(s), a cube-based UIAM is constructed by including a representation of a first set of user interest(s) in a first set of UIAM item(s). The cube-based UIAM is transformed into a data warehouse-based UIAM. Based on subsequent user visit(s), UIAM items are updated to represent a second set of user interest(s) and UIAM item scores are adjusted to specify how frequently and recently user interests are indicated by the user visits. An update of data in the data warehouse is detected. Reports representative of user interest(s) represented by the updated UIAM items having the top k scores are generated.

The present invention relates to data processing systems and methods to facilitate debugging, development and execution of multidimensional database queries, such as MDX (Multi-Dimensional eXpressions), for a multidimensional database structure on a computer architecture running on a server, such as an OnLine Analytical Processing Server (OLAP). The expression or query can be broken down and executed incrementally and associated with contextual information which can be viewed by an end-user via an understandable user interface. The advantage is the drastic simplification of very complex computations, giving the user a perspective not available till now. This allows users to better understand multidimensional queries, find errors that occur in the execution and correct such errors.

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.

This invention discloses one cross analysis process system method to process non vacuum data, which comprises the following steps: a, analyzing defined multi-dimension expression to get index axis original range; b, when only considering physical data, browsing the said original range each member combination and filtering the one dimension data to get initial two dimensional form; c, browsing the said two dimension each line or row units and filtering them to get needed two dimensional form. This invention also discloses one device to analyze process system for non-hollow data of cross machine.

A multidimensional operation provider is provided for processing a multidimensional query against a relational datasource. The multidimensional operation provider comprises a query interceptor, a query decomposer and a query replacer. The query interceptor detects and intercepts a multidimensional query that is issued against one or more relational data sources. The query decomposer decomposes expressions of the multidimensional query into one multidimensional expression and / or one or more relational expressions. The query replacer replaces the multidimensional query with a stack of operations expressed by the decomposed multidimensional expressions and / or the relational expressions.