Home > About OLAP Programming Lang... > About the OLAP Expression S...
![]() Previous |
![]() Next |
The OLAP Expression Syntax is the language for manipulating dimensional data stored in database objects such as cubes, measures, cube dimensions, attributes, and hierarchies. The OLAP Expression Syntax includes analytic functions, single-row functions, arithmetic operators, and so forth. It is an extension of the SQL syntax. If you have used SQL analytic functions or single-row functions, then this syntax is familiar to you.
You can use the OLAP expression syntax to create calculated measures. All of the built-in calculations, such as Share and Prior Period, are defined using the OLAP expression syntax. You can also create a custom calculated measure that executes an expression.
Related Topics: