I am trying to represent an OBIEE data model using erwin. I want to bring in some relationships that require the following.
1.) Use the between operator for dates.
2.) use some function such as LTRIM/SUBSTR on the columns before joining.
3.) Filter the records in the child table before joining. such as MCAL_TYPE=4
Is there a way to represent relationships that would require these kind of operations in Erwin?
Please sign in to leave a comment.