...

<iframe src="https://player.vimeo.com/video/128364547" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>

User Defined Measure

The BI Accelerator comes with a number of useful default measures, directly out of the box. On the Advanced step of the BIA Wizard, you have the option to add further User Defined Measures, simply by selecting them from the available transactions (fact) tables.

<iframe src="https://player.vimeo.com/video/128461610" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>

Measure from Calculated Column

You can create a new measure from a calculated column. The calculated column is added to the transactions (fact) table as a new column. E.g. if each transaction contains two measures already, a SalesQuantity and a SalesAmount per transaction, you may calculate a TotalSalesAmount as SalesQuantity * SalesAmount.

Important: It is important to understand that a Calculated Column will contain calculated data per transaction. You may also think of a Calculated Column as a calculation that is done before processing of data - i.e. before data has been summarized.

<iframe src="https://player.vimeo.com/video/128461611" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe>

Measure as a new Calculcation

You can create a create a calculated measure as an expression. The measure can be based on logical expressions which may include other measure columns or other custom content. E.g. a calculated Profit measure may be expressed as a subtraction between two existing measure columns, Revenue and Cost.

Important: It is important to understand that the result for a Calculated Measure will be calculated at query time. You may also think of a Calculated Measure as a calculation that is done after processing of data - i.e. after data has been summarized.