Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Need help on showing last 6 months based on prompt

784355Jul 19 2011 — edited Jul 19 2011
Hello,

I have a requirement like this
I have a table which shows data for last 6 months.
Now i am having the filter which takes the data from sysdate and sysdate minus 6 month.like this
Now what i want is

To have a radiobutton which when clicked should exclude the current month
so its like,so should show
current_date minus 1 month to current_date minus 7 month.
So that total it must show 6 months.

Any idea on how to do this?

Now i am doing like in filter

"DATEADDED" <= CURRENT_DATE
AND
"DATEADDED" >=
TIMESTAMPADD(SQL_TSI_MONTH, -5, TIMESTAMPADD(SQL_TSI_DAY, -(DAY(CURRENT_DATE)-1), CURRENT_DATE))

By default this should come but when check the radiobutton

should come the way i wnated?

using obiee 11g

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2011
Added on Jul 19 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
3 comments
1,303 views