Greetings all,
This has me puzzled. I am working in BO 4.2 and using an IDT multisource universe so Data Federator is involved.
Starting with the simple query where all objects are dimensions:
select A.DATE, A.KEY, B.STRING, B.KEY
from A inner...
I can't explain this. You are also missing the handle (4 vertical dots on the left side of each object), that allows you to drag the object up or down. I suspect we are on different versions of BO and I have never encountered this issue. Maybe someon...
When you use the semi-colon there, it includes that as part of the pattern. Matches Pattern only accepts 1 value. I cannot explain how the extra ANDs are getting there. Simply dragging your object into the filter area 3 times, setting each to matches...
Sorry for all the revisions. Its actually the ANDs between each condition that don't belong. Once you remove those, you should be able to double click and change that AND to an OR. It sometimes is easier to remove all the conditions and add them a...
You are not looking for a row that matches all of those patterns so just add each of your conditions with an OR instead of an AND. There is no reason to group them. You want: Inventorynumber matches pattern "AB%"
OR Inventorynumber matches patter...
