hunt69 Posted June 30, 2008 Share Posted June 30, 2008 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 Link to comment Share on other sites More sharing options...
jens_noering Posted June 30, 2008 Share Posted June 30, 2008 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 Link to comment Share on other sites More sharing options...
hunt69 Posted June 30, 2008 Author Share Posted June 30, 2008 Perfect ! Thanks you ! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now