Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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

Pooja_123
Rank 4 - Community Specialist
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.
0
Answers
-
can anyone pls suggest why I am not getting filtered data
0 -
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.
0