Hi, Try to find out week number using Date and add a week filter.

yes Thomos, I gree this is one time solution. I given to solve current requirement.

Hi, You want to show if the the Account no is 900654 then 'Space Rental' use case statement. edit formula write like below: Ex Case when accountnumber=900654 then 'Space Rental' casw when accountnumber=900760 then 'Administrative Overhead' else accountnumber end

i think approach is correct. before the user execting the query you are executing using agent and cached the result. I did the same way for my requirement. Please check is second query is cached or not. if cached it is hitting the cached query or not. work on cache management properly

Using Job Manager you can schedule the purge scripts.

create a second prompt using the sql statement select Column value from table where column name = @{Fistpromptval} (Presentation variable) hope this will help you

Hi, are you tried LIMIT VALUES BY option dashborad column property.

Create a filter or Column which displays greater than last three week. 1. Create Var_Current_Week Variable (Always give current Week) 2. Put a filter condtion like Current_Week>VALUEOF("Current_Week")-3

Hi, Instead of using defalut WebLogic Domain Name & try and use your own WebLogic Domain Name. it may help

As Christian Berg suggested it is not obiee functionality. but you can achieve this by writing some java script. I don't have readily available tutorial.

Thanks For your reply. How can I pass Last three months value. Can you guide me in details. Thanks in Adavance