Show TOC

View Function

Context

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.

Prerequisites

A subfunction of the Environment function must provide data (source data) as input to be projected or aggregated using the View Function.

View Type: Projection

In this view type, it is possible to display or project data from a function.

Steps

  1. 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.

  2. Choose the fields that are relevant for projection. Set the View Field Category to:

    1. Field - to project or include the field for display

    2. Calculated Attribute - the original data will not be projected, rather the user has an option to create a formula for the chosen field

    3. Not Used - if the field is not meant for projection

  3. If the changes are meant to be preserved, choose Save.

  4. To generate, choose Generate.

  5. For a preview, choose Test.

Example of Projection

Example Data: Data must be provided by choosing an “Input Function” (source data)

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”

Amount to be changed from Field Category “Field” to “Calculation Unit” for formula

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).

Projected Result

Customer

Quantity

Amount

CN001

2

4

CN002

3

5

CN001

4

6