Specification of database table relationships for calculation
First Claim
1. A method performed by a system comprising at least one processor coupled to a memory storing machine-executable instructions, which, when executed by the processor, controls the system to perform acts, comprising:
- receiving a data analysis expression comprising a calculation and a relationship to use for the calculation from multiple relationships between data of two tables of a database;
overriding a default relationship of the database with the relationship by setting the relationship as active and other relationships of the multiple relationships as inactive;
retrieving data from the two tables for the calculation based on the active relationship;
initiating execution of the calculation on the data, wherein execution of the calculation comprises evaluating an expression specified by the calculation on the data retrieved from the two tables;
restoring the default relationship after execution of the calculation is complete by setting the default relationship as active and other relationships of the multiple relationships as inactive; and
returning a result of execution of the calculation.
2 Assignments
0 Petitions
Accused Products
Abstract
A relationship amongst multiple relationships between database tables can be specified independent of a query. More specifically, a function (USERELATIONSHIP) can be introduced to the DAX language (Data Analysis Expressions), which provides a way to author formulas that are not evaluated immediately, but that can be evaluated dynamically and concurrently in many different contexts. The function enables a single relationship to be specified in the calculation formula away from the query. This provides a mechanism within the formula that specifies specific relationship(s) that are to be followed when the dynamic expression is evaluated.
14 Citations
20 Claims
-
1. A method performed by a system comprising at least one processor coupled to a memory storing machine-executable instructions, which, when executed by the processor, controls the system to perform acts, comprising:
-
receiving a data analysis expression comprising a calculation and a relationship to use for the calculation from multiple relationships between data of two tables of a database; overriding a default relationship of the database with the relationship by setting the relationship as active and other relationships of the multiple relationships as inactive; retrieving data from the two tables for the calculation based on the active relationship; initiating execution of the calculation on the data, wherein execution of the calculation comprises evaluating an expression specified by the calculation on the data retrieved from the two tables; restoring the default relationship after execution of the calculation is complete by setting the default relationship as active and other relationships of the multiple relationships as inactive; and returning a result of execution of the calculation. - View Dependent Claims (2, 3, 4, 5, 6, 7, 19)
-
-
8. A system, comprising:
-
a processor coupled to a memory, the processor configured to execute computer-executable instructions stored in the memory that when executed, perform the following acts; receive a data analysis expression comprising a calculation and a relationship, from multiple relationships between data of two tables of a database, to employ with respect to the calculation; override a default relationship of the database with the relationship by setting the default relationship as active and other relationships of the multiple relationships as inactive; retrieve data from the two tables for the calculation based on the active relationship, wherein the active relationship enables acquisition of data based on a particular column of matching data in the two tables; initiate execution of the calculation on the data, wherein execution of the calculation comprises evaluating an expression specified by the calculation on the data retrieved from the two tables; restore the default relationship after execution of the calculation is complete by setting the default relationship as active and other relationships of the multiple relationships as inactive; and return a result of execution of the calculation. - View Dependent Claims (9, 10, 11, 12, 13, 14, 20)
-
-
15. A computer-readable storage medium having instructions stored thereon that enable at least one processor to perform a method upon execution of the instructions, the method comprising:
-
receiving a data analysis expression comprising a calculation and an explicit relationship from multiple relationships between data of two tables of a database to employ with respect to the calculation; overriding a default relationship setting of the database with the explicit relationship by setting the explicit relationship as active and other relationships of the multiple relationships as inactive; retrieving data from the two tables for the calculation based on the active relationship, wherein the active relationship enables acquisition of data based on a particular column of matching data in the two tables; initiating execution of the calculation on the data, wherein execution of the calculation comprises evaluating an expression specified by the calculation on the data retrieved from the two tables; and restoring the default relationship after execution of the calculation is complete by setting the default relationship as active and other relationships of the multiple relationships as inactive; and returning a result of execution of the calculation. - View Dependent Claims (16, 17, 18)
-
Specification