I have to create a data object in BAM on multiple data objects by looking at some condition that means, I have to generate a data from these multiple data objects to select only few records and few fields. Is it possible?
I am not sure about creating dataobjects from multiple dataobjects, we can do one thing we can use lookups(refer below link)
apart from this we can create reports from multiple data objects.finally need to show dashboards out of different datasource(Data Objects).
This is helpful, but I am confused about "Fields to match from lookup object" and "Fields to match from this data object".
Over here, we need to select the dataobject and then we have to select the field from this data object, right. but what does it mean by "Fields to match from this data object".. why is it? that means, we have to map the current data object field to one of the fields in the another data object?
My requirement is as follows
Data object A
1 ABC 2345
2 DEF 5678
3 GHI 9012
So, in Data object B, I should have the data as follows
Lookup in BAM follows the same rule as LEFT OUTER JOIN in SQL. In the Data Objects lookup.
BAM Active Data Cache uses the LEFT OUTER JOIN to combine records from two Data Objects. The query result set includes all the fields from the Lookup Data Object. It is a best practice to create aLookup Data Object that contains fields, which are only required for the lookup operations.
Note:Creating a Lookup Data Object is exactly the same as creating a normal Data Object. However, you must not add any lookup fields into Lookup Data Objects.