Quick reference
The following is a quick overview of the main topics covered in this chapter.
|
Object |
Usage |
Creation |
|---|---|---|
|
Analytic view |
Allows representation of numeric data |
Quick Launch | Analytic View | Create Add base table with numeric field(s) to work with, join any necessary attribute views, activate. |
|
Restricted column |
Copies the value of an existing measure column, only if condition(s) are met |
In view creation screen, in the Logical Join block, right-click on Restricted column and select New. Give name, description, select source column, define restriction column and value, save |
|
Calculated column |
Creates a new column based upon either an existing column, or a hardcoded value |
In view creation screen, Logical Join block, right-click on Calculated column and select New. Give name, description, type. Enter expression to define the column (such as an Excel formula) |
|
Filter |
Only shows certain rows from the base table |
In view creation screen, Data Foundation block, right-click on... |
