SPECIFICATION OF DATABASE TABLE RELATIONSHIPS FOR CALCULATION
First Claim
Patent Images
1. A method, comprising:
- employing at least one processor configured to execute computer-executable instructions stored in memory to perform the following acts;
specifying a relationship to follow for a specific calculation from multiple relationships between two tables of a database in an analysis expression function and independent of a database query.
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.
-
Citations
20 Claims
-
1. A method, comprising:
-
employing at least one processor configured to execute computer-executable instructions stored in memory to perform the following acts; specifying a relationship to follow for a specific calculation from multiple relationships between two tables of a database in an analysis expression function and independent of a database query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A system, comprising:
-
a processor coupled to a memory, the processor configured to execute the following computer-executable components stored in the memory; a language component configured to identify a relationship to follow for a calculation from multiple relationships defined between at least two tables of a database. - View Dependent Claims (11, 12, 13, 14, 15)
-
-
16. A method of relationship specification, comprising:
-
employing at least one processor configured to execute computer-executable instructions stored in memory to perform the following acts; identifying at least two tables, of database of tables, having multiple relationships defined between the least two tables; specifying a relationship of the multiple relationships to follow for a specific calculation, in an analysis function, and independent of a database query; and defining arguments of the analysis function that identify the relationship, the arguments identify table columns of the at least two tables used in the relationship. - View Dependent Claims (17, 18, 19, 20)
-
Specification