Systems and methods for providing custom or calculated data members in queries of a business intelligence server
First Claim
1. A method for enabling calculated members within a query, said method comprising:
- storing a set of dimension members in a data source, said data source having a connection to a business intelligence (BI) server;
receiving, by said BI server, a query that contains a calculated member as a parameter, said calculated member being defined by a calculated member expression including at least two of said dimension members and an arithmetic operator;
parsing and validating said query by the BI server;
rewriting the query by the BI server to retrieve the data for the calculated member using an interface of said data source, wherein the rewritten query uses a replacement expression derived from the calculated member expression; and
executing the query against the data source.
1 Assignment
0 Petitions
Accused Products
Abstract
A business intelligence (BI) server and repository are described which support a set of customized and/or calculated data members. In accordance with an embodiment, the BI server maintains a connection to a plurality of data sources which may store a set of dimension members. The data source can be relational, file storage based, multidimensional and other types. In accordance with an embodiment, the BI server can accept queries from the user that contain calculated members as a parameter. The calculated member is defined by an expression including multiple dimension members and one or more arithmetic operators. The BI server can parse and validate the query and rewrite the query for the data source. After the query is rewritten and optimized, it is executed against the data source and a set of results is received.
23 Citations
20 Claims
-
1. A method for enabling calculated members within a query, said method comprising:
-
storing a set of dimension members in a data source, said data source having a connection to a business intelligence (BI) server; receiving, by said BI server, a query that contains a calculated member as a parameter, said calculated member being defined by a calculated member expression including at least two of said dimension members and an arithmetic operator; parsing and validating said query by the BI server; rewriting the query by the BI server to retrieve the data for the calculated member using an interface of said data source, wherein the rewritten query uses a replacement expression derived from the calculated member expression; and executing the query against the data source. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10)
-
-
11. A system for enabling calculated members within a query, said system comprising:
-
a data source storing a set of dimension members; and a business intelligence (BI) server that receives a query containing a calculated member as a parameter, said calculated member being defined by a calculated member expression including at least two of said dimension members and an arithmetic operator; wherein the BI server parses and validates the query; rewrites the query to retrieve the data for the calculated member from said data source, wherein the rewritten query uses a replacement expression derived from the calculated member expression; and executes the query against the data source. - View Dependent Claims (12, 13, 14, 15, 16, 17, 18, 19)
-
-
20. A computer-readable storage medium storing a set of instructions, said instructions, when executed by one or more processors, causing the one or more processors to perform the steps comprising:
-
storing a set of dimension members in a data source, said data source having a connection to a business intelligence (BI) server; receiving, by said BI server, a query that contains a calculated member as a parameter, said calculated member being defined by a calculated member expression including at least two of said dimension members and an arithmetic operator; parsing and validating said query by the BI server; rewriting the query by the BI server to retrieve the data for the calculated member using an interface of said data source, wherein the rewritten query uses a replacement expression derived from the calculated member expression; and executing the query against the data source.
-
Specification