Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
BI Publisher Report filter with multiple criteria
Summary
Needing to add multiple criteria to an OTBI report filter e.g. multiple business unitsContent
When adding a filter to a report created in OTBI I need to add multiple criteria. Example is I need to report on two Business Units - Data Field = Business Unit, Operator = is equal to Value = Manufacturing AND Supply Chain.
I've tried many different ways but have no luck e.g. Value = :
- Manufacturing, Supply Chain
- Manufacturing; Supply Chain
- Manufacturing AND Supply Chain
- Manufacturing OR Supply Chain
What is the format I need to use when want to add more than one criteria into the Value field?
Tagged:
0