A function that projects and aggregates data of another function. Formula and Data Selection are other functions that can be used under the View function.
A subfunction of the Environment function must provide data (source data) as input to be projected or aggregated using the View Function.
In this view type, it is possible to display or project data from a function.
Steps
On the View page, choose an Input from the list of functions. The characteristics and key figures of that function will be entered automatically in the Fields table and the View Type will be Projection by default.
Choose the fields that are relevant for projection. Set the View Field Category to:
Field - to project or include the field for display
Calculated Attribute - the original data will not be projected, rather the user has an option to create a formula for the chosen field
Not Used - if the field is not meant for projection
If the changes are meant to be preserved, choose Save.
To generate, choose Generate.
For a preview, choose Test.
Customer |
Product |
Quantity |
Amount |
---|---|---|---|
CN001 |
PROD01 |
2 |
300 |
CN002 |
PROD01 |
3 |
400 |
CN001 |
PROD03 |
4 |
500 |
View Settings:
Customer and Quantity to project original data from source data by using View field
Category “Field”
Product is not needed for projection and will be set to “Not Used”
Field |
View Field Category |
Formula |
Selection |
---|---|---|---|
Customer |
Field |
||
Product |
Not Used |
||
Quantity |
Field |
||
Amount |
Calculated Attribute |
"Quantity" + 2 |
Projected Result
Customer and Quantity project original data (field)
Product is not projected (not used)
Amount contains calculated data – the formula is “Quantity” + 2, where “Quantity” is data from the Quantity field. Data from source was ignored (300, 400, and 500).
Customer |
Quantity |
Amount |
CN001 |
2 |
4 |
CN002 |
3 |
5 |
CN001 |
4 |
6 |