Home
Analytics
strange behavior with default parameter value
unknown
Hi<br />
<br />
On eclipse birt 2.6.0<br />
<br />
I put a parameter in a report, dynamic on a quarter's table. The parameter as a default value set in integer : 201112.<br />
My sql (dataset) request is linked to this value with <pre class='_prettyXprint _lang-auto _linenums:0'>where f.id_periode = ?</pre>
When I change this default value to 201203 for exemple, the sql request previsualization continue to give me the older dataset (201112) !!!<br />
But when I put manually <pre class='_prettyXprint _lang-auto _linenums:0'>where f.id_periode = 201203</pre> in the sql request the result is good.<br />
Is there a 'cache' for parameter ? I try to restart eclpise with -clean but there is no effect <br />
Any idee on this problem...<br />
<br />
my quick solution yet is to create another parameter and then all is ok...and if I change the default value, all is ok too !<br />
<br />
Yhanks in advance
Find more posts tagged with
Comments
Tubal
There is a cache for a dataset. Not sure if this is what's causing your problem, but it has caused me problems in the past.
If you click on your dataset, in your property window, there is an option called 'needs cache for data-engine'. I always make sure that is true.