prediction patterns

Brian Crampton — Thu, 21 Jun 2007 15:10:59 +0100

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

Prediction Patterns

Jamie — Thu, 21 Jun 2007 12:37:07 +0100

Is it possible to produce a report that would list all Prediction Patterns in Open Orders that are used only at specific specified sites?

Thanks in advance

Jamie

Talis Developer Network - Prediction Patterns - Comments

prediction patterns

Prediction Patterns