Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP data model is not filtering from requisition number to to requisition number

Received Response
21
Views
2
Comments
Pooja_123
Pooja_123 Rank 4 - Community Specialist
in Oracle Transactional Business Intelligence Forum

when I am trying to filter the from req no and to req no, I am not getting any data in BIP data model query.

Answers

  • Pooja_123
    Pooja_123 Rank 4 - Community Specialist

    can anyone pls suggest why I am not getting filtered data

    image.png
  • Waleed Fetoh
    Waleed Fetoh Rank 3 - Community Apprentice

    Since the Req number is a string, you cannot use the Between operation with a string. However, you can try using the replace or substr functions to remove the "REQ-" before converting the output to a number.