Datas not updating with JasperServer

[hunt69]

Hi! (I'm french so my english is not so good :)

 

I use JasperETL, JasperAnalysis Workbench and JasperServer :

 

with JasperETL, I extracted datas from an EXCEL file and I put datas in a Postgres table, it's works correctly !

 

Then, I have build an OLAP schema with the workbench to simply calculate shows an average of one on the columns of the table.

 

Finally, I build an analysis with JasperServer to see the graphic.

 

Every part works correctly, BUT I schedulded my job with JasperETL and the job is no runnning every 5 minutes. During this time, I change datas on my EXCEL file and SURPRISE, the graphic shows by JasperServer didn't change ! It was the same !

 

I look in the table and datas has change !! The average wasn't the same !

 

So maybe JasperServer didnt't work how I think ? Maybe the problem comes from the OLAP schema ! I try to download it again in JasperServer and I update the anaylis, nothing change !

 

Anyone has an idea?

 

Thanks a lot,

 

Regards,

 

Teddy

[jens_noering]

Hi,

 

you have to flush the olap- cache of jasperanalysis if you want to see the new result.

jasperanalysis stores the result of mdx queries in olap- cache to speed up querying, so the new figures are only visible after cash-flushing.

You can configure your cube to not cache the results. than your new loaded data should be visible.

 

<Cube name="customers" enabled="true">

becomes

<Cube name="customers" cache="false" enabled="true">

 

hth,

Post edited by: jens_noering, at: 2008/06/30 13:41

[hunt69]

Perfect ! Thanks you !