IFSAPPS 9.
We have been using a Business Analytics model to run our sales forecast. This was using Business Opportunities as the Information Source.
One of the filter criteria was DIM_OPP_PROBABILITY.CODE BETWEEN 50 and 100. This basically captured any high probability Business Opportunities.
After we installed UP17 our Business Analytics model stopped working. I believe the issue was that prior to UP17, the field on the Information source was the value in the PROBABILITY_DB field and it has now changed to be just the PROBABILITY field. The issue is that the PROBABILITY field is suffixed by a % sign, so when we use this field in the filter I receive an ‘Invalid Number’ error message. However I have not been able to use SQL in the Filter Criteria to either TRIM or REPLACE the % value out.
Is there a way to point the Information Source back to the PROBABILITY_DB field?