About PerformancePoint Expression Language
PerformancePoint Expression Language (PEL) is a unique language that is designed to create business rules and work with multidimensional information in Planning Server.
PEL is similar to Multidimensional Expressions (MDX) language in many ways. PEL provides a rich and powerful syntax for retrieving and manipulating multidimensional data, such as the data that is stored in cubes on the computer that is running Microsoft SQL Server 2005 Analysis Services.
PEL provides offers the following significant advantages:
The PEL compiler can generate Structured Query Language (SQL) or MDX. In fact, from the same PEL source, you generate both and then compare the results.
Input data can reside in Online Analytical Processing (OLAP) cubes or in relational databases.
Rule calculations can be performed in the cube by using MDX, in a relational database by using SQL, or in main memory by using one of the Planning Business Modeler specialized components.
Results of calculations can be returned without storage, written to fact tables in the relational database, or written to cells in the model.
In This Section
- PEL advantages
Provides a brief introduction to MDX.
- PEL basics
Gives a basic overview of the construction of a simple PerformancePoint Expression Language business rule.
- Comparison of PEL to MDX
Compares features and functionality of PerformancePoint Expression Language and MDX.
- PEL syntax elements
Describes the fundamental elements that make up PerformancePoint Expression Language.
- PEL reference
Provides detailed reference information about PEL statements, operators, and functions.