...
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.
Saving and Restoring BIA Projects
Working with BI Accelerator Project files enables you to save all customizations you may have made during the Advanced step of the BIA Wizard.
When you at a later point need to re-run the BI Accelerator, this Project file may be re-opened to restore all customized settings.
| HTML |
|---|
<iframe src="https://player.vimeo.com/video/128364546" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe> |
Visual Studio Solution
If, for any reason, you need to manually modify the contents of the cubes, dimensions, measures or SSIS packages created from the BI Accelerator, first, you will need to create a Visual Studio solution containing the SSAS and SSIS projects.
| HTML |
|---|
<iframe src="https://player.vimeo.com/video/106379797" noborder="0" width="800" height="450" allow="fullscreen" scrolling="yes" seamless></iframe> |