Skip to content

Oracle Communities

Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
Oracle Analytics Cloud May 2025 Update The Oracle Analytics Cloud (OAC) May 2025 update enhances how users generate insights, engage with data, and distribute content
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Transactional Business Intelligence

Categories

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

Agent Condition Evaluates to False Despite Analysis Returning Rows

Received Response

11

Views

1

Comments

Basti

Basti Rank 2 - Community Beginner

Feb 27, 2025 7:04AM in Oracle Transactional Business Intelligence

Hi everyone,

I'm setting up an agent in Oracle BI with a condition based on an analysis. The configuration is as follows:

Create condition based on: Analysis
Condition Data: (Path to the analysis)
True If Row Count: is greater than 0

The issue:
✅ When I run the analysis independently, it returns rows.
❌ However, when I test the agent’s condition, it evaluates to False.

I've confirmed that the analysis produces output, so I’m unsure why the agent is not detecting it.

Possible Causes I'm Considering:

Caching Issue – Would clearing the BI cache help resolve this?

Row Count Handling – Does the agent interpret row counts differently (e.g., should I try "greater than or equal to 1")?

Has anyone encountered this issue before? Any ideas on what might be causing the agent to evaluate the condition incorrectly?

Thanks in advance for your help!

Tagged:

0

Answers

Bhaskar Konar Rank 8 - Analytics Strategist

Feb 27, 2025 8:40AM
Agent Condition Evaluates to False Despite Analysis Returning Rows
Basti
Feb 27, 2025
Hi everyone,
I'm setting up an agent in Oracle BI with a condition based on an analysis. The configuration is as follows:
Create condition based on: Analysis
Condition Data: (Path to the analysis)
True If Row Count: is greater than 0
https://us.v-cdn.net/6037859/uploads/6SFNGZZMQF3Y/415b49fc-10d3-4295-b920-a23c3206560f-png.png
https://us.v-cdn.net/6037859/uploads/E711IGBSS7PG/cb59b501-4dae-4e47-86cb-35bd02bbd9c5-png.png
The issue:
✅ When I run the analysis independently, it returns rows.
❌ However, when I test the agent’s condition, it evaluates to False.
I've confirmed that the analysis produces output, so I’m unsure why the agent is not detecting it.
Possible Causes I'm Considering:
Caching Issue – Would clearing the BI cache help resolve this?
Row Count Handling – Does the agent interpret row counts differently (e.g., should I try "greater than or equal to 1")?
Has anyone encountered this issue before? Any ideas on what might be causing the agent to evaluate the condition incorrectly?
Thanks in advance for your help!
View Post

Hi @Basti,
If the report in condition is returning any row when executed individually, the row count should be greater than '0'.
Also if you execute the report individually first and then check the condition from the agent it should not be impacted via Cache as the cache holds results for the exact same report.
Couple of Questions:
Can you please double check the report path for the both cases? wanted to make sure same copy of the report is getting checked. So it should be the same for agent condition and individual execution.
Is the user same for individual execution and execution via agent? If it is not a same user then it might be due to role etc. the same report is behaving differently for the different users.
Also please try clearing browser cache & cookies, logout close the browser and log back in and then execute the agent condition to see if it is returning any rows
Thank You!
0