This content has been marked as final. Show 7 replies
You can get it done using presentation variable; make sure you convert it when you are using it in answers since date is passed as string to answers.
Any of these links helps you for the same
If helps pls mark or else let us know for issues
Thank you for your prompt response but I don't quite see the application of the examples you cited for filtering by the user selected date.
Please note the "Where" clause, or the date filter, is being applied to a field that is not displayed or selected as a column.
The desired behavior is that the sum(Payment_Amount) only uses Payment_Amounts prior to the user_selected_date.
Where and how can I apply this filter? Can you please elaborate?
---> Step # 7 shows how to add the filter, you can use CTRL+Click on Criteria or else add column apply the filter as shown and delete it from criteria
And the below are about presentation variable example my not fit 100% but you can get some info
Hope this helps
You've answered my second question but not my first:
1. In OBIEE Answers, how do I aggregate-sum the Payment_Amount by person_id, and case_number where
report_date <= (some user specified date), when report_date is not a specified column. Where do I specify the filter?
I think I figured this out with the help of the documentation you sent to me.
1. I added the report_date column to the report
2. I created a prompt to filter the report based on this column
3. I deleted the column from the report
It now filters on report_date even though report_date is not a specified column in the report.
Edited by: szzfrank on Jan 9, 2013 10:30 AM
Can you mark on any of last messages as correct?
In 10g, you could right click on the column and it would add it to the filters area without adding it to the request line. In 11g you can no longer right mouse click, but there is a little, very hard to find option to do it on the border menu line that separates the requests and filters area.
Or just do it the way you did, add the column, create the filter, and delete the column, probably easiest in 11g that way.