Hey Joel, Thank you for answering. How will be I able to pass 2 presentation variable in a single Add_months(date,n) formula. I have 2 presentation variables: Month and Year.

Thanks alot Gianni for your kind help, you are the best.

Totally agree with you Gianni. I will further explain my business logic Case: Tenure in Months of customer should be the no of months a customer has spend on your system. I will provide example also that I want to achieve on OBIEE, also Months_ between doesnt work on OBIEE so please help for alternative to achieve.…

Hi Gianni, My business case is to find out customer tenure from customer.customer created date dimension. Reply to your answer: I totally understand your point that I am using Timestampdiff and it will provide month level answer. But in my case what will be the answer then? As Month_between is Not available on OBIEE. What…

Thank you Gianni for your kind response, I totally understand your point. Although I have found the solution to both question posting below for other fellow member. 1- TIMESTAMPADD(SQL_TSI_DAY,- DAYOFWEEK(MIN(“Dim – Date”.” Date Column”)) + 1, MIN(“Dim – Date”.” Date Column”)) 2- "Your Times Table"."Your Date Column"…

Thank you Joel for your reply I am using correct SQL statement. Column prompt variable is not working for this filter whereas a standard presentation variable worked. But I want to integrate Column prompt presentation variable for this.