2
2
.. i18n: Defining Measure
3
3
.. i18n: ================
8
9
.. i18n: :ref:`Measure <measure-link>` are the fact or quantitative values. It comes from the fact table configured in the cube.
10
12
:ref:`Measure <measure-link>` are the fact or quantitative values. It comes from the fact table configured in the cube.
12
14
.. i18n: We will make the measure for the same example. Measure type specifies whether it will be column base or sql expression based.
14
17
We will make the measure for the same example. Measure type specifies whether it will be column base or sql expression based.
20
24
.. i18n: .. image:: images/measure1.png
23
28
.. image:: images/measure1.png
26
31
.. i18n: SQL Expression Based:
30
36
.. i18n: .. image:: images/measure2.png
33
40
.. image:: images/measure2.png
36
43
.. i18n: 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.
38
46
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.
40
48
.. i18n: .. image:: images/measure3.png
43
52
.. image:: images/measure3.png
46
55
.. i18n: So finally measure will lool like:
48
58
So finally measure will lool like:
50
60
.. i18n: .. image:: images/measure4.png
53
64
.. image:: images/measure4.png