Defining Measure

Measure are the fact or quantitative values. It comes from the fact table configured in the cube.

We will make the measure for the same example. Measure type specifies whether it will be column base or sql expression based.

Column Based:

SQL Expression Based:

In the column based measure we will see select the fact table column from the columns of the fact table define in the cube i.e. sale_order and sale_order_line.

So finally measure will look like: