Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Actionable Agent condition returning false.
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
Answers
-
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.
0 -
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.
0 -
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...
0 -
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....
0 -
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.
0 -
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...
0 -
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.
0
