Discussions
Categories
Insight (OBIEE) Video: Creating a prompted filter and using it in an agent
Comments
-
Is there somewhere that can provide tips of values that can be used? For example can I use the value "Last 30 days" against the operator "Less than or equal to"?
-
Is there somewhere that can provide tips of values that can be used? For example can I use the value "Last 30 days" against the operator "Less than or equal to"?
Hi @derek.bell When using the Time Span attributes to filter dynamically, you set the operator to "is equal to". Take a look at this video -
If you want to reach out with some examples where you've wondered this question, hit me up with the questions and we'll create a post to help you and others out.
-
Hi @Alexa Kalapaca-Oracle - I would really like to see the video you linked to above, but it appears to be missing. I am trying to figure out how to set up an agent to email me all form submissions for one form that occurred between 8am the previous day to 8am of the day the report will be delivered (next day) so 24 hours. Would that video help explain how to do that, or do you have any tips?
Thank you!
Bri
-
Hi @Brianna Young , thanks for reaching out. Sorry the video isn't working for you, I was able to view it by following the mp4 link. But let's see how help with your question..
You will probably have to create a customized version of the Form Submission Data report so that you can use SQL to look for the dynamic date range you are talking about. I'd just adjust the out of the box report to use Form Submission Date is grater than or equal to TIMESTAMPADD(SQL_TSI_DAY,-1, CURRENT_DATE).
If you haven't done that before, have a look at this post: https://community.oracle.com/topliners/discussion/4470670/insight-obiee-tips-commonly-used-sql-expressions
Good luck!
-
@Alexa Kalapaca-Oracle That SQL statement did the trick. Thank you so much!
