D Expression Editor Reference

This section describes the Expression Elements that you can use in the Expression Editor.

Topics:

• Data Model Objects

• SQL Operators

• Conditional Expressions

• Functions

• Constants

• Types

• Variables

Data Model Objects

You can use data model objects in expressions, like time levels, dimension columns, and fact columns. To reference a data model object, use the syntax:

"Fact/Dimension Table Name"."Column Name"

For example: "Order Metrics"."Booked Amount"-"Order Metrics"."Fulfilled Amount"

The Expression Elements section only includes items that are relevant for your task, so not all fact tables and dimension tables might be listed. Similarly, time hierarchies are only included if the Time fact table is joined to the current table.