Calculated object class properties are defined with a query which generates a property value automatically. The query is executed whenever a user accesses a view displaying the calculated property. From a user perspective, calculated properties are handled identical to any ReadOnly object class property. They can be displayed in graphics, data workbenches and content areas to inform the user about important data about the objects of an object class.
The functionality provided by calculated properties is similar to the one provided by calculated indicators. Calculated properties offer additional advantages. They can be used to calculate values which are not related to evaluation and can return a date or a string. In addition, they provide reliable display of up-to-date values without users having to trigger update via a button interaction. Indicators shall be used instead of calculated object class properties if the use case is evaluation or if the query required to calculate the result is complex. Only simple queries can be defined for calculated object class properties for performance reasons.
Technically, the definition of a calculated property defines a database view which is updated with current values at runtime. The name of the database view is identical to the value of the Tech Name Default attribute of the calculated property. The database view consists of the two columns: , and VALUE.
- The REFSTR column the value of the REFSTR object class property of the object the value is calculated for.
- The VALUE column stores the calculated value.
Calculated object class properties cannot be included in Alfabet query language. You can read them via SQL queries. To return the name of the current object and the value of the calculated property for the object a user is currently working with, you can define a query like the following:
- SELECT object.name, calcprop.VALUE
- FROM ObjectClassTechName object
- INNER JOIN CalculatedPropertyTechNameDefault calcprop ON calcprop.REFSTR = object.REFSTR
- WHERE object.REFSTR = @BASE
- In Alfabet Expand, go to the Meta-Model tab.
- Expand the node of the object class.
- Right-click the Calculated Properties node and select Create New Calculated Property.
- Define the technical name of the object class property in the Property Name field. Click in the Partial Technical Name field to define the part of the database view name which is variable. The name of the database view is:
NameOfObjectClass_PartialTechnicalName
- Click OK.
- Set the attributes:
- Caption: Define a caption for display on the Alfabet user interface.
- Property Type:
- Property Type: Select the value type of the calculated object class property. Depending on the object class property type, other attributes become available to provide additional settings for the value type:
- Size: For String properties, define the maximum allowed number of characters.
- Precision: For Real properties, define the maximum allowed number of decimals.
- Enumeration: For Integer properties, optionally assign an integer enumeration to display a string instead of the integer on the user interface. For String properties, optionally assign an enumeration to apply styling to the values.
- Calculation SQL Query: Define a native SQL query returning objects of the object class the calculated object class property is defined for. The returned dataset must consist of two columns in the given order and definition:
- The first column must be called REFSTR and must return the REFSTR object class property.
- The second column must be called VALUE and must return the calculated value in the data type defined with the Property Type attribute.
- The query must return one line per object only with the exception of queries defined for a calculated reference array. If a reference array is calculated, the query must return one row for each reference in the array.
The following query returns the accumulates costs of applications over the complete lifecycle. It returns one row per application:
- SELECT app.REFSTR AS REFSTR, (SELECT SUM(bv.VALUE) FROM BUDGETVALUE bv WHERE OWNER = app.REFSTR AND bv.MONETARYCODEID ='Current') AS VALUE
- FROM APPLICATION app
The following query returns the applications assigned to a demand via the demand architecture as a reference array. The query returns multiple rows per demand:
- SELECT dem.REFSTR AS REFSTR, app.REFSTR AS VALUE
- FROM DEMAND dem, DEMAND_ARCH da, APPLICATION app
- WHERE da.DEMAND = dem.REFSTR
- AND da.OBJECT = app.REFSTR
- You cannot use Alfabet parameters in the query.
- You cannot use Alfabet instructions in the query.
- Access in User Interface: Define whether the calculated property shall be available by default on the user interface. To hide the calculated property by default, select NoAccess . To show the calculated property, select ReadAccess. This value can be overwritten in the class settings.
- Property Group: Select a property group the calculated object class property shall be added to. The calculated object class property will then be visible in class-based content areas of the object class which include the property group.
- Comments: Optionally enter a comment explaining the purpose of the calculated object class property to Alfabet Expand users.
- Hint: Enter a comment explaining the purpose of the calculated object class property to the end user. The hint will be visible as tooltip on the user interface:
