In PerformancePoint Expression Language (PEL), operators let you perform the following actions:
Change data, either permanently or temporarily.
Search for values or objects that meet a specified condition.
Implement a decision between values or expressions.
Test for specific conditions before you run a rule.
You can build an expression by using operators to combine several smaller expressions. In these complex expressions, PEL evaluates the operators in order based on the same definition of operator precedence that is used by Microsoft SQL Server 2005 Analysis Services (SSAS). PEL performs operations with greater precedence before it performs operations with lower precedence.
PEL implicitly converts an object to a different type when that object is used in an expression that requires a different type. For more information, see the topic Type conversions (PEL).
PEL supports the operators listed in the following table.
In This Section
- Understanding operator precedence
Describes the order of operators that the compiler imposes on operators.
- Arithmetic operators
Perform addition, subtraction, multiplication, division, and exponentiation.
- Assignment operators
Assign a value to a variable, or associate a result set column with an alias.
- Comparison operators
Compare a value against another value or an expression.
- Logical operators
Test for the truth of a condition, such as AND, OR, NOT, and XOR.
- Unary operators
Perform an operation on one operand.
- Range operators
Perform an operation that returns a set of members with a specific endpoint or endpoints.