nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE Actionable Agent condition returning false.

Raviteja Anne

Hi All,

I tried to create an agent to send an email based on analysis condition with row count greater than 0, But the condition is returning false. Please see the below screen shot.

But when i go to analysis and tried to run the report it is returning records, not sure why the agent condition is failing to check the row count. please see the below screen shot.

As per my observation, When i put filter on columns in OTBI Analysis report the agent condition is returning false, After removing filter condition then it is returning true. Please see the below screen shot.

Before removing Filter Condition:

After Removing Filter Condition:

Then Agent returning true:

Not sure what is the issue here, But for client requirement filter condition is required to achieve it.

Please help me on it.

Thanks,

Ravi

Find more posts tagged with

Accepted answers

All comments

Joel Acha

Your rpd needs to be modified as the measures haven't been defined as such and you're comparing strings instead of numbers (note the different icon for measures below).

Add aggregations to your measures in the BMM layer to the measures and it should work.

Robert Angel

Please note also that doing any aggregation wise on dimensions rather than facts WILL be erroneous, because OBIEE as standard will make members of dimensions DISTINCT values BEFORE your aggregation, so if you even do a conversion and aggregation to the dimension member in a formula you will still not get the correct numbers.

Joel Acha

To be clear, my reply assumed (should have been clear of that in retrospect) that the OP had a well formed dimensional model with facts and dimensions in the BMM layer. You're right, if there isn't a proper model then the OP has a bigger issue...

Robert Angel

It was a 'general' caveat, not to try to use dimensions as facts - I know it can be tempting to think I can workaround it by....

Raviteja Anne

Hi Joel & Robert,

Thanks for the update,

But our OBIEE with oracle fusion cloud we cant modify the any subject areas in fusion cloud.

Please let me know how to achieve client requirement.

Want to put a filter for analysis Po Amount received 80% of Po Distribution amount.

Thanks,

Raviteja.

Robert Angel

You would need a measure at distribution level for; Qty Ordered and Qtry Received; without these or equivalent then this is not achievable.

Though if you know the underlying tables you could fulfil via a direct database request - if that is an option for you.

You might try asking this on the BI Applications forum, I don't have access to a procurement analytics to provide more detailed answer, though you can also download the data lineage spreadsheet to get a deeper insight into the technical architecture that you cannot alter...

Raviteja Anne

Hi Robert,

Thanks for the update,

Agent is working and returning true after adding "Ordered Quantity" and "Received Quantity" after applying filter.

Not sure what's the difference seems like both amount and quantity columns are aggregate measures only.

Thanks,

Raviteja.