In my previous two blogs, I have made a start with the study of the BAM components. I have started with the Data Objects (BAM Data Objecten, BAM Calculated Fields). In this post I will talk about Queries.
From the Oracle Documentation:
A business query or query is a request for data that matches specified conditions. A query can fetch from a data object once, on a schedule, or continuously.
A Flat SQL Query is a simple table of data fields and their values. You select the data object and then select the data fields.
A Group SQL Query query is an analysis of one or more numeric data fields, called measures, grouped by non-numeric data fields called dimensions. For example, a group SQL query might analyze cases grouped by department. You select the data object and then select the measures and dimensions.
A Tree Model Query, written in SQL, is an analysis of one or more measures grouped by a hierarchy of dimensions. For example, a tree model query might analyze cases grouped by Judicial system, Department, Team and Employee. You select the data object and then select the measures and a hierarchy.
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.