Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Comma separated value input in presentation variable - OTBI report Issue
Hello Team,
We have a requirement to have a comma separated order numbers as an input variable and have data filter criteria driven by this input to help them manage Order backlog.
We are currently utilizing presentation variable and adding below SQL criteria to implement this requirement, but facing issues during report execution ( [nQSError: 27002] Near <with>: Syntax error (HY000) ).
SQL string used to decode:("Order Header Detail"."Order Number" IN (with rws as ( select @{variables.Order_Number} str from dual) select regexp_substr (str,'[^,]+',1,level) value from rws connect by level <= (length ( str ) - length ( replace ( str, ',' ) ) + 1)))
Reaching out to this group for guidance and alternate options utilized to implement similar requirement.