Assign Compound Data Elements to  View Columns

Views are data-interface specifications between databases and business information systems. A view consists of a relationship between one or more DBMS Column to View Column relationships, View Columns that are the result of a combination of the values from DBMS columns to comprise the value of the View Column, and the specification of the process that accomplishes the transformation.

When View Columns need to be the result of a compound value set it must be specified in terms of a Compound Data Element. That is because Data Elements are to be both non-derived and atomic. The process of manufacturing this relationship between a Compound Data Element and a View Column is accomplished by:

• Start the View Database Model Metabase System Module
• Select the DBMS
• Enter User Name and Password
• Select the Menu Item, View Data Models, then the subordinate item, Assignments and then Assign Compound Data Elements to View Columns
• Select Compound Data Element
• Select a View
• Tag one or more View Columns
• Press the Build button to create the assignment.

For Sales and Corporate: 1-301-249-1142 Whitemarsh@Wiscorp.com

Whitemarsh Information Systems Corporation

 Bowie, Maryland 20716 USA

Copyright 1981 - 2020 Whitemarsh Information Systems Corporation
Proprietary Data, All rights Reserved