Hi Gianni, As I sad to Christian I know this "Basically I'd like to echo one of his points: MODEL rather than SQL" But as I said before sometimes, just sometimes this is needed, or not for you? I want to listen what I do not know, Not what I already Know. This is my first time in this Oracle Community, So I am not sure…

Hahaha Christian, I know this "Basically I'd like to echo one of his points: MODEL rather than SQL" But as I said before sometimes, just sometimes this is needed, or not for you?, I just don't want to hear what I already Know, I want to hear what I do not know. From the beginning I always say information that is selected…

Hi Gianni, I already applied this logic: " with a CASE WHEN you can translate the month from a name to a number, and for the day you fix the number 1. Why the 1 when you look for the last one? Because every month always start by 1, so your logic will work all the time. You then make some calculations to get the last day of…

Hi Gianni, Thank you very much. I am going to give you more details about what I try to do, to be more exact and not missed relevant information for example. when a user select a month, in this case, January = 01/31/2017, or February = 02/28/2017, internally I want to convert this month to the last day of that month, then…

Right, the value that I need has nothing to do with the user information, as I said at the beginning it is based on a date (conversion date) that this user has selected, I am a little confused as well about why my question is so unclear because despite the fact that OBIEE is not to write SQL, sometimes this is needed, to…

Hi Tomas, I want to something similar, my exact example is the following: SELECT CONVERSION_RATE FROM GL_DAILY_RATES WHERE TRUNC(GDR.CONVERSION_DATE) =to_date(V_DATE, 'YYYY-MM-DD') AND GDR.FROM_CURRENCY ='CRC' AND GDR.TO_CURRENCY ='USD' AND GDR.CONVERSION_TYPE = '1001' in this case, I am going to return just one…

Hi Tomas, Thank you for your replay, I want to retrieve a value that is not included in any of my dimension table, this is outside in my database, so, I thought of Dynamic Repository Variables, I saw this sample, I know that NQ_SESSION.USERID is a session variable, well, I want to do something similar, like…

Hi Gianni, Thank you for your kind answer, I was talking about Dynamic Repository Variables, because the value that I want to retrieve is not in my time dimension, it is somewhere else. I saw this sample, I know that NQ_SESSION.USERID is a session variable, well, I want to do something similar, like NQ_SESSION.DATE, but I…