...

Info

To be clear, it is not mandatory for the table used for the view to have columns named 'PRODUCT' or 'SUBPRODUCT' only. The columns could be named anything, for example PRODUCT CATEGORY, PRODUCT DIVISION, and so on.

Note: To be clear, it is not mandatory for the table used for the view to have columns named 'PRODUCT' or 'SUBPRODUCT' only. The columns could be named anything, for example PRODUCT CATEGORY, PRODUCT DIVISION, and so on.


  • When the $ALL keyword is used for the entitlement criteria

...


To create apps in different formats, you have to link the appropriate view to the app in Canvas Studio. The best view for a particular purpose depends on the information the user needs.

When you create a view in Canvas Studio, the details of the view including the entitlement criteria mapping for the view columns/fields gets stored in the VIEW_COLUMN_DEFINITION table. Please note that Canvas currently enables you to define entitlement criteria at the database level only. However, the defined criteria can be mapped to the View columns in the App Designer or Create View Definition screen in Studio. For more information on configuring Views and Apps, refer the App Configuration section in the Expert Studio Dev Guide or the App Designer document available in Unmail > Canvas Technology > Documents > Release 18.1.0.0.

Following is a sample screen shot of the VIEW_COLUMN_DEFINITION table. In this table, the entitlement criterion (for example, LOAN_CRI) is mapped to the column LOAN_TYPE for the CT_LOAN_SUMMARY_VIEW.

...


Data level entitlement criteria must be defined in this table. Canvas expects that the data level entitlements are mapped to the Product – Sub Product combination and not directly to functions. This goes with the concept that all functions under a Product – Sub Product combination automatically derive the data level criteria applicable. There could be scenarios where a function may not work with any data level criteria. In such cases, the function could be marked as read-only to indicate that scenario.

Following is a sample screen shot of how the entries can be provided in the OO_CRITERIA_TYPE_MASTER table:

...