The hard restart of whole server fixed the problem.

Yes this could be easily achieved with simple JavaScript. Put this code to dashboard text box or create some static text within analysis. <span class="pln" style="font-style: inherit; font-weight: inherit; font-size: inherit; font-family: inherit; color: #303336;">setTimeout</span><span class="pun" style="font-style:…

Maybe next time, enjoy your free weekend :-)

Christian thanks for leading me to solution. I had to just little modify your command. So the working one is CAST('01/01/'||'@{YEAR}{2017}' AS DATE). Thank you all for your effort I hope I'll be able to help you too soon with anything :-)

hmmm maybe I need to retype you suggestion.... gimme a sec :-)

if I put this to value field in filter I got pop up window saying this, If I put this as SQL then it is not working either as without evaluate it can work with functions and operators as SQL: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code:…

So the YEAR("PERIOD".PERIOD") = @{YEAR}{2017} solution is not hitting partition because the db first convert all values to year so the report takes ages again. So the challenge is to keep period.period as it is and play with right side of condition.

Gianni, Christian, I did not the year function because I think it will not go through partitions in DB. But I will test it and let you now.

Hi Christian, the period is set to datetime accros all layers. Source DB is Oracle Database 12c Enterprise Edition Release 12.1.0.2.0. If I would now what is the bool and how it happened maybe I would be able to find some solution. But actually I'm quite despered about the BOOL type.

Hi Gianni, the whole process is like that. Users have dashboard prompt year. DB partions are set for Period. So the whole thing is about to construct query from BI which will limit data on period column (date) and therefore I use evaluate to get date from year. The original command is the below: "PERIOD"."PERIOD" BETWEEN…

Thanks Syed, I'm not sure if your provided links are related to my issue because under certain circumstances the command works. Or better It only works when I use = or IN

Thanks Robert for help, but your idea doesn't work. I'm getting still the same error. And I don't think this is the problem because if I change the operator to = or to IN: SELECT 0 s_0, s_1, s_2, s_3 FROM "BI_CUBE" WHERE ("PERIOD"."PERIOD" = (EVALUATE('TO_DATE(''20170101'',''YYYYMMDD'')'))) AND ("PROJECT"."NAME" = 'XXX')…