Prediction Patterns

The short answer is that it can't be done in Decisions as the universe does not look at the tables required.

But thanks to a colleague the following SQL will list the patterns by delivery site. The delivery site may differ from the shelved location.

select NAME, LOCATION_ID
from ISSUE_SEQUENCE, SEQUENCE_WORK_LINK
where ISSUE_SEQUENCE.ISSUE_SEQ_ID = SEQUENCE_WORK_LINK.ISSUE_SEQ_ID
group by LOCATION_ID, NAME

This could be run as a piece of freehand SQL in BusinessObjects Reporter/Desktop Intelligence.

Thanks

Brian Crampton
Developer, Talis