This section explains each of the XML elements and attributes in a design file and how they relate to the settings in the Data Source Designer. Some elements have been added to show structures that did not appear in the example.

Because certain XML elements correspond to objects in the Data Source design, this section refers to XML elements that contain Data Source objects such as sets. This is a short-hand description that means the XML elements contain other XML elements that represent the Data Source objects. 

These definitions in the design correspond to the first five tabs of the Data Source Designer: 


Because the elements under resources refer to database objects, they must be externally consistent with the data source intended for this Data Source.
 
 

The DomEL Syntax

Various components of a Data Source need to compute values based on some expression involving constants, field values, and environment variables. The Data Source Expression Language (DomEL) was created to fill this need. Currently, the following features in XML design files are expressed in DomEL:

• The "on" and "where" clauses of derived tables 

• The "on" clause of join statements 

• Calculated fields 

• Filter expressions in Data Sources and Data Source topics (equivalent to "where" clauses) 

• The "testProfileAttribute" function 

• Row-level security

A DomEL expression is a shorthand way of writing a complex query. When processing a report based on a Data Source, the server interprets DomEL expressions to generate parts of the SQL expression that perform the desired query. Depending on the data policy, either the augmented SQL is passed to the data source, or the server performs a simpler query and applies the DomEL expressions to the full dataset in memory.